How create tabs in excel without opening it?

Help Something Else
, , , , ,
#1

Excel manipulation . Is it possible to do the ff automation without opening the excel file ? . Thanks.

  1. create a new tab in excel with the name “Sample1”
  2. copy the data from the existing tab named “Sample2” to “Sample1”
  3. the bot will fill in Cell “C1” with the current date.

Input.xlsx (7.7 KB)

#2

Help would be appreciated , thank you.

#3

Hi @Jelrey ,

Edit: Yes. It is possible to manipulate the excel without open it.

Please try something like this:

Sol
Sol398×509 11.1 KB

File: DoubleClick.xaml (4.9 KB)

Best regards,
Marius

1 Like
#5

Hi Sir thank you , but how do we copy the data without affecting the original design and template ?

#6

using the write range some of the data is not copied and some templates also like font types and stuffs.

#7

and when I run it again I got error “Read Range: Can’t find final date delimiter (’#’).”

#8

@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

#9

This is how should the data look from sheet1 to sheet2 without changes in template , font etc.

BOOK1
BOOK11109×1002 163 KB

Book1.xlsx (9.0 KB)

#10

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

How to copy sheet tab data to other sheet tab in excel without affecting the template?
#11

there are no Duplicate Sheet activity in UIPath , do you have sample?

#12

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