For each excel file, split two data tables and write to different sheet

Help Studio
, ,
1

Hello,

Please help me on the below automation.

For each excel file,split data table (Remittance Payments & Invoices) and write to different sheet.
I am able to write only Invoices data to another sheet.(payment 1 ).
Sheet(Payment 2) is same as original data.
Please find workflow.and sample input file.
FileManipulation.xaml (18.3 KB)
Payments (59) (1).xlsx (9.2 KB)

2

Hi! The file you uploaded is a bit different than the file you used for the sample .xaml file. It does not contain the column “Initiated On” .
image
I also wanted to ask, will there always be an empty space between the Invoices header? Do you want to build this automation only by using DataTables or would you like with Modern Experience of Excel as well?

3

@AlfredSzene ,
From main xml file please disable (Insert/Delete Rows & Auto Fit Range Activity).It will work.
And Yes to use modern activities.

4

@POOJA_MARUTI_BALIGIDE
Please find attached below the solution solved with Excel Activities. You can also find the excel file after processing. Let me know if there are any questions about the solution. If this works for you, please mark this as the solution.

Happy automation!
Payments (59).xlsx (9.8 KB)
Main.xaml (10.8 KB)

5

@AlfredSzene ,

Thank you very much for your response.
I am able to see the file manipulation process during the execution but unable to locate or find the file in local system after processing.

6

The content will be saved over the same file.
If you want to save it as another file, make sure to add a “Save Excel File As”

7

@AlfredSzene ,

Currently I am processing “Payment 50.xlsx” file.This file is not updated or modified.

but I can see the file manipulation process during execution.

8

Is it a test file or a personal file? If its a test one, can I have a look to see if I get the same output?

9

Try with this one now. I added the “Save Excel File” for you. it should save the content over the same file.
Main.xaml (10.9 KB)

10

@AlfredSzene ,

It is able to create two different sheets but two data tables are not completely written in sheets.

11

Perhaps is the layout of the file different than the one posted above?

12

@AlfredSzene ,

I sent the same file format with different contents as in information data.

13

Try to adjust the BlankRows variable inside the .xaml. It should work as long as you have at least one empty row between the two tables.