HI Boris,

We have mulitple grids, that are need export to single excel file and started export from 6th row in excel

d't have issue with 2003 excel format using below statement.

ultraGridExcelExporter1.Export(ugExposure, objWorkBook.Worksheets["Exposure"], 6, 0);
ultraGridExcelExporter1.Export(ugExposureCurrncy, objWorkBook.Worksheets["Exposure Currency"], 6, 0);
ultraGridExcelExporter1.Export(ugTAA, objWorkBook.Worksheets["TAA"], 6, 0);
ultraGridExcelExporter1.Export(ugTAACurrency, objWorkBook.Worksheets["TAA Currency"], 6, 0);
ultraGridExcelExporter1.Export(ugSAA, objWorkBook.Worksheets["SAA"], 6, 0);

my question, how I can export these into single excel file in 2007 version, export method for excel format does not have option for workbook & location properties.

ultraGridExcelExporter1.Export(ultraGrid1, "C://temp/test.xlsx", WorkbookFormat.Excel2007);

thanks

Anbu

Hello DCSteve,

I tried this and it always works fine for me so I attached my sample to this post for you. If the issue still persists could you please attach a small sample project reproducing the mentioned issue. You could also try and upgrade for the latest service release available for your current version and test your application against it. Please review my sample and feel free to let me know if I misunderstood you or if you have any other questions.

Mike,

This feature, which requires the parameters below, produces corrupted excel file. The parameters I am passing are myUltrgaGrid, @"C:\test.xlsx", and what you see below. When the file saves, I try and open it but excel gives "This file is corrupted" error message. Thanks.

Infragistics.Excel.WorkbookFormat.Excel2007MacroEnabled
 
or

Infragistics.Excel.WorkbookFormat.Excel2007

This feature was added quite a while ago. NetAdvatange 2008 volume 3, I think.

The latest version (NetAdvantage 2009 Vol. 2) has the ability to export to Excel 2007.

Any update on this?