FarPoint's Spread for Windows Forms Product Tour

Opening a Spread XML File
Spread can open data or data and formatting from an XML file or a stream into the Spread control. `' Open a Spread-compatible XML file FpSpread1.Open("c:\spreadFile.xml")`

Opening an Excel File
You can open an existing Excel-formatted file (BIFF8 format) or a comma-delimited file. You can open the entire multiple-sheet file into the Spread control or specify a particular sheet (either by name or number) and open it into a specific sheet in Spread. There are several OpenExcel methods with an openFlags option. This option allows you to determine how frozen columns and rows are imported, if data only is imported, and other optional aspects. `' Open Excel sheet #2 into Spread's sheet #3 FpSpread1.OpenExcel("c:\excelFile.xls", 3, 2)`

Opening a Spread 7 File
For backward compatibility, you can open an existing file from Spread 7 (a COM version of Spread). `' Open Spread 7 file into the active sheet fpSpread1.ActiveSheet.OpenSpreadFile("c:\\comFile.ss7")`

Opening a Custom Text File
You can open existing text files that are delimited, either files saved from Spread or delimited text files from other sources. If the file uses custom delimiters, you need to specify the delimiters so the control can correctly place the data within the sheet. If your file uses standard tab-delimited format, you need not use a method that lets you specify delimiters. `' Open a tab delimited file FpSpread1.ActiveSheet.LoadTextFile("c:\\textFile.txt", True)`