OpenXml(XmlReader) Method

Reads the XML stream to build a new worksheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenXml( _
   ByVal reader As System.Xml.XmlReader _
)

'Usage
 
Dim instance As Worksheet
Dim reader As System.Xml.XmlReader
 
instance.OpenXml(reader)

public void OpenXml( 
   System.Xml.XmlReader reader
)

Parameters

reader: The XML reader.

Example

This example uses the OpenXml method.

//WPF
System.Xml.XmlTextReader reader = new System.Xml.XmlTextReader("C:\\controls\\SpreadX\\1.0.1.0\\WPF\\Samples\\Codes\\Spread Templates\\1040.ssxml");
gcSpreadSheet1.Sheets[0].OpenXml(reader);
//Silverlight
System.Xml.XmlReader xr = System.Xml.XmlReader.Create(fileName);
gcSpread1.ActiveSheet.OpenXml(xr);

VB.NET

'WPF
Dim reader as New System.Xml.XmlTextReader("C:\controls\SpreadX\1.0.1.0\\WPF\Samples\Codes\Spread Templates\1040.ssxml")         
gcSpreadSheet1.Sheets[0].OpenXml(reader)
'Silverlight
Dim xr As New System.Xml.XmlReader.Create(fileName)
GcSpread1.ActiveSheet.OpenXml(xr)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members
Overload List