Get struck using RPA.Excel.Application

RPA
1

Hi All,

Have you ever encountered such problem: use RPA.Excel.Application to handle excel file (.xlsb), it gets struck while I use close_document method.

I have done many things before I close the workbook, such as copy data from other excel to the different sheets of this excel, refresh PVT, calc the formula and so on.

After that, I want to save and close this excel file (the size is about 300MB++), it always strucks even few hours, I have to stop the RPA robot manually, when I re-open the excel file manually it shows that it had to be repaired.

I really have no idea how to do that now, who can help me?

Thank you very much.

2

mistake word “struck” → “stuck”