Import to Excel file without installing Microsoft Office or Interop Library in ASP.Net

thewall813
 
on Sep 20, 2021 04:07 AM
372 Views

I am developing one application in which i am performing various action on excel file like importing excel file or exporting data grid view data to excel file or edit an existing excel file.

I am creating setup and installing on another computer.

So if there is no Microsoft office or Microsoft excel is installed on another computer then

It will allow to access this excel functionally.

So is there any way that can allow me to access excel functionally even if Microsoft excel

Is not installed on that computer

Download FREE API for Word, Excel and PDF in ASP.Net: Download
thewall813
 
on Sep 20, 2021 10:00 PM

is there is any other Libraries ?

Because i found that ClosedXML doesnt support macros and my excel file has macros.

dharmendr
 
on Sep 21, 2021 06:41 AM

Hi thewall813,

You cannot run a macro/VBA directly without installing Excel.

But there are some .Net libraries that can read Excel files. But you will need to convert/translate your macro/VBA code into a .Net code that uses the library.

https://stackoverflow.com/questions/21784886/writing-and-executing-vba-macros-on-excel-without-using-excel-interop/33394932#33394932

https://github.com/dotnetcore/NPOI