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.
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.