Multiple thread access to Excel

Question

I have two methods, method1, method2, both have lock(App) where App is a static instance in the same class.

App is a static instance in a shared project Helper

void method1()
{
    lock(Helper.App)
    { 
       ExcelApp.FormulaCell.AddComments(errMsg);
    }
}

    void method2()
    {
        lock(Helper.App)
        {  
           //plot data (an 2-D array) to cells
           var dataRng = ExcelApp.CurrentSheet.Cells(Formulacell.Row + 1, Formulacell.Column + 1);
           dataRng = dataRng.get_Resize(n, m);
           dataRng.Value2 = data;
        }
    }

method1, method2 are called by many threads. I want at one time only method1 or method2 run The issue is they seem not.
in method1 & method2, I plot some data to Excel, I get Exception

Name:COMException Message:Exception from HRESULT: 0x800AC472

I googled and find the exception is caused by Excel Application is not ready. There is no UI gesture, so I conclude the exception is caused by the two methods try to write to Excel at the same time.

Are you currently experiencing method1() and method2() being run at the same time? — Jon Senchyna
– Jon Senchyna, Commented Apr 23, 2013 at 16:30
I'm sorry, I couldn't figure out what the problem is. What have you coded so far? Are you getting any error? — Andre Calil
– Andre Calil, Commented Apr 23, 2013 at 16:30
What you have there should work. What problems are you getting? — Matthew Watson
– Matthew Watson, Commented Apr 23, 2013 at 16:30
Using lock(App) produce a compile error because App is a type, not not a Type object. For future reference, you should post the compile error that you are getting when you pose questions like this. — Jon Senchyna
– Jon Senchyna, Commented Apr 23, 2013 at 16:34
@JonSenchyna: You're assuming that App is a type but the OP specifies in the OP that `App is a static instance' in that class. — Paul Sasik
– Paul Sasik, Commented Apr 23, 2013 at 16:40

Ofir · Accepted Answer · 2013-04-23 16:56:51Z

1

Please check if youre calling an async methods to excell.
If so, this is the problem, even though you used locks, the actual calls are running in the same time.
Try to wait till the excell methods ends.
Ofir

answered Apr 23, 2013 at 16:56

Ofir

2,2341 gold badge18 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Multiple thread access to Excel

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