ExcelWorkbook Methods |
The ExcelWorkbook type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | Close |
Closes the workbook and releases all the resources.
|
| DisableFormulaCalculations |
Disable formula calculations for all the sheets existing in the workbook at the current time.
|
| EnableFormulaCalculations |
Enable formula calculations for all the sheets existing in the workbook at the current time.
|
 | LoadFromCsv(Stream, String, ExcelWorkbookFormat) |
Loads a CSV stream into a worksheet. The default encoding of the text in CSV is assumed to be UTF-8.
The values from CSV will be imported in the top left corner of the worksheet.
|
| LoadFromCsv(String, String, ExcelWorkbookFormat) |
Loads a CSV file into a worksheet. The default encoding of the text in CSV is assumed to be UTF-8.
The values from CSV will be imported in the top left corner of the worksheet.
|
| LoadFromCsv(Stream, Encoding, String, Int32, Int32, ExcelWorkbookFormat, ExcelWorkbookDefaultSettings) |
Loads a CSV stream into a worksheet.
|
| LoadFromCsv(String, Encoding, String, Int32, Int32, ExcelWorkbookFormat, ExcelWorkbookDefaultSettings) |
Loads a CSV file into a worksheet.
|
| Save |
Saves the Excel workbook as byte array that can be further saved into a file or send over HTTP.
The output format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx) is the current format of the workbook.
|
| Save(Stream) | A
Saves the workbook in the specified stream.
The output format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx) is the current format of the workbook.
|
| Save(String) |
Saves the workbook as the specified file.
The output format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx) is the current format of the workbook.
|
| Save(HttpResponse, String) |
Saves the workbook to the specified HttpResponse.
The output format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx) is the current format of the workbook.
|
| Save(HttpResponse, String, Boolean) |
Saves the workbook to the specified HttpResponse.
The output format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx) is the current format of the workbook.
|
| SaveToCsv(Int32, Stream, String) |
Saves the worksheet at the specified index to a stream in CSV format. The default UTF-8 text encoding is used when saving the output stream.
|
| SaveToCsv(Int32, String, String) |
Saves the worksheet at the specified index to a file in CSV format. The default UTF-8 text encoding is used when saving the output file.
|
| SaveToCsv(Int32, Stream, String, Encoding) |
Saves the worksheet at the specified index to a stream in CSV format using the specified text encoding for the output.
|
| SaveToCsv(Int32, String, String, Encoding) |
Saves the worksheet at the specified index to a file in CSV format using the specified text encoding for the output file.
|
| UpdateFormulaResult |
Calculate formula results for all the worksheets in the workbook
|
See Also