I have the same issue:
This code doesn't work (Excel sheet is emtpy, ds.tables(0).rows.count shows 50!):
Private Function PrepareGrid4Export(ByVal locgrid As UltraWinGrid.UltraGrid) As UltraWinGrid.UltraGrid
Dim NewGrid As New UltraWinGrid.UltraGrid Dim strDisplayout As String = "TEST.xml" My.Computer.FileSystem.DeleteFile(strDisplayout)
locgrid.DisplayLayout.SaveAsXml(strDisplayout)
NewGrid.DataSource = locgrid.DataSource
NewGrid.DataMember = locgrid.DataMember
NewGrid.DataBind()
NewGrid.DisplayLayout.LoadFromXml(strDisplayout)
exporter.Export(NewGrid, "TEST.xls")
Trying with
exporter.Export(locgrid, "TEST.xls")
the excel is filles with 50 rows!
any ideas?