Could not read the excel file in server

Question

Below is my code to read a excel file. This works fine in the local machine. But I move this to the server it return error.

            Excel.Application xlApp = new Excel.Application();
            Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@""+Path);
            Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
            Excel.Range xlRange = xlWorksheet.UsedRange;

Possible duplicate of [Create Excel (.XLS and .XLSX) file from C#](https://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c-sharp) — davcs86, May 31 '17 at 04:34
Can you include the error which is being returned, and which line of code it occurs on ? — James, May 31 '17 at 04:51
You need to install Excel on the server but it would be better to use a decent library instead of interop — Joe Phillips, May 31 '17 at 05:10
@JoePhillips Can I use plugin for this without installing the Excel to the server. Please help — shan, Jun 02 '17 at 08:20
@Joe please don't advise stuff that is clearly unsupported and a head f#$& of a solution — Jeremy Thompson, Jun 02 '17 at 09:05

score 2 · Answer 1 · answered May 31 '17 at 04:51

The reason is because server-side Automation of Office is not supported.

There can be so many things that can go wrong with this. Its why Microsoft has employed the XML format starting with Office 2003.

If you want to process Excel files on the server use an XML library like ClosedXML or OLEDB as the Knowledge Base article suggests.

Could not read the excel file in server

1 Answers1