| 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 |