Currently, i am trying to use Uipath to help automate financial statements in a word document. Below are some examples of the tables i have in my word documents:
2020 | 2019 | |
---|---|---|
$ | $ | |
Sales | 10 | 20 |
Other income | 40 | 60 |
Other services | 10 | 20 |
Service fees | 10 | 12 |
70 | 112 |
On Demand | Less Than Yr | More Than Yr | Total | |
---|---|---|---|---|
$ | $ | $ | $ | |
2020 | ||||
Payable | 10 | 10 | 10 | 30 |
Other Payable | 9 | 8 | 12 | 29 |
Amt Due | 10 | 12 | 8 | 30 |
29 | 30 | 30 | 89 | |
2019 | ||||
Payable | 8 | 7 | 6 | 21 |
Amt Due | 7 | 12 | 12 | 31 |
15 | 19 | 18 | 52 |
I am trying to basically automate the shifting of the 2020 data backwards and replace the 2019 data, and leave the 2020 column blank.
However, as you can see above the tables are in a different format for example the first table, you need to shift by column, shift the 2020 data to the right however for the 2nd table you have to shift by rows, shift 2020 data downwards to replace the 2019 data. Because the tables are different, it requires a different script/functions to shift by columns or rows.
I am currently using the macro function in word to automate the shifting then using Uipath to execute the macro, sending a hotkey to execute the macro in the word document.
So, as i have many different set of word documents/file all with slightly different format as well as number of tables and that the macro function is very limited/fixed, my question is that is there anyway where Uipath can loop through all the tables in the word document and if the table requires to shift by columns, it will execute a specific macro to shift by columns and if the table requires to shift by row, it will execute another macro to shift by rows instead?