I am working on a program that has multiple win grids on it. I need to export each grid into one excel document as a separate sheet. Is there a way to do this with the UltraGridExcelExporter? I am using version 5.3 of infragistics....
For example, how do I write the 'Workbook' to a file?
MyWorkbook.ActiveWorksheet = MyWorkbook.Worksheets("Customers")
Me.UltraGridExcelExporterMain.Export(gridCustomers, MyWorkbook)
MyWorkbook.Worksheets.Add("Jobs")
Me.UltraGridExcelExporterMain.Export(gridJobs, MyWorkbook)
So now I have an instance of an infragistics excel workbook, but how do I write it to a file?
Thanks...
Infragistics.Excel.BIFF8Writer.WriteWorkbookToFile(MyWorkBook, filename)
I have just upgraded to 2008.1
I am now getting the following warning in VB2005:
Warning 3 'Infragistics.Excel.BIFF8Writer' is obsolete: 'Deprecated. The BIFF8Writer class has been replaced by the Save instance methods of Workbook.' C:\VS\ODG\ABS\Forms\ASFBASE1.vb 2246 17 ABS
Apparently BIFF8Writer has been deprecated. Can you tell me how to use this new instance method?
Your question is really not related to the workbook or the Infragistics components. I think what you probably want to do is use the OpenFileDialog component which is part of the DotNet Framework.
Hi,
The save method of the workbook takes the location where the excel file is to be created.
oWorkbook.save("C:\Documents and settings\abc\desktop")
Instead of hardcoding the location I want the user to select the location of where the excel is to be created. I would appreciate if some replies to my post.
Thanks,
Junaid.
It's an instance method.
myWorkbook.Save(xxx)
I would if I could, and I don't see how I can, and that is why I am asking.
When I use intellisense to see the methods that hang off the workbook class, I do not see the save method:
Infragistics.Excel.Workbook.
This is the code that the warning is referring to:
Infragistics.Excel.BIFF8Writer.WriteWorkbookToFile(myWorkbook, ASCMAIN1.Folders("Work") & xlsFileName & ".xls")
So where is the Save method?
Oh, I guess I am behind the times.
Um... I'm not sure what your question is. Apparently, you just sall the Save method on the Workbook object.