Loading

EDPLUS for Excel to datatable

ras ras

9y1.1k.NET

 var pck = new OfficeOpenXml.ExcelPackage(); 
pck.Load(File.OpenRead("~\\EXCELS\\Book2.xlsx"));

How to map excel after hosting ... 
I tried this code it is not working for me.
I tried system path it works but after hosting doesn't work
it shows

Could not find a part of the path 'C:\Windows\SysWOW64\inetsrv\~\EXCELS\Book2.xlsx'.

Can anyone help me please..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajeev Punhani9y ago
Hi Ras,

Please try path like
pck.Load(File.OpenRead(Server.MapPath(@"~/EXCELS/Book2.xlsx")));