How to read an excel file having IIS path in ASP.NET

Question

I have a file path in my default.aspx.cs page like this: http://localhost/data/Download/Import/Test.xlsx

I want to read this file using EFPlus library and make some changes. But I am not able to read its content and getting error like "URI Format not supported". If I read file directly from physical path then everything works fine. Below is my code snippet.

Dim newFile As New FileInfo

Xavier J · Accepted Answer · 2016-09-15 11:56:50Z

1

You need to use function Server.MapPath, described here. This function generates a path relative to the root folder of your site. The input starts with a tilde ~, which means the root. I.e.

Server.MapPath("~/images")

will return a string pointing to your /images folder.

answered Sep 15, 2016 at 11:56

Xavier J

4,7911 gold badge16 silver badges29 bronze badges

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

2 Comments

Guarav T. Over a year ago

But my file is not in same location where my website code is, its on another folder outside the website folder which is managed by virtual directory

Xavier J Over a year ago

Then don't use the tilde. Use an absolute path pointing to the virtual directory, I.e. /myvirtualdirectory/myfile.xlsx

Guarav T. · Accepted Answer · 2016-09-16 13:07:34Z

0

I found the solution, its not possible to get physical path of a file and read it using any library if we have URL like http://localhost/data/Download/Import/Test.xlsx. We have to give physical path of server if file is not in same directory where website code exists, only then we can read and access that file.

answered Sep 16, 2016 at 13:07

Guarav T.

4486 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to read an excel file having IIS path in ASP.NET

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related