Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Michael
100
How do I write an infragistics excel workbook to a file.
posted

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.Worksheets.Add("Customers")

MyWorkbook.ActiveWorksheet = MyWorkbook.Worksheets("Customers")

Me.UltraGridExcelExporterMain.Export(gridCustomers, MyWorkbook)

MyWorkbook.Worksheets.Add("Jobs")

MyWorkbook.ActiveWorksheet = MyWorkbook.Worksheets("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...