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?
 
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
 
Éric MoreauSenior .Net ConsultantCommented:
you can use a 3rd party library like https://products.aspose.com/cells/net
1
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.