How to copy Excel sheet to another Excel file?

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

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


1 Like

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

yes exactly

how to build that?

Hi @Nightowl_music

Read range the excel with worbook activity.

write range the Dt.

Please refer to the screen shot below.


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

Hi @Nightowl_music

Hope possibly the above method works for your case.

If possible can you share the excel file?


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

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)