I would like to copy 1 excel sheet to another Excel file. how to build this?
- read Range the Sheet you want store in the datatable
- Write range in the sheet or excel file you want
Do you want to copy to a existing excel file with data or just a new excel file?
how to build that?
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?
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)