Name | Description | |
---|---|---|
![]() | AddWorksheet | Overloaded. Add a worksheet to a workbook with a default name |
![]() | FillFromClassList<T> | Fill a worksheet using data from the passed in list |
![]() | FillFromCsvFile | Fill a worksheet using data from a CSV file |
![]() | FillFromCsvStream | Fill a worksheet using data from a CSV stream |
![]() | FillFromCsvString | Fill a worksheet using data from a CSV string |
![]() | FillFromDataTable | Fill a worksheet with a data table. Use default formatting or the formatting specified in the Worksheet. |
![]() | GenerateFromClassList | Overloaded. Creates an Excel file based on the properties of the passed in object. Supports all value types plus reference types of string and DateTime. By default, puts in a header with the names of the properties. |
![]() | GenerateFromCsvStream | Turn a CSV string into an Excel Workbook |
![]() | GenerateFromCsvString | Turn a CSV string into an Excel Workbook |
![]() | GenerateFromDataTable | Overloaded. Creates an Excel file based on the data columns of the passed in DataTable Supports all value types plus reference types of string and DateTime. By default, puts in a header with the names of the properties. |
![]() | ReplaceValuesInExcel | Open an excel file and replace values in it and save it to another file. This is useful for having an Excel template and creating a report from it like mail merge |
![]() | SaveWorkbook | Overloaded. Save the passed workboook to .xlsx file specified by workbook.FilePath |
![]() | WorkbookFactory | Creates a new Workbook In Memory |