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# — davcs86
– davcs86, Commented May 31, 2017 at 4:34
Can you include the error which is being returned, and which line of code it occurs on ? — James
– James, Commented May 31, 2017 at 4:51
You need to install Excel on the server but it would be better to use a decent library instead of interop — Joe Phillips
– Joe Phillips, Commented May 31, 2017 at 5:10

Jeremy Thompson · Accepted Answer · 2017-05-31 04:51:17Z

2

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.

answered May 31, 2017 at 4:51

Jeremy Thompson

66.3k38 gold badges225 silver badges344 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not read the excel file in server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related