Read excel file located at web server

Feb 5, 2016 at 4:21 AM
Edited Feb 5, 2016 at 4:32 AM
Is it possible to read excel file located at web server using closed xml.
I have tried but it popped out "URI formats are not supported".

fName = "http://cip-mis.aviyaan.com/.........../a.xlsx"
Dim workbook = New ClosedXML.Excel.XLWorkbook(fName)

it says URI format not supported.
Feb 5, 2016 at 1:35 PM
As the error said, URI are not supported :)

I believe you can use a WebRequest to the file URL, and use its getResponseStream method to have a valid Stream object to pass to the ClosedXML XLWorkbook object.
I have to tried it but I believe that might be a reasonable way to do that.