Excel Application Scope Issue

Help
, ,
1

Hi Team,

I am new to Uipath. I am facing a weird issue in Uipath whenever i am trying to run excel application scope the bot is creating some dummy instances of an excel sheet and it is coming up in the datatable. Any operation that is performed on the datatable treats the instances as separate excel file and trying to perform the operation and getting error. Kindly suggest how to get the issue resolved.
The name of the instances are coming up as ~$XYZ Pty Ltd.

Thanks
Ankita

2 Likes
2

@Ankita_Biswas_SDC_Ko

I think you have enabled the hidden items option in the folder options. That’s why it is showing as separate file. Whenever you open an excel file it would create an instance of the file name as you mentioned “~$XYZ” just disabled it and try again.

1 Like
3

Hi @Ankita_Biswas_SDC_Ko

Welcome to UiPath Community Forum.

Your using workbook activities before run workflow please close excel file
If your using excel activities follow the below steps.

1.Use excel application activity pass the excel path where you save that file.
2.Next use Read Range activity create output Data table variable.
3.And then use write range activity pass data table variable.

Regards,
Kommi Jeevan.

1 Like
4

Can you show us your work flow to easily address the issue @Ankita_Biswas_SDC_Ko

cheers :smiley:

Happy learning :smiley:

1 Like
5

uncheck the visible in excel application scope

1 Like
7

Hi
Kindly go to DESIGN Tab in studio → Manage Packages → Project Dependencies → and imuninstall the excel package and reinstall the same package by searching that from Official tab
—and once after installing restart the studio and try once
—along with this use a KILL PROCESS Activity before excel application scope and mention the process name property as “EXCEL” so that it will kill any background running process with excel application

—and also if we are facing any issue still with EXCEL related activities then try with WORKBOOK related activities that is search in activity panel as Workbook and it will list the same se of activities that we have in excel activities package also

Kindly try this and let know for any queries or clarification
Cheers @Ankita_Biswas_SDC_Ko

1 Like