How to read

Help Studio
, ,
19

@WadeShon Check this Workflow :
I think I was able to use the template and Append the Data Starting from A7. The Splitting and recognising of different tables in Excel is working based on the Game Number (Game 1, Game 2 etc…) So this is a required data in the excel to separate.

I have not used any extra Activities for this, only UiPath related activities.
Check the Output Folder Execute the Workflow. All files should be generated in the Ouptut folder.
If it is not the expected one, please explain a bit more in detail.
Split Excel Tables Into Separate Sheets.zip (31.3 KB)

Also This does not Protect the Excels using Password. There are a few ways of making it possible using Balareva activities such as below one :

1 Like