|
»Spread for Windows Forms
» Product Tour
» Excel Compatibility
|
|
jump to:
|
|
Excel Compatibility |
|
You can import data from and export data (and formatting) to Microsoft Excel, both in individual spreadsheets and entire workbooks. Several Excel document formats are supported, including Excel 97 - Excel 2003 (xls), Excel 2007 XML (xlsx), comma-delimited (csv) and tab-delimited (txt).
.
You can open an entire multiple-sheet Excel file into the FarPoint Spread component or specify a particular sheet (either by name or number) and open it into a specific sheet in Spread. Use one of the OpenExcel methods of the FpSpread class to open all the sheets in the Excel file, providing the path and file name for the file to open and any additional information. There are several OpenExcel methods with OpenFlags options. These options allow you to determine how frozen columns and rows are imported, if data only is imported, and other import features.
You can also open password proteced files.
Learn about formula support.
Document Caching
Spread Document Caching technology allows users to edit Microsoft® Excel® Documents without losing advanced document content such as Macros, VBA, data connections, ActiveX Controls, … With Spread, you have always been able to integrate Excel Documents into your applications which allows you to programmatically dictate what data is viewed and modified, and how the data is presented and formatted. Spread Document Caching takes Excel Document integration to the next level by caching the Excel document content that Spread does not use, and inserting the cached document content back into your Excel Documents as they are saved.
Password Protected Files
Spread now allows you to Open and Save Excel File-Access Password Protected Documents. Your applications can now access and create Password protected Excel documents and provide you with the same level of document protection promised by Microsoft.