Read multiple Excel sheets and write multiple separate files with a template

[dayj2]

I have multiple issues with this process but will start with the simple, I think, issue. I created a template file that contains an excel table that supports 2 pivot tables to paste data I will copy from the source file. My issue is the excel table in the template is not expanding or accepting the written data. The data is just being written over the table. It works properly outside of UiPath.

The source file contains multiple sheets and I have a for each sheet loop because I want to copy each sheet and create separate files for each department to be emailed separately.

[Nithinkrishna]

@dayj2

My issue is the excel table in the template is not expanding or accepting the written data

Could you please explain a bit more on this point ?

[dayj2]

I have actually since figured it out. I needed to have the excel file open with application scope. Thank you.

[dayj2]

I do have another question though. I have a for each sheet loop to read multiple sheets and paste the data in a new excel file.

1. Is there a way to skip sheets with no data, just an empty table?
2. Is there a way to skip a certain sheet, titled “raw data”?

[Nithinkrishna]

Hey @dayj2

Just add an IF block inside loop and check condition after the Read Range activity.

dtData.RowCount > 0

Hope that helps

Thanks
#nK

[dayj2]

It worked. Thank you!!

[Nithinkrishna]

Cool buddy