Copy Sheet from ten Excel to Another one Excel

Help Studio
, ,
1

Hi I want to copy sheet name “Sheet” from ten excel and paste the sheet into another excel with the name “ALL”, one under the other. I used Read Range and Append Range but I could not get picture in the excel also its font changed. So I used Copy Sheet activity but no advanced options. How can I do this?

2

@murat.karasoy

Please try with copy/paste range activity…it will copy the format as well

You can append by counting the rows and incrementing to get the cell numbers

Cheers

3

Hi @murat.karasoy

Try this-

  • Use the “Excel Application Scope” activity to open the destination Excel file (
  • Use the “Copy Sheet” activity to copy the “Sheet” from each source file to the destination file.
  • Set the “SourceSheet” property of the “Copy Sheet” activity to “Sheet” and the “DestinationSheet” property to the desired sheet name in the destination file, such as “Combined”.
  • Use the “Append Range” activity to append the data from each source DataTable to the “Combined” sheet in the destination file.
  • Set the “DataTable” property of the “Append Range” activity to the DataTable variable that holds the data from each source file.
  • To preserve formatting, make sure the destination file has the same formatting settings as the source files.

Thanks!!

4

Hi @Nitya1

image
image1285×468 17 KB

That is not clear. Can you describe on screenshot?

5

Hi @murat.karasoy ,

Take a look on this . it may help you.

Regards
Balamurugan.S

6

Hi @balupad14
image
I want to collect an existing sheet. Also this metod only let me one page to one page. I want to collect ten sheets into one sheet.

1 Like
7

Hi @murat.karasoy ,

The destination excel file already has the sheet name. give some different name to the destination sheet name.

Regards
Balamurugan.S