I can't find the example on to configure v2008.3 to allow the Excel functionality to be used in .NET 2.0.
I would like to use this functionality but am required to use .Net 2.0.
Is there a post describing the configuration?
Hi,
You can export the grid to Excel or use the Excel assembly to create Excel files in CLR2.0. The only limitation is that you cannot create Excel 2007 files - you have to use the older Excel2003 format.
If you want to use Excel2007, then you need to have a way to package the Excel files. CLR3.5 has assemblies that will do this for you. If you don't have access to those assemblies, then you would need to either write your own or use some other 3rd-party packaging assemblies. There is a sample included with the NetAdvantage SDK that demonstrates how this can be done. The sample, uses the CLR3.5 assemblies, since it obviously does not have access to any 3rd-party utlities. So you would need to replace the references to those CLR3.5 assemblies with whatever 3rd-party tool you are using.
The sample is called "Excel 2007 Custom Packaging" and it's under the WinMisc samples.
Where can I find the samples that you are referring to? The samples in NetAdvantage 2009.1 do not include the "Excel 2007 Custom Packaging" sample that you are referring to.
Regards,
David
Hi David,
I beleive the samples are now in a separate installer - the NetAdvantage SDK. You should be able to download it here: My Infragistics Keys and Downloads - Download Anything and Everything You Own
I've just integrated the sample to generate MS Excel 2007 file with CLR2.0 and Infragistics 2009.1
The xlsx file is generated, but excel exporter seems to limit to number of exported rows to 65k as if it was an old xls file : if FileLimitBehaviour is Throw exception, I get an exception. If it is truck the rows are trunked to 65K.
Any idea ?
Thanks
I found the solution browsing the forum : I was using version 2009.1.1000.... that was bugging.
With version 2009.1.2024, it works well.
I am unable to find the version 2009.1.2024. Please suggest because i am facing the same issue having clr 2.0.
Are you using clr 2.0 or clr 3.5?
How to get the latest service release - Infragistics Community