Using Interop Excel to export gridview to excel?

The statement you quoted only means that the assembly you would reference depends on which version of excel you have installed on the box running your program So if you have Excel 2007 in your box, then you should reference the Excel12 library. However, it does not follow that the clients should have the same version. In Excel 2007, you may save the files in xml format (xlsx) and it would be readable to clients with excel 2007+ and older versions with a certain Compatibility Pack Using the same library, you can also save your files in the older xls format for compatibility, which I think can be opened up til Excel 97 (some features may be disabled).

The statement you quoted only means that the assembly you would reference depends on which version of excel you have installed on the box running your program. So if you have Excel 2007 in your box, then you should reference the Excel12 library. However, it does not follow that the clients should have the same version.In Excel 2007, you may save the files in xml format (xlsx) and it would be readable to clients with excel 2007+ and older versions with a certain Compatibility Pack.

Using the same library, you can also save your files in the older xls format for compatibility, which I think can be opened up til Excel 97 (some features may be disabled).

– James Klay May 26 at 5:19 actually no, it doesn't work that way. You have to have excel installed on your server. Use the excel interop to create an excel file and then you send the file over the wire to your clients.

– Mel May 26 at 5:56 I suggest you generate and save your excel file somewhere in your server (or db) instead of regenerating the excel file for every user.. or alternatively, if you use it for repoting, use something like SSIS or reporting services... and let them generate the excel file for you. – Mel May 26 at 5:59.

Planning on using interop on my project because the previous methods give me a popup warning every time the file is opened in excel saying that the version is different from the file format. Question is, which Object Library version do I have to add to my project's References? Depending on the version of Office installed the Excel Assembly may be called Excel 10 Object Library or Excel 11 Object Library.

Does this mean that interop can only be used with one version of Excel? If I use this certain version of Object Library, then I can only use it in par with Excel 2003. Is that what this mean?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions