I have done what you have described. I used 3 separate grids on a tab control. The grid itself does not have a tab funtion to it.
When exporting you would just pick the worksheet in the workbook you are exporting to. Something like this:
Dim objExcelWorkBook As Workbook = New Workbook
objExcelWorkBook.add("Worksheet1")
objExcelWorkBook.add("Worksheet2")
objExcelWorkBook.add("Worksheet3")
UltraGridExcelExporter.Export(ultragrid2, objExcelWorkBook.Worksheets("Worksheet2"), 0, 0)
UltraGridExcelExporter.Export(ultragrid3, objExcelWorkBook.Worksheets("Worksheet3"), 0, 0)
I hope this helps
thank you very much for this. I had gotten close to this. But my question is how does this save out to the PC?
For instance when exporting a single grid I use the following;
strSaveFileAs = "C:\Rpt_Orders_RunBy_Yoda.xls"
uwgExcelExporter.Export(uwGridRptResults, strSaveFileAs)
This works fine to create the xcel doc on the C: drive.
In your code I don't see an area to put this, strSaveFileAs , parameter?
Thanks
Deasun.