Can't use relative path in 'Append Range Workbook' activity

Help Studio
, ,
1

Hi All,
I use a relative path inside the ‘Append Range Workbook’ activity and when I try to run the workflow there is an error.

This image shows a UiPath Studio interface with a workflow for an employee data verification process, highlighting an error in the 'Append Range Workbook' activity. (Captioned by AI)
This image shows a UiPath Studio interface with a workflow for an employee data verification process, highlighting an error in the 'Append Range Workbook' activity. (Captioned by AI)1920×1080 306 KB

Then I tried to run the workflow with an absolute path inside the ‘Append Range Workbook’ activity and it ran successfully.

The image shows a screenshot of the UiPath Studio interface, highlighting the ExtractData workflow with an Append Range Workbook activity and various project files and properties visible. (Captioned by AI)
The image shows a screenshot of the UiPath Studio interface, highlighting the ExtractData workflow with an Append Range Workbook activity and various project files and properties visible. (Captioned by AI)1920×1080 314 KB

This is how I created the Excel file in another workflow.

The image shows the UiPath Studio interface with a workflow open, involving actions like building a data table and writing it to an Excel workbook, as well as automating interactions in a web browser. (Captioned by AI)
The image shows the UiPath Studio interface with a workflow open, involving actions like building a data table and writing it to an Excel workbook, as well as automating interactions in a web browser. (Captioned by AI)1920×1080 309 KB

I need to use the date in the file name because the Excel file needs to be created and filled in daily. Is there any advice on how to solve the problem?
Thanks

2

Hi

It seems double quote matter. For now, can you try to replace (re-type) all the double quote wilth " (0x22 character)? (Please copy and pate this character " if necessary)

FYI

Regards,

2 Likes
3

I already replaced the double quote in the workflow by copy-pasting the character you give, but when I ran the file the error is still exist

image

Thanks

4

Do the same, replacing double quotes, for Sheet Name

Also, I recommend using String.Format instead of concatenating to define the file name

5

Hi @Nafissa_Al_Abida

The error you are getting refer that your doubles are not correct given in Append Range Workbook.

Try the below in Append Range Workbook

"SFRequestData"+Today.ToString("MMddyyyy")+".xlsx"

Regards

6

I try to use string.Format and it worked, Thanks

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.