Overload List
| Overload | Description |
|---|---|
| SaveExcel(Stream) | Saves the contents of the Spread component to the specified stream. |
| SaveExcel(Stream,String) | Saves the contents of the Spread component to the specified stream. |
| SaveExcel(Stream,ExcelWarningList) | Saves the contents of the Spread component to the specified stream with a list of warnings. |
| SaveExcel(Stream,ExcelSaveFlags) | Saves the contents of the Spread component to the specified stream with the headers exported as data. |
| SaveExcel(Stream,ExcelSaveFlags,String) | Saves the contents of the Spread component to the specified stream with the headers exported as data. |
| SaveExcel(Stream,ExcelSaveFlags,ExcelWarningList) | Saves the contents of the Spread component to the specified stream with headers and a list of warnings. |
| SaveExcel(Stream,ExcelSaveFlags,ExcelWarningList,String) | Saves the contents of the Spread component to the specified stream with headers and a list of warnings. |
| SaveExcel(String,ExcelSaveFlags) | Saves the contents of the Spread component to the specified Excel-compatible file with the headers exported as data. |
| SaveExcel(String,ExcelSaveFlags,String) | Saves the contents of the Spread component to the specified Excel-compatible file with the headers exported as data. |
| SaveExcel(String,ExcelSaveFlags,ExcelWarningList) | Saves the contents of the Spread component to the specified Excel-compatible file with headers and a list of warnings. |
| SaveExcel(String,ExcelSaveFlags,ExcelWarningList,String) | Saves the contents of the Spread component to the specified Excel-compatible file with headers and a list of warnings. |
| SaveExcel(String) | Saves the contents of the Spread component to the specified Excel-compatible file. |
| SaveExcel(String,String) | Saves the contents of the Spread component to the specified Excel-compatible file. |
| SaveExcel(String,ExcelWarningList) | Saves the contents of the Spread component to the specified Excel-compatible file with a list of warnings. |
| SaveExcel(String,IncludeHeaders) | Saves the contents of the Spread component to the specified Excel-compatible file with the headers exported as data. |
| SaveExcel(String,IncludeHeaders,ExcelWarningList) | Saves the contents of the Spread component to the specified Excel-compatible file with headers and a list of warnings. |
Remarks
These methods provide various ways to save data to an Excel file. You can specify the path and file name, whether to include the headers, and a list of the warnings.
These methods save the contents of the sheets of the Spread component to an Excel-compatible BIFF8 (Binary Interchange File Format, version 8 from Microsoft) file. This is the file format for several versions of Microsoft Excel (Excel 97, Excel 2000, and Excel XP).
Document caching (ExcelSaveFlags) allows users to open, edit, and save without the loss of advanced document content and formatting. The content can be lossless only if the opening file format is similar to the saving file format. If the advanced document content uses files besides the xls(x) file, then the additional files need to be in the same folder with the xls(x) file. Advanced content could be macros, ActiveX controls, data connections, etc...
Make sure that none of the sheet names (SheetName property) have characters that are considered invalid sheet names in Excel. The following characters are invalid for Excel sheet names:
? (question mark)
/ (forward slash)
\ (backward slash)
* (asterisk)
[ (left bracket)
] (right bracket)
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2