Excel interop libraries, Without MS office

Hi Experts,

My Developpers use excel interop dll to import data to SQL Server from excel file on client PC via web application. they ask me to install excel on my web server.
I don't need to perches additional office licence for web server and open another vulnerabilities on my web server.
I search a run time, couldn't find.
Redistributable  Interop Assemblies didn't work.

Is there any way to export excel using excel interop dll without installing excel to web server?
or is there alternative method to import data from excel to SQL Server through web app.
LVL 9
Pushpakumara MahagamageVPAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
you can use a 3rd party library like https://products.aspose.com/cells/net
1
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
To be clear: The Interops simply work with the installed version of Excel. If your developers are using the Excel Interops, then the target environment MUST have Excel installed.

If all you're doing is importing you can use the open source ExcelDataReader. I use it regularly in my .NET projects, and it definitely works without Excel installed on the machine.

https://github.com/ExcelDataReader/ExcelDataReader

You can install this most easily through the NuGet function in Visual Studio (which also makes sure you use the correct version). Deployment is as simply as include a couple of DLL files in your package.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Snarf0001Commented:
I use EPPlus anytime I need to play with Excel.  Incredibly detailed and functional piece of software, haven't found many things you CAN'T do with it yet.

https://www.nuget.org/packages/EPPlus/
https://github.com/JanKallman/EPPlus
0
Pushpakumara MahagamageVPAuthor Commented:
Thank you. I'll try your options.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.