Cant open excel file using C#

Question

        xlApp = new Excel.Application();
        xlWorkBook = xlApp.Workbooks.Open("‪‪C:\\Data_check\\Load Data Check_new_3.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, false, 0, false, 1, 0);

I am trying to open an excel workbook through the above code, however it throws an error that the file could not be found or is it moved, or removed. I can open the file if i type the path in windows explorer .

The screenshot of the error is shown: I'm not sure what the problem is here.. I was able to open a similar file placed on my desktop but not this one.

Try to open an other file in an other folder, so you can see if the problem is in your code or has to do with something in your environment (operation system, user rights, ...). — Dieter Meemken
– Dieter Meemken, Commented May 26, 2016 at 6:52
Does System.IO.File.Exists("‪‪C:\\Data_check\\Load Data Check_new_3.xlsx") return true? So we can isolate this as an Excel issue rather than permissions etc? — GodLovesATrier
– GodLovesATrier, Commented May 26, 2016 at 8:43
No , It seems to be returning false.However the file does exist on the path. Any more suggestions? @GodLovesATrier — abhinavm93
– abhinavm93, Commented May 26, 2016 at 9:11
So it's not excel-specific then. Try using (var fs = System.IO.File.Open("...", FileMode.Open, FileAccess.ReadWrite)); see what exception that raises — GodLovesATrier
– GodLovesATrier, Commented May 26, 2016 at 9:38

Mrinal Kamboj · Accepted Answer · 2016-05-26 06:54:40Z

1

Your path has empty space, which will cause a problem in opening the file at runtime - Load Data Check_new_3.xlsx

answered May 26, 2016 at 6:54

Mrinal Kamboj

11.6k5 gold badges45 silver badges82 bronze badges

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

3 Comments

abhinavm93 Over a year ago

No, that is incorrect. I was able to open a file with white spaces in its name with the same code. However when i changed the path to this file i can't open the same.

Mrinal Kamboj Over a year ago

Here the issue is simply file not found, so the program is not able to parse your file path correctly, try removing those spaces and ensure that file name match in the actual folder

abhinavm93 Over a year ago

As i mentioned above, that is incorrect. I opened a file with white spaces in it's name with the same code, however to recheck i changed my file name without spaces and tried the same, and still it doesn't work. This is not the answer.

S M · Accepted Answer · 2016-05-26 07:14:14Z

1

Try @Mrinal Kamboj answer

Or try shorten the file name by a few characters The full PATH name - drive, folders, filename, cannot exceed 218 chars

edited May 26, 2016 at 7:14

answered May 26, 2016 at 6:57

S M

3,2536 gold badges35 silver badges61 bronze badges

6 Comments

abhinavm93 Over a year ago

Application.StartupPath exists in which namespace?

S M Over a year ago

msdn.microsoft.com/en-us/library/…

abhinavm93 Over a year ago

This is not relevant.

S M Over a year ago

then may be that path/folder is inaccessible. check your path/folder permissions

S M Over a year ago

or try to run your application with administrator previllages

|

Collectives™ on Stack Overflow

Cant open excel file using C#

2 Answers 2

3 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related