-
Notifications
You must be signed in to change notification settings - Fork 275
Export data
Mats Alm edited this page Dec 4, 2023
·
9 revisions
From the Cells
property (ExcelRange
) you can access these methods to write:
-
ToText
andToTextAsync
- Writes a range to a string in a text file format like csv or tsv. -
SaveToText
andSaveToTextAsync
- Writes a range to a text file like csv or tsv. -
ToDataTable
- Exports data from a range to aSystem.Data.DataTable
-
ToCollection
- Exports data from a range to anIEnumerable<T>
where T is a class. -
ToJson
- Exports data from a range to Json. -
CreateHtmlExporter
- Exports data from a range to html/css. -
GetValue<T>
- Gets a value, with the option to specify a datatype -
Value
- Gets or sets the value of the range.
EPPlus Software AB - https://epplussoftware.com
- Getting Started
- The Sample Project
- EPPlus and Docker
- EPPlus and Blazor
- EPPlus and Linux
- Security
- Configuration
- Releases/versioning
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles