Append to a Excel that use date format

Build
, ,
#1

Hello, I wanted to add information at the end of my Excel file, the problem here is that all the Excel file is configured to use “US date” as format and the information I’m trying to add look like this:
ExcelFile(12)(0) = “WER23424”
ExcelFile(12)(1) = “3452”
ExcelFile(12)(3) = “123,45”

and Excel transform those into a date…

Is there any ways to bypass the Excel format?

Activity I’m using to do it:
Excel Application Scope
Append Range

Thanks.

#2

If you do not want to change the excel format.
Set the format of cell or columns to Text and then write the data to the Excel.

Regards,
Karthik Byggari

#3

Kindly Append along with a single quote like this so that it will entered as a text in excel columns
“‘“ + “WER23424”
“‘“ + “3452”
“‘“ + “123,45”

Cheers @MaxyArthes

#4

Thanks you! Totally forgot about this Excel option x) was too focused to find a solution that was about UiPath instead of Excel itself I guess.

1 Like
#5

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