Exception thrown when saving excel file

Question

I wrote up a method that takes all the cells from a DataGridView and copies them to an Excel workbook.

It all works fine and dandy, up until I get to the part where I actually save it.

Here is the code that saves it:

        //Saves the Workbook to the specified path
        excelWorkbook.ActiveWorkbook.SaveCopyAs(pathToSave);
        excelWorkbook.ActiveWorkbook.Saved = true;

        //Close the workbook
        excelWorkbook.Quit();

And the exception being thrown:

Microsoft Office Excel cannot access the file 'C:\Users\TheGateKeeper\Desktop\New folder'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

This is the first time I am working with this class, so I may have messed something up.

Also as a sidenote, what does:

 excelWorkbook.ActiveWorkbook.Saved = true;

do?

Thanks.

'C:\Users\TheGateKeeper\Desktop\New folder' is directory. How you set excel filename? — Serj-Tm
– Serj-Tm, Commented Mar 6, 2012 at 18:24
1. What are value of variable pathToSave? 2. Are directory ''C:\Users\TheGateKeeper\Desktop\New folder' exists? — Serj-Tm
– Serj-Tm, Commented Mar 6, 2012 at 18:45

Luke Forder · Accepted Answer · 2012-03-06 19:13:47Z

1

Set the argument of the SaveCopyAs method to path of the excel file including extension.

eg. C:\Users\TheGateKeeper\Desktop\TestFile.xls.

The extension specifies the format of the workbook, eg .xls (2003 and <), .,xlsx (2007 +)

For your side note, setting Saved to true flags the content as saved it doesn't actually write it to disk.

To open a workbook file, use the Open method.

To mark a workbook as saved without writing it to a disk, set its Saved property to True.

The first time you save a workbook, use the SaveAs method to specify a name for the file.

Source MSDN

edited Mar 6, 2012 at 19:13

answered Mar 6, 2012 at 19:05

Luke Forder

1,18914 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Exception thrown when saving excel file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related