How to write File Path in cs file using C# ?

Question

0.00/5 (No votes)

See more:

Hi
I am using excel file in my project. I included the file path but it showing error "'~/Data/File.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted."

C#

o.Open("~/Data/File.xls");

someone give solution for this problem..

Regards
Karthik.R

Posted 22-Dec-14 21:19pm

Karthik Ravi

Updated 6-Jan-15 1:55am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Accepted Answer · 2014-12-22T22:00:00

Solution 1

We don't know your setup. First, set the path explicitly (use absolute path) to see you have access rights. Then use relative, but use

Try using Path.GetFullPath ("~/Data/File.xls") to see where it maps

C#

Server.MapPath("~/Data/File.xls")
- this could (maybe) resolve your problem - THIS ASSUMES WEB APP although you didn't specify it :)

If this helps please take time to accept the solution. Thank you.

Posted 22-Dec-14 22:00pm

Sinisa Hajnal

Updated 11-Jan-15 20:27pm

v3

Comments

Karthik Ravi 23-Dec-14 4:07am

Absolute path is working fine, I am doing this project coded ui not web application..

Sinisa Hajnal 23-Dec-14 4:17am

Then the problem remains - your relative path doesn't map properly to your absolute path. See how you can resolve ~path.

Karthik Ravi 23-Dec-14 4:23am

I think path format is right, the property which i need to set is wrong...

Sinisa Hajnal 23-Dec-14 4:35am

What is your directory structure? Why do you think the path is right? What kind of application are you making (winforms, wpf, something else...)?

Karthik Ravi 23-Dec-14 4:59am

Directory Structure : Data/File.xls
path i think coreect : ~/Data/File.xls
application : coded ui

Sinisa Hajnal 23-Dec-14 5:14am

Data/File.xls I don't doubt. What I'm asking is what is your application base path. That is, are you sure that ~/Data is where you think it is (it should be relative to application base path). If your app is in c:\my app then your xls is C:\my app\Data\File.xls.

You still didn't define your directory structure...also, you didn't say WHY you think the path is right. I realize the path exists, but having relative path means you don't know where it resolves. Try adding you File.xls into your app directory and remove "Data" part. If the app cannot find the file it means it doesn't map as you think. Focus on that - very little chance that anything about properties cause it.

There is nothing I can do if you're not providing the data. I don't see your computer, know your project etc...you have to provide detailed info and not assume things. Thank you.

Sinisa Hajnal 23-Dec-14 5:19am

Try using Path.GetFullPath ("~/Data/File.xls") to see where it maps

Karthik Ravi 6-Jan-15 7:54am

Thanks a lot your solution works perfectly