Excel App Scope - Write Range

[prititit]

Hello,

I want to save my data on the excel file using the excel application scope. And the path of the excel file should be read on the excel app scope.

[Pratik_Wavhal]

Hi @prititit

Take assign activity within Then part and do the following

Within the variable the path will get assign

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[prititit]

Hello pratik,

Is this correct?

it says " Court Website: Could not open the specified workbook. Make sure there is no other wokbook with the same name already opened."

[Pratik_Wavhal]

Hi @prititit

You are reading from same Excel sheet and writing der itself so

Within Write cell activity instead of “A1” put another cell position below the data not above
FOr eg you can take “A4”, “B4”, “C4”, below the data

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[prititit]

Hello Pratik,

its still the same.

[Pratik_Wavhal]

Hi @prititit

Change the sheet name to some other name in the write cell activity

or else first check that is the visible flag is unchecked or not
if it is check then uncheck it as below

Happy Automation

Best Regards
Er Pratik Wavhal

[prititit]

Hi Pratik,

i also tried that. And its still not working

Main.xaml (41.6 KB) Data.xlsx (9.0 KB) Hello.xlsx (8.1 KB)

[Pratik_Wavhal]

Hi @prititit

Where is the below sheet “Court Website” in file Data ??

Below excel is also not present

And actually you are reading the website from same excel and writing to same excel sheet
Actually what you are trying to do i am not getting ??

Happy Automation

Best Regards
Er Pratik Wavhal

[Pratik_Wavhal]

Hi @prititit

Instead on using write cell activity of Excel you use
Write Cell Activity of workbook as shown below

And give the path der in the workbook path

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[prititit]

Sorry for that Pratik.

This should be the xaml file. I want to save the extracted data on the “Hello” excel file. By using the path of the “Hello” excel file from the “Data” file.

Main.xaml (27.1 KB)

[Pratik_Wavhal]

Hi @prititit

It is working correctly now without any issue and error.
I am attaching the Updated Workflow files below
temp.zip (37.2 KB)

Just change the below things as per your system path :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[prititit]

Hi Pratik ,

Thank you always for the help.

I’m still new to the uipath world and i have learned a lot from you.

Thank you for saving me!

[Pratik_Wavhal]

Hi @prititit

You are always welcome

Happy Automation

Best Regards
Er Pratik Wavhal