-
Spread Windows Forms Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Opening an XML Data File
Spread allows you to load and open an XML data file in the workbook. You can do this by using the OpenXML method of the IWorkbooks interface which accepts string type filename/stream as its parameter and returns an IWorkbook object.
Opening XML data file using filename
The following code is used to open a data file using filename.
// Opening XML data file in workbook using string type filename
fpSpread1.Attach(fpSpread1.AsWorkbook().WorkbookSet.Workbooks.OpenXML("D:\\DataFormat.xml"));' Opening XML data file in workbook using string type filename
FpSpread1.Attach(FpSpread1.AsWorkbook().WorkbookSet.Workbooks.OpenXML("D:\DataFormat.xml"))Opening XML data file using stream
The following code is used to open a workbook using stream parameter.
// Opening XML data file in workbook using stream
System.IO.FileStream stream = new System.IO.FileStream("D:\\DataFormat.xml", System.IO.FileMode.Open, System.IO.FileAccess.Read);
fpSpread1.Attach(fpSpread1.AsWorkbook().WorkbookSet.Workbooks.OpenXML(stream));' Opening XML data file in workbook using stream
Dim stream As System.IO.FileStream = New System.IO.FileStream("D:\DataFormat.xml", System.IO.FileMode.Open, System.IO.FileAccess.Read)
FpSpread1.Attach(FpSpread1.AsWorkbook().WorkbookSet.Workbooks.OpenXML(stream))