Hi, I have below requirement.
I have an excel with multiple rows and column values. Each excel row contains a Sales order, delivery, Invoice etc about 20 columns. I have to perform below actions for each Row:
- Check if a value exists in excel
- Connect to SAP and validate the transactions of each column
- Take screenshots of each document
- Create another excel sheet with name as Col 1 and attach the screenshots to the excel.
These steps needs to be done for each Row of an excel. If there are 20 Rows, then there should be 20 excel sheets created. Can someone guide me on how to process these?