how to read excel comments from excel worksheet asp.net c#

Last Reply 12 days ago By dharmendr

Posted 12 days ago

SalamAlaekum

I am able to use Microsoft.Office.Interop.Excel.Workbooks.Open in localhost environment to open an excel worksheet and read comments from it and store to access database. But the code does not work on the IIS server and a blog online cleartly states that crosoft does not currently recommend, and does not support, Automation of Microsoft Office applications including Asp.net etc. Please help me figure out how to get this done

Thank you

Nada,

Software Engineer/Data Manager

High Voltage Battery, Ford Motor Company, Dearborn, MI USA

You are viewing reply posted by: dharmendr 12 days ago.
Posted 12 days ago
nshutta5 says:
Are the dlls being used available in the visual studio project library?

No this is not available in visual studio project library. You need to download the dll and add the dll reference in your project.

Refer below link.

https://www.codeproject.com/answers/365870/excel-merging-working-in-local-system-but-not-work#answer1

https://stackoverflow.com/questions/2331837/microsoft-office-interop-excel-12-0-not-working-in-iis-7