Hello Developers,
I am working on developing a BOT where invoice data is stored in an excel.
Excel structure is shared below in the snapshot.
It has one column called “Request Number”.
This number will always be grouped together in excel
BOT is going to loop through each row of excel and do certain transactions which generate PDF files. Where I need help is:
- I want to create folder for each unique request number on a sharepoint.
- Transfer the files which are generated per row into respective folders.
For example: There are two rows with request number REQ1. There will be two pdf files which will have to be transferred and likewise.