Load excel file and write

Question

I have an excel file in "D:\SOURCE\PROJECTNAME\PROJECTNAME\File\MyExcelFile.xlsx"

So, i can get this path by

"D:\\SOURCE\\PROJECTNAME\\PROJECTNAME\\File\\MyExcelFile.xlsx"

but i want to use something like "~\\File\\MyExcelFile.xlsx"

I'm newbie with C#, can anyone help?

which application template r u using `WinForm`, `Asp.Net`, `Asp.Net MVC` or any else? — er-sho, Oct 03 '18 at 09:11

score 1 · Answer 1 · answered Oct 03 '18 at 08:56

1

You can use Path.Combine(Environment.CurrentDirectory, "File/MyExcelFile.xlsx") if your files are being copied to Bin folder.

answered Oct 03 '18 at 08:56

Samvel Petrosov

score 0 · Accepted Answer · edited Oct 03 '18 at 09:20

0

Server.MapPath("File/Excel.xlsx")

edited Oct 03 '18 at 09:20

er-sho

answered Oct 03 '18 at 09:04

It's `D:\SOURCE\PROJECTNAME\PROJECTNAME\WebService\File\MyFile.xlsx` – Võ Xuân Thức Oct 03 '18 at 09:07
if this code works then mark it as an answer or check for alternate suggestions – Karthick Trichy Chandrasekaran Oct 03 '18 at 09:09
i need `D:\SOURCE\PROJECTNAME\PROJECTNAME\File\MyFile.xlsx` but your answer return `D:\SOURCE\PROJECTNAME\PROJECTNAME\WebService\File\MyFile.xlsx` But i can use this and substring, thank you so much – Võ Xuân Thức Oct 03 '18 at 09:11
dont use substring and it's not standard, check this instead https://stackoverflow.com/questions/9725584/server-mappath-to-go-two-folder-back-from-root – Karthick Trichy Chandrasekaran Oct 03 '18 at 09:19

2 Answers2