Ad:

C# Discussion Thread
Unsolved
Views: 1805

Dec 6th, 2008

error opening excel sheet in c#

Expand Post »

i'm trying to open an existing excel worksheet. my code is:

c# Syntax (Toggle Plain Text)
Microsoft.Office.Interop.Excel.Application excelApp;
Microsoft.Office.Interop.Excel.Workbook excelWorkbook;
Microsoft.Office.Interop.Excel.Worksheet ExlWrkSheet;
private object Opt = Type.Missing
 
excelApp = new ApplicationClass();
 
excelWorkbook = excelApp.Workbooks.Open("..//..//Data.xls", Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt);
Microsoft.Office.Interop.Excel.Application excelApp;
Microsoft.Office.Interop.Excel.Workbook excelWorkbook;
Microsoft.Office.Interop.Excel.Worksheet ExlWrkSheet;
private object Opt = Type.Missing

excelApp = new ApplicationClass();

excelWorkbook = excelApp.Workbooks.Open("..//..//Data.xls", Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt);

on the last line i get an exception that he cannot find the file.
i placed the file in the project directory.
i tried also "Data.exl" path when the file is placed in the debug directory, it didn't helped.

what am i doing wrong ?

Similar Threads

Excel 2003 Error opening file in Windows NT / 2000 / XP
Using Microsoft Excel 10.0 Libary Object -Dang .dlls in C#

emilio

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

162 posts
since Nov 2007

Permalink

Dec 6th, 2008

Re: error opening excel sheet in c#

Why not use a pathname like @"C:\....\Test.xls" ?

ddanbe

Reputation Points: 2023

Solved Threads: 644

Senior Poster

Online

3,736 posts
since Oct 2008

Permalink

Dec 6th, 2008

Re: error opening excel sheet in c#

Are you sure about the path wheather it is right or not

Jugortha

Reputation Points: 11

Solved Threads: 16

Junior Poster

Offline

172 posts
since Oct 2007

Permalink

Dec 7th, 2008

Re: error opening excel sheet in c#

i tried it with an absolute path like "c:\Data.xls" and it works fine.
the problem is with relative path.

emilio

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

162 posts
since Nov 2007

Permalink

Dec 7th, 2008

Re: error opening excel sheet in c#

Read this http://weblogs.asp.net/pwelter34/arc...e-snippet.aspx
it might help.
It is also possible that Open only accepts absolute paths.

ddanbe

Reputation Points: 2023

Solved Threads: 644

Senior Poster

Online

3,736 posts
since Oct 2008

Permalink

Dec 7th, 2008

Re: error opening excel sheet in c#

Open does except relative paths, however, you have to be sure of where you are vs where your file is which is often unlikely.

So, if you have your app, and you are sure you are in your exe's directory, then opening "Data/file" will work - but, for example, excel may not be in the apps directory but its own, you can tell by using the filemonitor from microsoft (seeing as they bought the company out) which will show you where it was trying to find the file.

LizR

Reputation Points: 196

Solved Threads: 190

Posting Virtuoso

Offline

1,735 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: How to insert data in GridView and then into database

Next Thread in C# Forum Timeline: Displaying a local webpage

DaniWeb Message

Cancel Changes

User Name
Password