Unable to Save Excel File Using C#

Question

I'm trying to modify and save data in Excel. With the code below, I'm accessing the sheet, performing modifications, then saving the file. I'm unable to save the file. Here is my code:

Application excel = new Application();
        excel.Visible=true;
        Workbook wb = (Workbook)excel.Workbooks.Open(@"C:\Users\dnyanesh.wagh\Desktop\BookExcel1.xlsx");
        Worksheet ws = (Worksheet)wb.Worksheets[1];
        ws.Cells[1, 1] = "sagar";
        ws.Cells[2, 1] = "sagar";
        ws.Cells[3, 1] = "sagar";
        wb.Save();
        wb.close();

I'm receiving this error: "the file named 'BookExcel1.xlsx' already exists in this location. Do you want to replace it?"

So I changed the code to:

Workbook wb = (Workbook)excel.Workbooks.Open(@"C:\Users\dnyanesh.wagh\Desktop\BookExcel1.xlsx",0, false, 5, "", "",
            false, XlPlatform.xlWindows, "", true, false,
            0, true, false, false););

Then error is: "BookExcel1.xlsx is being modified by user_name.open as read only". If I click the 'cancel' button, I receive the exception above with "Exception from HRESULT: 0x800A03EC"

I have also tried:

wb.SaveAs(@"C:\Users\dnyanesh.wagh\Desktop\BookExcel1.xlsx");
wb.Close(true,null,null);

From that I receive the same error, with the above file showing the modifications.

Can anybody tell me how can I save the file with modifications?

Don't really know, but just a quick thought... are you sure it is ok to use the same file path with SaveAs? Usually this creates a new document. Is there a Save() function instead you could use? — musefan
– musefan, Commented Aug 27, 2013 at 12:38
I don't see you releasing COM objects created.. Remember to always release every single Excel object you create/use. If you get an error and don't close workbook, that could remain opened, so readonly for new instances... More: excel is not closed (using excel.Quit()) so you can have a lot of Excel processes in memory... — Marco
– Marco, Commented Aug 27, 2013 at 12:40
@musefan i try it,firstly but not able to save it.and even i try to make it invisible but still getting error ''BookExcel1.xlsx' is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box.' — dnyaneshwar
– dnyaneshwar, Commented Aug 27, 2013 at 12:41

Alex · Accepted Answer · 2013-08-27 13:49:50Z

Check that you don't already have an Excel.exe process runnning. Also, you should open the workbook so that it's editable.

This code works:

string txtLocation = Path.GetFullPath(InputFile);

object _missingValue = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application excel = new   Microsoft.Office.Interop.Excel.Application();
Excel.Workbook theWorkbook = excel.Workbooks.Open(txtLocation,
                                                        _missingValue,
                                                        false,
                                                        _missingValue,
                                                        _missingValue,
                                                        _missingValue,
                                                        true,
                                                        _missingValue,
                                                        _missingValue,
                                                        true,
                                                        _missingValue,
                                                        _missingValue,
                                                        _missingValue);

//refresh and calculate to modify
theWorkbook.RefreshAll();
excel.Calculate();
theWorkbook.Save();
theWorkbook.Close(true);
excel.Quit();

Simple Sandman · Accepted Answer · 2015-01-08 16:42:04Z

This happens because the file I was trying to open was already open in excel application. In my code, I was not closing the excel application for some conditions. That's why it was opening it with read only permissions. So I was not able to save that file after updating. To open it with read-write, you have to first close that file. After that, you could open it and easily perform read and write operations on the file.

You can close and see all the excel applications which are already open by using following code:

Application excel = (Application)Marshal.GetActiveObject("Excel.Application");
Workbooks wbs = excel.Workbooks;
foreach (Workbook wb in wbs)
{
    Console.WriteLine(wb.Name); // print the name of excel files that are open
    wb.Save();
    wb.Close();
}
excel.Quit();

At the top, add the following code and make reference to Microsoft.Office.Interop.Excel

using Microsoft.Office.Interop.Excel;
using System.Runtime.InteropServices;

Community · Accepted Answer · 2017-05-23 11:45:51Z

0

This problem is for backwards compatible sheet (a .xls) instead of a .xlsx.

To allow sheets to be opened in pre office 2007 version it can't contain more than 65k rows. You can check the number of rows in your sheet by using ctrl+arrowdown till you hit the bottom. If you try to get a range larger than that number of rows it will create an error

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Aug 27, 2013 at 12:44

user1968030

Collectives™ on Stack Overflow

Unable to Save Excel File Using C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related