シート全選択コピー＆ペーストについて

日本 フォーラム
1

範囲をコピー/貼り付けアクティビティを使用して、Excelのあるシートの全範囲をコピーし、別のExcelのあるシートに貼り付けをしたいです。この場合、ソースとターゲットともにシートまでの指定（rangeは指定しない）で対応できるものでしょうか。

2

Hie @delica22 how about using Copy/Paste Activity to copy from one sheet to another.

The image shows an Excel automation process using UiPath that copies a range from Sheet2 to Sheet3 within the "Skip.xlsx" file, including headers and not transposing the data. (Captioned by AI)
The image shows an Excel automation process using UiPath that copies a range from Sheet2 to Sheet3 within the "Skip.xlsx" file, including headers and not transposing the data. (Captioned by AI)538×452 16.1 KB

cheers

3

If the requirement is to copy one complete sheet to another sheet in the same excel - Yes, it is possible using Copy Paste Range activity

Just need to mention the sheet name only as given below.

image
image652×651 39.2 KB

Else if the requirement is to copy one full sheet from one workbook to another workbook - I don’t see any direct activity available. You could combine read range activity and write data table to excel for achieving the same