Version

Export(UltraGrid,Workbook,Int32,Int32) Method

Exports the passed in ultragrid to the specified workbook in the active worksheet starting at the specified row and column. If there are no worksheets in workbook, new worksheet is created. It returns the passed in workbook.
Syntax
'Declaration
 
Public Overloads Function Export( _
   ByVal grid As Infragistics.Win.UltraWinGrid.UltraGrid, _
   ByVal workbook As Infragistics.Documents.Excel.Workbook, _
   ByVal startRow As Integer, _
   ByVal startColumn As Integer _
) As Infragistics.Documents.Excel.Workbook
public Infragistics.Documents.Excel.Workbook Export( 
   Infragistics.Win.UltraWinGrid.UltraGrid grid,
   Infragistics.Documents.Excel.Workbook workbook,
   int startRow,
   int startColumn
)

Parameters

grid
Grid to export.
workbook
Destination Infragistics.Documents.Excel.Workbook.
startRow
Start row for exported data (zero based).
startColumn
Start column for exported data (zero based).

Return Value

Destination Infragistics.Documents.Excel.Workbook.
Example
Following code shows how to use different Export overloads.

private void button2_Click(object sender, System.EventArgs e)
{
	// overload 1
	this.MyGridExporter.Export(this.ultraGrid1, "Test1.xls");
}

private void button3_Click(object sender, System.EventArgs e)
{
	// overload 2
	Workbook wb1 = this.MyGridExporter.Export(this.ultraGrid1);

	wb1.Save("Test2.xls");

	Workbook wb2 = new Workbook();

	// overload 3
	this.MyGridExporter.Export(this.ultraGrid1, wb2);

	Worksheet secondWS = wb2.Worksheets.Add("SecondSheet");

	// overload 4
	this.MyGridExporter.Export(this.ultraGrid1, secondWS);

	wb2.Save("Test3.xls");

	Workbook wb3 = new Workbook();

	// overload 5
	this.MyGridExporter.Export(this.ultraGrid1, wb3, 1, 2);

	Worksheet someWS = wb3.Worksheets.Add("SomeSheet");

	// overload 6
	this.MyGridExporter.Export(this.ultraGrid1, someWS, 2, 3);

	wb3.Save("Test4.xls");
}
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
    ' overload 1
    Me.MyGridExporter.Export(Me.UltraGrid1, "Test1.xls")
End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
    Dim wb1, wb2, wb3 As Workbook
    Dim secondWS, someWS As Worksheet

    ' overload 2
    wb1 = Me.MyGridExporter.Export(Me.UltraGrid1)

    wb1.Save("Test2.xls")

    wb2 = New Workbook()

    ' overload 3
    Me.MyGridExporter.Export(Me.UltraGrid1, wb2)

    secondWS = wb2.Worksheets.Add("SecondSheet")

    ' overload 4
    Me.MyGridExporter.Export(Me.UltraGrid1, secondWS)

    wb2.Save("Test3.xls")

    wb3 = New Workbook()

    ' overload 5
    Me.MyGridExporter.Export(Me.UltraGrid1, wb3, 1, 2)

    someWS = wb3.Worksheets.Add("SomeSheet")

    ' overload 6
    Me.MyGridExporter.Export(Me.UltraGrid1, someWS, 2, 3)

    wb3.Save("Test4.xls")
End Sub
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also