Hi!
I have problems with exporting a grid to the (Excel 2007) xlsx format. Old Excel xls formats works fine and I can open them in Excel 2007. Is it possible to export the grid to a real Excel 2007 xlsx format with the UltraGridExcelExporter?
Exporting to the Excel 2007 file format is not supported. You can submit a feature request for this: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Thank you for the quick response. I have submitted a feature request.
Marcuso,
Infragistics does not release feature release information until it has passed through our QA organization and is guarenteed for release as this is our policy. That being said it is very high on our list of workitems and I'd expect to see it in the near future...
Kind Regards,
Andrew M. FlickProduct ManagerInfragistics, Inc.
Any update on this?
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.
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 orInfragistics.Excel.WorkbookFormat.Excel2007
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.
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