C# and Excel Interop issue, Saving the excel file not smooth

Question

I could Open and Write to the excel file, but when I try to save the file by passing a path to it, the save operation prompts with the Save dialog. I was expecting it to quitely Save the file at the specified path

The code is as below:

excelApp.Save(exportToDirectory);
excelApp.Quit();

where, exportToDirectory is: "C:\files\strings.xlsx".

PS: I have already checked with the excel version and similar issue.

Thanks

Mitch Wheat · Accepted Answer · 2012-03-28T11:31:24.957

15

You need to use Workbook.SaveAs instead of Application.Save:

Excel.Application app = new Excel.Application();
Excel.Workbook wb = app.Workbooks.Add(missing);
...
wb.SaveAs(@"C:\temp\test.xlsx", missing, missing, missing, missing,
          missing, Excel.XlSaveAsAccessMode.xlExclusive,
          missing, missing, missing, missing, missing);

edited Mar 28 '12 at 11:31

answered Apr 24 '09 at 12:49

Mitch Wheat

295,962
43
465
541

Any idea what the numerical value for Excel.XlSaveAsAccessMode.xlExclusive is? I need to pass this to this function in a windows script file. – MrVimes Jun 28 '13 at 13:33
1

@MrVimes Totally late to the party for you, however here they are for future reference: `public enum XlSaveAsAccessMode { xlNoChange = 1, xlShared = 2, xlExclusive = 3 }` – killercowuk Mar 09 '16 at 19:28

score 15 · Answer 2 · answered Apr 24 '09 at 12:52

15

Setting the following properties might also help:

excelApp.DisplayAlerts = false;
excelApp.ScreenUpdating = false;
excelApp.Visible = false;
excelApp.UserControl = false;
excelApp.Interactive = false;

answered Apr 24 '09 at 12:52

Bravax

10,453
7
40
68

I try a lot of solution but this was the only one that works like it should! Very useful! Tks!! – Fryla- Cristian Marucci Feb 29 '16 at 19:48

score 3 · Answer 3 · answered Mar 06 '11 at 06:30

3

just set the ActiveWorkbook.Saved property to true and you can Quit() without any Dialog box;

answered Mar 06 '11 at 06:30

Gasy

31
1

score 2 · Answer 4 · answered Apr 24 '09 at 12:52

Well, here's how Microsoft does it:

// Save the Workbook and quit Excel.
m_objBook.SaveAs(m_strSampleFolder + "Book1.xls", m_objOpt, m_objOpt, 
    m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange, 
    m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();

See one of their KB articles.

score 1 · Answer 5 · answered Aug 23 '13 at 07:32

1

myBook.Saved = true;
myBook.SaveCopyAs(xlsFileName);
myBook.Close(null, null, null);
myExcel.Workbooks.Close();
myExcel.Quit();

answered Aug 23 '13 at 07:32

Ajay Padharia

11
1

This worked best for me and not the highest rated answers. What I liked about this solution is that it didn't affect other Excel files opened by user. – ytoledano Nov 05 '16 at 20:30

score 1 · Answer 6 · edited May 23 '12 at 19:35

1

I found excelApp.ActiveWorkbook.save() which can save the file, then I can quit without for asking.

edited May 23 '12 at 19:35

Bob Kaufman

12,864
16
78
107

answered Feb 15 '11 at 20:18

Jay

11
1

score 1 · Answer 7 · answered Apr 24 '09 at 13:02

1

ExcelApp.Interactive = false suppresses any dialog box.

excelApp.ActiveWorkbook.SaveAs(exportDirectory)

answered Apr 24 '09 at 13:02

Vincent Van Den Berghe

5,425
2
31
40

C# and Excel Interop issue, Saving the excel file not smooth

7 Answers7

Linked