Skip to content

Replies

0
Wolfgang
Wolfgang answered on Nov 28, 2009 3:51 AM

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?