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 component to a Microsoft Excel-compatible BIFF (Binary Interchange File Format) file. BIFF8 (Binary Interchange File Format, version 8 from Microsoft) is the file format for several versions of Microsoft Excel (Excel 97, Excel 2000, and Excel XP). Use the UseOOXMLFormat option in the ExcelSaveFlags enumeration to save to the xlsx format.

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.

In order to keep any document caching settings (changes would be lost during a postback), open the original file with the document caching only setting and then save the file using the document caching setting.

The memory stream must be able to seek when saving to a BIFF8 formatted file using a memory stream.

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)

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Reference

User-Task Documentation

External