Access an excel file from within ASP.NET Folders code-behind

Question

I am having issues with my IT team and they are unaware of how to handle my request. I have asked them to add Network Service to a folder that my asp.net site needs to have access to in order to open an excel template and populate it with data. I have been trying to get this done for multiple weeks now and I am very frustrated.

So here is my question. I have looked online and cannot find a way to do this. If I were to put the template file in my website, as a folder like an image, is there a way to dynamically reference that template in code behind? That way the application has access to the file. The user is saving the report to their own folders, so I don't ever need them to have access to the file directly.

Please advise. Any suggestions will help.

Just chmod(777) the folder - full read, write, execute permissions. Seems to me the problem would be more based off of actually interacting with the .xls(x) file than it would having access to the physical folder location. That interaction is a whole other ball game. — Travis J
– Travis J, Commented Mar 30, 2012 at 17:06
If you know where the file is in your web structure, then Server.MapPath("~/path_to_file.xslx") will give you the local path on the server, if that's what you are after? The ~/path_to_file.xsl(x) bit will be a folder under your webroot. — dash
– dash, Commented Mar 30, 2012 at 17:08
THANK YOU DASH! Server.MapPath worked great. Accessed it both in local and server versions. — DrPib81
– DrPib81, Commented Mar 30, 2012 at 17:18

dash · Accepted Answer · 2012-03-30 17:31:41Z

1

If you place the file in a local folder under your webroot, then using Server.MapPath will enable you to obtain a local path for the file.

For example,

Server.MapPath("~/templates/mytemplate.xslx")

Would translate to something like C:\inetpub\wwwroot\mysite\templates\mytemplate.xslx

Then you can do whatever you want with your template!

answered Mar 30, 2012 at 17:31

dash

91.7k4 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Access an excel file from within ASP.NET Folders code-behind

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related