Application is configured to use 3.5 framework.Using Visual Studio 2008
I am using Infragistics3.Excel.v9.1.dll Infragistics3.Win.UltraWinGrid.ExcelExport.v9.1.dll
with Office 2007 installed
and Saving the file as Test.xlsx ( oExcel.Export(uGrid, "Test.xlsx", Infragistics.Excel.WorkbookFormat.Excel2007))
I still get too many rows error if FileLimitBehaviour is set to ThrowException Or truncates to 65536 rows if I choose truncatedata option on the ExcelExport.
What am I missing?
I saw on the other post that it was an issue in 2008 volume 3 but was hoping you guys fixed it in Volume 2009.1 (http://blogs.infragistics.com/forums/p/20735/74736.aspx)
Hi,
Make syre you have the latest service release for v9.1. This issue may have been fixed in both versions, but after the Volume release.
If that does not help, you should create a small sample project demonstrating the issue and either post it here or Submit an incident to Infragistics Developer Support so we can check it out.
Sent sample application explaining the situation.
This is what I have used.
Infragistics3.Excel.v9.1 version 9.1.20091.1000
Infragistics3.Win.UltraWinGrid.ExcelExport.v9.1 version 9.1.20091.1000
Got the latest service release 9.1.20091.2029
seems to work fine.
Its Working perfectly in 9.2, well what if i dont know the excel version on the machine?
How can i identify the Excel version in the machine, or is there any wayi can avoid prescribing the WorkbookFormat so that excelexporter can decide the format itself?
I'm not sure if there is any way to detect if Excel is installed on a machine and if so, what versions of Excel are installed. That would be a question for Microsoft. Or perhaps you could post on a more general DotNet programming forum.
My guess is that there are probably registry keys you could check for, but I haven't got any idea what they might be.
Of course, another option would be to give your users a choice of what format they want to use.
vb.net
Imports Microsoft.Office.Interop
Dim objExcel As New Excel.Application
Dim vers1 As String = objExcel.Version
If vers1 = "12.0" Then
'max_export = 1048576
Dim max_export = 1040000
End If