How to copy Excel sheet to another Excel file?

Help Activities
, ,
1

I would like to copy 1 excel sheet to another Excel file. how to build this?

3

Hi @Nightowl_music

  1. read Range the Sheet you want store in the datatable
  2. Write range in the sheet or excel file you want

Regards
Sudharsan

1 Like
4

Do you want to copy to a existing excel file with data or just a new excel file?

5

yes exactly

6

how to build that?

8

Hi @Nightowl_music

Read range the excel with worbook activity.

write range the Dt.

Please refer to the screen shot below.

image
image1250×594 27.5 KB

Regards

9

I don’t want the formulas in the new excel file.
how to fix that?

10

Hi @Nightowl_music

Hope possibly the above method works for your case.

If possible can you share the excel file?

Regards

11

it work but don’t want the formulas in the new sheet

12

Also you could just use copy sheet activity if you want to copy the entire sheet.
If you want the values instead of formula you will have to work with the clipboard:
Read Range > Set to clipboard > Use Paste Special Shortcut in the target file (i.e. ctrl + alt + v)