Hi I want to import and export Excel data using c# (.NET 3.5). We are using Excel 2007 and have successfully managed the same using INTEROP library. But, when I have deployed it on DISCOUNT.ASP, it doesn't work. After enquiry, I have got to know that they can not install INTEROP library and does support OWC, only. Now, the issue is OWC doesn't support Office 2007 and I can not ask my client to go back to Office 2003. I would appreciate if anybody has any solution and shares the same with me. Regards Rajeev
Can you explain further exactly what you are trying to do with Excel 2007? If all you need is to simply pull and modify data and use the Excel spread sheet as the main data source then you should be able to create an application that can connect to it. All you will need is the correct connection string.
Hi Our client needs his payment related information in excel so that he can update it (payout information) offline and then upload the same in the system. To meet this requirement, we need to give an option to our client to export and import data from an excel sheet. Since our client uses Office 2007, I have to integrate Excel2007 with our application. Regards Rajeev