How to Move a Tab from one Excel WorkBook no another. (Copy Content and Format)

Help StudioX
,
1

Hello everyone!
I am moving one tab from one Excel file to another; however, it’s not copying the format.

I am using a read range activity to read the content on Excel1 and a Copy/Paste activity to paste to Excel2. But at the moment it is not working.

This is in StudioX; remember, there are limitations when compared to Studio. I would appreciate your help.

Happy automatoN!

2

Read Range just reads data, it doesn’t read format. How about just copying the file and then deleting the sheets you don’t need?

3

Could you please be more specific, should I use Copy/Paste activity only?

4

No. I meant copy file. But you don’t even have to do that. There is a Copy Sheet activity.

5

In StudioX? I dont see that activity at all.

6

So copy the file then delete the sheets you don’t need.

7

Thank you. But I am creating a file then I need to copy the tab to an specific excel file, I cannot just used the original file. I cant figure this out. Is it even possible with StudioX?

8

Try the Copy/Paste Range activity, it exists in StudioX