hi
i have win form with 3 tabs. each tab has ultra win grid.
i want to export the 3 grids from the 3 tabs to the same excel file, each grid in new sheet of excel.
how can i do this? i searched in the net and didnt find an answer.
Thanks, Michal
Hi Michal,
There's not much to it, it's pretty easy.
What you do is declare a Workbook in code. You can use the workbook.Worksheets.Add method to add worksheets to it. Then you call the Export method on the UltraGridExcelExporter and pass in the Worksheet you want to export to. When, after all three grids are exported, you call workbook.Save to save it to a file.
I'm still not able to get this working. Could you supply code? My situation is similar to OP with the only difference being in the number of tabs/columns on my app.
I have tried numerous different methods talked about in this forum including this one and many others and multiple scenarios bring back the same error message.
Retrieving the COM class factory for component with CLSID {00020819-0000-0000-C000-000000000046} failed due to the following error: 80040154.
I googled it and attempted the solution listed here with no luck. Any ideas?
currently using infragistics 2006, excel 2007, and visual studio 08.
Thanks
The .Export does not take in a grid, worksheet, and WorkbookFormat. How do you do this if you are exporting to Excel2007?
Edit: never mind, apparently the worksheets formats are exactly the same. It is only the workbook that matters.