Collapse All Expand All

This topic summarizes how Spread exports the data from a Spread control to an Excel-formatted file. When bringing an Excel-formatted file into Spread (importing) and when saving Spread files to an Excel format (exporting), not all of the content and features are preserved. The intention of the import and export capability is to handle as much of the data and formatting of a spreadsheet or set of spreadsheets as possible. The results of the export operation is summarized in these topics:

• Chart Settings Exported
• Sheet Settings Exported
• Row and Column Settings Exported
• Cell Settings Exported
• Cell Type Settings Exported
• Print Settings Exported
• Colors Exported

For more information on the options available for saving to Excel, refer to the SaveExcel methods in the FpSpread class, and the ExcelSaveFlags enumeration. The options available with the enumeration include these options for saving the spreadsheet to Excel (see the Assembly Reference for a complete list):

• Document caching
• Save only the data
• Save the displayed data but not the formulas
• Save custom row or column headers or both
• Save rows as they are filtered
• Save the spreadsheet as viewed
• Save the appearance settings (styles) of alternating rows
• Use custom color palette for color approximations
• Use Excel 2007 (OfficeOpen XML) format

You can save to Excel 2007 (Office Open XML) if you set the ExcelSaveFlag.UseOOXMLFormat option.

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback