Hello, I have a process that copies lines from one Excel file to another. This is looped about 15 times, during which Excel is opened and closed over and over. After a few loops, the process usually errors out because an Excel file didn’t open like it was supposed to, and so the robot could not f…

Hello @in006 Are you forced to copy data from excel rather than just using Read Range activity?

Excel Scope could potentially leave an instance opened in the background. I would recommend always using Close Workbook activity at the end of your scopes; you can just use a Workbook variable as the Output of the Excel scope, then place that variable in the Close Workbook. I don’t know if that sol…

Hi @reda , Yes, I can’t use read range because of the large number of lines. UiPath just crashes.

Thanks for the suggestion @ClaytonM , I do use an Excel Scope in my process, I’ll try adding the Close Workbook activity. What about when opening Excel with Open Application? Do you know if this method also leaves an Excel instance opened in the background? Thank you, Ian

Open Application will leave the file opened, but not usually in the background. If there is a rare situation where you need to use that prior to an Excel Scope (maybe to leave file open), make sure you close it with either Close Window or Close Workbook.

Hi @in006 I wanted to know that you have this problem of large excel sheets to suggest other packages to try in case you didn’t try them before, these are the packages [1] the XlExcel has its own excel application scope and a read range activity hope that was helpful

Hi @in006 , To Copy the Excel data you can use this activity. [image] BalaReva.Excel.Activities Community Feed Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to th…

@ClaytonM I use Open Application to open Excel but to close it I usually just click the X button or send ALT+F4. That might be why Excel instances are staying open in the background. I’ll try closing with Close Window or Close Workbook. Thanks again, Ian

Excel Process Hung

Help

balupad14 (Balamurugan (BalaReva)) November 8, 2018, 11:41pm 8

Hi @in006,

To Copy the Excel data you can use this activity.

Regards
Balamurugan.S

Topic		Replies	Views
Excel is open still program running is completed Studio studio , question , activities_panel	7	827	March 16, 2023
How to keep EXCEL open even end of workflow Activities excel	6	2839	December 7, 2020
Excel Processes not closing after Close Workbook activity Help	8	8085	January 28, 2020
Excel Application Scope for each Invoice sheet: Failed opening the Excel file Studio excel , uiautomation , activities , studio , question , activities_panel , excel-scope	11	1857	September 6, 2022
Using an already open Excel workbook Activities excel , activities , question	14	5759	October 20, 2020

Excel Process Hung

Related topics