Visual Studio 2012: How do I open an excel file that is associated with my project?

Question

So I'm working on a project that uses an excel file to add "descriptions to user controls. As of right now, my code opens the excel file using an absolute path, like so

Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"C:\absolute path\filename.xlsx", Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing, Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing, Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing);

which works just fine.

I then tried renaming the file (just to make sure that the C:\ file wasn't being opened for some odd reason) and added it to my project so that I wouldn't have to depend on being able to access a particular drive (i.e the file could be opened because it's associated with the project). Then I tried the following code:

Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"newfileName.xlsx", Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing, Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing, Type.Missing, Type.Missing
                                                                 , Type.Missing, Type.Missing);

which gave me this:

"Additional information: 'newfileName.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct."

I was wondering what is the correct way to add an excel file to a project and open it using a relative path name?

If you want to associate file with your Project then you need Resources. Here you can see how to add resource to your project [How to create and use resources in .NET](http://stackoverflow.com/questions/90697/how-to-create-and-use-resources-in-net) — M.kazem Akhgary, Jul 07 '15 at 16:04
Okay, I think you got me going down the right path. How do I open it now? It's there, but the `Open` method needs a string argument, and I can't figure out how to get the path name. I tried `Properties.Resources.newfileName.ToString()` and that gave me a "[]System.byte" instead of newfileName.xlsx — C-Scholl20, Jul 07 '15 at 16:20
resources are memory streams. you have to use the stream directly or save stream in disk with temp path and load it again. take a look at my answer. — M.kazem Akhgary, Jul 07 '15 at 17:15

score 0 · Answer 1 · answered Jul 07 '15 at 16:06

0

The second example is trying to open this file at the work directory. So if you want to copy this file on build, just change "Copy to Output Directory" property to "true" for this file

answered Jul 07 '15 at 16:06

nick

673
4
11

score 0 · Accepted Answer · edited May 23 '17 at 12:29

If you want to associate file with your Project then you need Resources. Here you can see how to add resource to your project:

How to create and use resources in .NET

Resources are Stream. They are stored in memory. So i will recommend you to use a class Which takes Stream. Not path of the File.

Because Workbooks.Open creates Stream from path of the file. Its better to look for an overload or alternative class that takes stream directly.

var doc = SpreadSheetDocument.Open(Properties.Resources.YourFile , isEditable);

isEditable is bool. You may use true or false. If you set it to false It will be readonly.

I recommend you to take a look at this topic to:

How to: Open a spreadsheet document from a stream (Open XML SDK)

Any way If you want to use your current class. You have to temporary save Stream into Disk and get the path from it. It works but there is lot of extra work to do since you can use the Stream in straight way.

 string path = Path.GetTempPath(); // Creates a  Temp path for temporary file.
 Properties.Resources.Yourfile.Save(path); // Save the file into path.
 // Now you can use path to load file with xlApp.Workbooks.Open again!
 Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(path,...);

Visual Studio 2012: How do I open an excel file that is associated with my project?

2 Answers2