Opening Excel files from C#

Question

I have an issue when working with Excel from C# using the Microsoft.Office.Interop.Excel object.

The problem comes when I try and open a file to write to that I have already have open in Excel. This ultimately errors and then leaves an instance of Excel running in the background.

How can I tell that the file is already open before opening it?

Also what is the convention for disposing with the Excel objects and therefore killing the Excel process?

The following article provides a good way of checking if a file is open already: stackoverflow.com/questions/876473/… This article talks about killing the excel process: stackoverflow.com/questions/9316141/kill-process-excel-c-sharp — Gaz Winter
– Gaz Winter, Commented Jul 25, 2012 at 11:43

Aghilas Yakoub · Accepted Answer · 2012-07-25 11:53:57Z

0

Hello you must to dispose your excel objects at end of treatment (workbook, applicationClass, usedRange, worksheet)

        workbook.Close(false, workbookPath, null);
        applicationClass.Quit();

        while (Marshal.ReleaseComObject(usedRange) > 0)
        { }
        while (Marshal.ReleaseComObject(worksheet) > 0)
        { }
        while (Marshal.ReleaseComObject(workbook) > 0)
        { }
        while (Marshal.ReleaseComObject(applicationClass) > 0)
        { }

answered Jul 25, 2012 at 11:53

Aghilas Yakoub

29k5 gold badges49 silver badges51 bronze badges

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

Comments

Josef · Accepted Answer · 2014-06-23 08:43:21Z

For opening of already opened - for more just type Workbooks.Open on the MSDN. Here is the save sample, you just overwrite (an still opened) without querying :o), xlShared and xlLocalSessionChanges are keywords.

            _xlsWorkbook.SaveAs(
                 targetFileName                                                     /* Filename */
                ,Excel_ForMissing.XlFileFormat.xlExcel8                             /* FileFormat */
                ,Missing.Value                                                      /* Password */
                ,Missing.Value                                                      /* WriteResPassword */
                ,Missing.Value                                                      /* ReadOnlyRecommended */
                ,Missing.Value                                                      /* CreateBackup */
                ,Excel_ForMissing.XlSaveAsAccessMode.xlShared                       /* AccessMode */
                ,Excel_ForMissing.XlSaveConflictResolution.xlLocalSessionChanges    /* ConflictResolution */
                ,false                                                       /* AddToMru */
                ,Missing.Value                                                       /* TextCodepage */
                ,Missing.Value                                                       /* TextVisualLayout */
                ,true                                                       /* Local */
            );

Collectives™ on Stack Overflow

Opening Excel files from C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related