EPPlus 5/6

기능 및 기술 개요

기능 및 기술 개요

EPPlus

EPPlus는 Nuget을 통해 배포되는 Office Open XML 스프레드시트를 관리하기 위한 .NET Framework/.NET Core 라이브러리입니다. 버전 5는 버전 3.5의 .NET Framework와 버전 2.0의 .NET Core를 지원합니다. EPPlus는 Microsoft Excel과 같은 다른 라이브러리에 대한 종속성이 없습니다.

라이브러리는 개발자를 염두에두고 설계되었습니다. 우리의 목표는 항상 Excel 또는 다른 스프레드 시트 라이브러리에 대한 지식을 가진 개발자가 API 속도를 쉽게 높일 수 있어야한다는 것이 었습니다. 또는 - 누군가가 말했듯이 - 승리로가는 길을 인텔리 센스!

EPPlus 5/6 뉴스

워크시트 범위 및 테이블에서 html/CSS 내보내기 새로운!
워크시트 범위 및 테이블에서 json 데이터 내보내기 새로운!
이전보다 더 많은 이미지 유형 지원 - svg, ico 및 webp 새로운!
System.Drawing.Common/GDI에 대한 종속성 제거 - non-Windows 환경에서 원활하게 작동합니다. 새로운!
모든 Excel 2019 차트 종류를 새롭고 현대적인 스타일로 지원
워크시트의 범위 삽입/삭제 및 표의 행/cols
피벗 테이블에 대한 확장된 지원 - 필터, 계산된 열, 공유 캐시 지원, 자동 정렬 및 데이터 필드의 "다른 이름으로 값 표시"
피벗 테이블 및 테이블 슬라이서
사용자 지정 테이블, 피벗 테이블 및 슬라이서 스타일
피벗 영역을 통한 피벗 테이블 스타일 지정
수식 계산 엔진 및 181개의 새로운 지원 기능 개선
멘션을 지원하는 스레드 주석
워크시트로 dynamic/ExpandoObject 가져오기 및 LoadFromCollection 메서드의 기능을 확장하는 새로운 특성 집합을 지원합니다.
워크시트에서 파일 및 DataTable로 데이터 내보내기 지원
I/O 작업을 위한 비동기 메서드
테마, 필터, 오류 무시
양식 제어 및 도면 그룹화 지원
외부 링크
향상된 정렬 - 상태 정렬, 왼쪽에서 오른쪽 및 사용자 지정 목록 정렬 및 피벗 테이블에서 자동 정렬
Fill의 새로운 Copy 기능 및 향상된 Ranges방법 .
Split worksheet into panes
행과 열에 쉽게 액세스 - Worksheet.Rows, Worksheet.Columns, Range.EntireRow 및 Range.EntireColumn
사소한 새로운 기능 및 수정 된 문제

지원되는 기능

General features

  • Create, read and modify Office Open XML workbooks (xslx and xlsm)
  • Supports both .NET Framework and .NET Core. No difference in feature set between the frameworks.
  • Provides an easy to use, strongly typed, programming interface, which is closely related to the well-known Excel VBA API.
  • Managed code only, no dependencies to Microsoft Excel
  • Battle-hardened codebase after many years as the worlds most downloaded .NET library for managing spreadsheets. Quality ensured by thousands of unit-tests.
  • The source code for EPPlus is openly available on Github , distributed under the Polyform Noncommercial license

Performance (large workbook)

EPPlus 5.3.2 creates the following workbook and writes it to disk in approximately 47 seconds (i7 CPU 1.8 Ghz, 16 GB RAM, SSD, Win10, .NET Core 3.1). It loads the same workbook from disk into an ExcelPackage instance in approximately 32 seconds.

  • 200 columns
  • 100,000 rows
  • 50% of the data written to the cells are integers, 50% are strings with a length of 36 characters
  • Workbook size: 65 Mb

Feature list

  • Workbook
    • Document/Printer settings
  • Worksheets
    • Supports 1,048,576 rows and 16,384 columns
    • Add, remove, re-order, rename, hide/unhide worksheets in a workbook
    • Copy worksheets within a workbook or to another workbook with maintained styling and shifting of addresses/references.
    • Print areas
    • Header/Footer
    • Page breaks
    • Split/Freeze/unfreeze panes
    • Merge cells
    • Autofit columns
    • Altering worksheet properties such as gridlines, tab colors, etc.
  • Cell Ranges
    • Create, modify, delete, hide/unhide cells or entire ranges
    • Access to Row and Column properties via the EntireRow and EntireColumn properties
    • Sort ranges
      • Multiple sort params
      • Sort Top to Bottom (by column)
      • Sort Left to Right (by row)
      • Ascending, Descending or User defined (Custom List) sortorder.
      • Updates Sort State in the Office Open XML.
    • Insert/delete ranges - depending addresses will be shifted.
    • Copy ranges to a new address with maintained styling and addresses/reference shifting within a workbook or to another workbook. Exclude different cell properties in the copy operation.
    • Copy styles only.
    • Fill ranges
      • FillNumber
      • FillDateTime
      • FillList
    • Named ranges
    • The cell store supports IEnumerable, so Cells/Ranges can be queried with Linq
  • Cell Styling
    • Number
    • Alignment
    • Font
    • Fill
    • Border
    • Protection
    • Wrap text, text rotations and more
    • Named Styles
  • Formula calculation
    • Built-in calculation engine with no dependency to Excel or any other library
    • Calculate entire workbook, a worksheet or a single range
    • Supports 337 of the most common functions
    • Calculates External links
    • Support for named ranges and the R1C1 format.
    • Add custom functions in runtime
  • Import/export data to and from worksheets
    • Import data into a formatted table from enumerables of objects, arrays, DataSets, DataReaders, text-files, etc., with just one line of code.
    • Export data to csv files, strings, json, html/css, data tables or streams with many configuration parameters
  • Supports load and save from/to both files and streams
    • Can create workbooks in a web application and write to the response stream without file access.
    • Get workbook as byte-array
    • Supports async/await
  • Templates
  • Auto filters/Table Filters
    • Create, read, modify, apply and delete filters of the types below:
      • Value filters
      • Date/Time filters
      • Custom filters
      • Top 10 filters
      • Dynamic filters
  • Data validation
    • Create, read, modify, delete Data validations
    • Types of validations supported: Integer (whole in Excel), Decimal, List, Date, Time, Any and Custom.
    • Strongly typed interface for each validation type
  • Conditional Formatting
    • Create, read, modify Conditional formatting
    • 45 types of conditional formatting supported
    • Strongly typed interface for each conditional formatting type
  • Tables
    • 60 predefined styles
    • Create and modify custom table styles from scratch or using a built-in style as template.
    • Sort table with updated sort state
    • Support for adding and deleting rows/columns (with shifting)
    • Total row with predefined functions (supported by the built-in Formula calculation)
    • Adding, modifying and applying filters
    • Adding, modifying or removing table slicers
    • Export table to a System.Data.DataTable
    • Export table to a JSON
    • Export table to html/css
  • Pivot Tables
    • 84 predefined styles
    • Create and modify custom pivot table styles from scratch or using a built-in style as template.
    • Style your pivot table using pivot areas
    • Add, modify or remove row, column, page and data fields.
    • Support for 12 different data field functions.
    • Support for numeric and date grouping
    • Adding calculated fields
    • Support for adding, modifying filters.
    • Adding, modifying or removing pivot table slicers
  • Slicers
    • Adding, modifying or removing table- and pivot table- slicers
    • 14 predefined styles
    • Create and modify custom slicer styles from scratch or using a built-in style as template.
  • Hyperlinks
  • Comments
    • Create, read, modify and delete comments (in later Excel versions renamed to Notes)
    • Rich-text supported
    • Threaded comments with support for mentions, resolve/re-open threads
  • Shapes
    • 187 different types of shapes supported
    • Position, size, border, text, styling, color/gradient/effect/shadow, etc
  • Pictures
    • Supports adding images from file, stream or a System.Drawing.Image object
    • Formats: jpg, gif, png, tiff, bmp, emf (Windows only), wmf (Windows only)
  • Form Controls
    • Supports adding, modifying and removing nine different types of form controls
    • Support to connect controls to VBA macros, link to cells and more.
  • Charts
  • Sparklines
    • Create, read, modify and delete Sparklines
    • Line
    • Column
    • Win/loss
  • Themes
    • Load themes from thmx-files
    • Modify current theme
  • External Links
    • Updating the external workbook cache (xlsx, xlsm and xlst).
    • Adding references to external workbooks.
    • Breaking links to external workbooks.
    • Retaining OLE and DDE links (available read only).
    • Formula calculation via the external workbook cache or via loading and calculating the external package directly.
  • Protection
    • Protect workbooks with password
    • Open protected workbooks with password
    • Protect workbook, worksheets or ranges
    • Set workbooks to read-only with a password
  • Encryption
    • Encrypt/decrypt workbooks
    • Supports both Standard (Older office versions) and Agile encryption (Office 2010 and later)
  • VBA
    • Create, read, delete, modify VBA code/modules
    • Sign VBA code with certificates
    • Password protect VBA projects
  • Supported formats
    • Reads and writes xlsx, xlsm. Please note that EPPlus does not support the xlsx Strict format.
    • Reads xltx, crtx, thmx
    • Reads and writes txt, csv via the LoadFromText and SaveToText methods