Read from excel without installing excel RRS feed

  • Question

  • User-1101168317 posted

     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??  

    Sunday, December 27, 2009 10:06 AM


All replies