Last post Dec 28, 2009 09:27 AM by rilov
Dec 27, 2009 10:06 AM|chekuriraju|LINK
i have got a file upload control where in the user selects xlsx file.I am saving it in a folder using server.mappath. I am able to read from that file and insert into database by establishing connection via OLE DB Provider.This works well in local system
where i have got excel installed but when i tried to do the same thing by placing code in server(where excel is not installed) and tried to upload file from client it is not working.
i have searched and found out that we need to use dll to do this Interoperability.so i have added the Microsoft excel dll available in (add reference of project).after using the classes in that dll also i am not able to achieve my requirement.
I am sure the reason for this is that i don't have excel installed in my server. Is there any workaround for this??
Dec 27, 2009 11:38 AM|rilov|LINK
You need to install the office system driver..
Dec 28, 2009 01:19 AM|chekuriraju|LINK
Our client is not allowing to install anything on server.
I want to know if we can use any free 3rd party dll's to achieve this. This is very urjent.
Dec 28, 2009 09:27 AM|rilov|LINK
http://excelpackage.codeplex.com/ try this..