I’m new on UiPath and need your help for my project.
I would want to create new Excel files based on an initial one named “TEST_JSON_EXTRACTV2.xlsx” and then, append range (screen enclosed)
ReadExcel.xaml (13.2 KB)
For each User (variable value) in Column A, I want to create, daily, new Excel files. “TEST_JSON_EXTRACTV3” +""+Datetime.Now.toString(“dd-MM-yyyy”)+""+sUSER.ToString+".xlsx"
If an excel already exists, then append data below.
And, I also want to increment Excel files with its own rows
For example :
For the excel “TEST_JSON_EXTRACTV3_19-06-2019_carole.xlsx” ; I will have lines 1 and 2
For the excel “TEST_JSON_EXTRACTV3_19-06-2019_carole.xlsx” ; I will have line 3
Creation is OK but append range doesn’t work very well as it is overwriting data…. And dispatch is not OK …
I share the xaml for easy guidance …
Can you please help me?