The ExcelWorkbook type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
 | Close |
Closes the workbook and releases all the resources.
|
| Equals | (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
 | 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.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| 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 .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 .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 .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.
|
| SaveToCsv(Int32, Stream, String, Encoding, Boolean) |
Saves the worksheet at the specified index to a stream in CSV format using the specified text encoding for the output.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UpdateFormulaResult |
Calculate formula results for all the worksheets in the workbook
|
See Also