YG
Yavanaarasi G
Syncfusion Team
August 7, 2008 12:32 PM UTC
Hi Kjell,
I regret to let you know that it is not possible to export the excel data directly from the dataset using our XlsIO and we can only export as Data table by using ExportDataTable method. Please refer the below code snippet:
[VB]
'Read data from spreadsheet and export to datagrid
Dim customersTable As DataTable = sheet.ExportDataTable(sheet.UsedRange,ExcelExportDataTableOptions.ColumnNames)
Me.dataGrid1.DataSource = customersTable
'Import the data from grid to excel sheet
sheet1.ImportDataTable(CType(Me.dataGrid1.DataSource, DataTable),True,3,1,-1,-1)
Please refer our shipped browser sample that demonstrates how to export and import the data:
\\Syncfusion\EssentialStudio\6.3.0.30\Windows\XlsIO.Windows\Samples\2.0\Data Binding\ImportExportDataTable\VB
Please try this and let me know if this helps.
Regards,
G.Yavana