Excel manipulation . Is it possible to do the ff automation without opening the excel file ? . Thanks.
Input.xlsx (7.7 KB)
Help would be appreciated , thank you.
Hi @Jelrey ,
Edit: Yes. It is possible to manipulate the excel without open it.
Please try something like this:
File: DoubleClick.xaml (4.9 KB)
Best regards,
Marius
Hi Sir thank you , but how do we copy the data without affecting the original design and template ?
using the write range some of the data is not copied and some templates also like font types and stuffs.
and when I run it again I got error “Read Range: Can’t find final date delimiter (‘#’).”
@Jelrey ,
What do you mean “but how do we copy the data without affecting the original design and template ?”
Would you like to write the data on a different excel file? If so, just modify the absolute file path from the Write Range activity
Concerning “using the write range some of the data is not copied and some templates also like font types and stuffs.” , could you please share some print screens from your workflow & data file.
Best regards,
Marius
This is how should the data look from sheet1 to sheet2 without changes in template , font etc.
Book1.xlsx (9.0 KB)
Hi @Jelrey ,
The you should replace the Read Range & Write Range from the provided example with the Duplicate Sheet activity ( https://docs.uipath.com/studiox/v2019/docs/duplicate-sheet-x ) from Studio X
Keep the Write Cell activity in order to add the cell with the current date
Hope this helps
Best regards,
Marius
there are no Duplicate Sheet activity in UIPath , do you have sample?
Hi @Jelrey ,
Duplicate Sheet is a studiox activity.
Please check this post https://forum.uipath.com/t/how-do-you-access-a-uipath-studiox-activity-in-uipath-studio/287953 to see how to enable it in your case
Hope this helps
Best regards,
Marius
