C++/CLI How to open Excel file using relative path?

Question

I am quite new to C++/CLI, and I am having trouble with opening an Excel file. This is my following code sample.

#using <system.dll>

using namespace System;
using namespace Microsoft::Office::Interop::Excel;

String ^filename = gcnew String(L"Test.xlsx");
try
{
    Application^ exapp = gcnew ApplicationClass();
    Workbook^ wb = exapp->Workbooks->Open(filename,  Type::Missing, Type::Missing,
        Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing,
        Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing,
        Type::Missing, Type::Missing);
    Worksheet^  exws = safe_cast<Worksheet^>(exapp->ActiveSheet);
    exws->Cells[1, 1] = "Hello world";
    return true;
    Console::WriteLine("File Read Successfully");
}
catch (Exception ^e)
{
    Console::WriteLine("Failed to read File");
    Console::WriteLine(e);
    return false;
};

Whenever I run it, it will always throw FileNotFoundException, even though the Excel file is right next to Test.exe, unless I change filename back to fullpath like C:\Users\NGU0085\Documents\Visual Studio 2013\Projects\Test\Debug\Test.xlsx

Is there any way to open an Excel file using relative path?

Excel is a separate process, it has its own default directory. — Hans Passant
– Hans Passant, Commented Aug 10, 2015 at 10:46
Are you running into this problem all the time, or only when you are debugging from the studio? If so, just change your program working directory under Project Properties->Configuration Properties -> Debugging to the correct path. — S. Larws
– S. Larws, Commented Aug 12, 2015 at 20:16

Community · Accepted Answer · 2017-05-23 11:58:01Z

1

Maybe the current directory is not set to what you expect. Current directory can change without you explicitly changing it in your code, so you shouldn't really rely on it being what you expect.

The solution is to turn your relative path to absolute path. Get app's directory using this answer, and add "Test.xlsx" to that path.

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Aug 10, 2015 at 10:26

Dialecticus

16.8k7 gold badges47 silver badges108 bronze badges

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

Comments

Prasaathviki · Accepted Answer · 2015-08-11 05:12:42Z

0

you can use this function System.Reflection.Assembly.GetExecutingAssembly().Location

answered Aug 11, 2015 at 5:12

Prasaathviki

1,1672 gold badges11 silver badges27 bronze badges

1 Comment

Dialecticus Over a year ago

Instead of Location property it's better to use CodeBase. Read this answer and the comments on it.

Collectives™ on Stack Overflow

C++/CLI How to open Excel file using relative path?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related