Write From One Excel File to a New File

[jpreziuso]

I am not familiar with these new Excel activities. How come I can’t read a sheet from one excel file and write that data table into a brand new excel file? Ignore the file paths, I shortened them to remove confidential information.

Thanks

[Parvathy (PS Parvathy)]

Hi @jpreziuso

Follow the below process. It will help you.

Regards,

[jpreziuso]

In this scenario, what do you put as the destination for the Write DataTable activity? Because if you use the same path referenced for Use Excel File, it gives an error.

[Parvathy (PS Parvathy)]

@jpreziuso

Do you want it to write to same excel different sheet or into a new excel. Please specify.

Regards,

[jpreziuso]

Entirely new Excel file/sheet

[lrtetala (Lakshman Reddy)]

Hi @jpreziuso

Try below process

Hope this helps!!

[Parvathy (PS Parvathy)]

In the first Use Excel file you give the input path of excel and read range and store it in an data table.

In the second Use Excel File you will give the path where to write the excel and in Write DataTable to Excel activity give as below:

What to Write: Datatable variable
Destination: Excel2.Sheet(Sheet1)

Regards,