Excel Copy Sheet to another File

Help Studio
, , , , , ,
1

How can we use Excel Application Scope and Create copy from Current Excel File to another File?

Example

  1. Abc.xlsx contains Sheet1 , Sheet2

  2. So Create New.xlsx contains Sheet6 (In Sheet 6 it should contain same data as Sheet1 from Abc.xlsx

2

@anmita First you need to read sheet1 and save it in datatable then
create another file with sheet name sheet6 and write datatble in it.

3

HI @anmita

Try this

Read the Sheet 1 from abc.xlsx and write range in the New.xlsx in sheet 6

Regards
Sudharsan

4

Read Range into a datatable from the first file, Write Range to the second file with a sheet name that doesn’t already exist.

5

Hii @raja.arslankhan , @Sudharsan_Ka , @postwick

I tried the methods suggested but its giving an Exception. Could you share a xml file if possible

Thanks and Regards
@anmita

6

Can you share the screenshot of activities and the exception?

7

image
image835×285 11.2 KB

Hii @Sudharsan_Ka

Its Shows this Error

8

Are you sure you are using correct datatable variable which you used for the read range above?

9

Yes have used the same one @Sudharsan_Ka

10

Make sure you don’t have it defined twice. Search the variable name using Universal Search and see if it appears twice.

11

Hello @anmita

Please check whether the below video can help to solve the issue.

Thanks