Saturday, October 11, 2008  
 HOME
          


 FarPoint Technologies
 (800) 645-5913
 fpsales@fpoint.com



     
 »Spread for Windows Forms » Product Tour » Excel Compatibility

Previous Importing and Exporting Microsoft Excel Files Next

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 the entire multiple-sheet file into the FarPoint Spread component or specify a particular sheet (either by name or number) and open it into a specific sheet. 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 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.


 
    
 Have a question?
Have a Question? Ask Us!
Subscribe to the RSS feed!RSS Subscribe
 

 
Learn about the new Roadshow now!
Tour Home
Annotation Mode
Auto Complete
Borders
Cell Notes
Cell Types
Conditional Formatting
Control Layer
DataBinding
Drag Drop
DragFill
Excel Compatibility
Filtering
Fonts/Colors
Formulas
Formula Textbox
Freezing Rows/Columns
Grouping
Grouping Excel-like
Hierarchy
Import Export
Merging
Move Rows/Columns
MultipleHeaders
OperationModes
Printing
Printing to PDF
Reporting
Search
Shapes
Sheets
Sorting
Spans
Spread Designer
SubEditors
Unbound
Undo/Redo
Viewports
Zoom
Rate this tour



Copyright © 1991-2007 FarPoint Technologies, Inc. All rights reserved. All names are property of their respective owners.