OpenXml Method (GcSpreadSheet)

Loads the data on the sheet from the specified XML stream.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub OpenXml( _
   ByVal xmlStream As System.IO.Stream _
)

'Usage
 
Dim instance As GcSpreadSheet
Dim xmlStream As System.IO.Stream
 
instance.OpenXml(xmlStream)

public void OpenXml( 
   System.IO.Stream xmlStream
)

Parameters

xmlStream: The XML stream.

Example

This example uses the OpenXml method.

OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Xml File (.xml)|*.xml";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = openFileDialog.File.OpenRead();
    stream.Seek(0, System.IO.SeekOrigin.Begin);
    gcSpreadSheet1.OpenXml(stream);               
    stream.Dispose();
}

VB.NET

Dim openFileDialog = New OpenFileDialog()
openFileDialog.Filter = "Xml File(.xml)|*.xml"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = openFileDialog.File.OpenRead()
    stream.Seek(0, IO.SeekOrigin.Begin)
    GcSpreadSheet1.OpenXml(stream)
End If

Reference

GcSpreadSheet Class
GcSpreadSheet Members