Validate Excel transactional data in SAP

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?


You can learn how to work with SAP and Excel here

Completely new SAP Academy course , to help you to learn the automation techniques and the best practices for SAP WinGUI automation

Best regards, Lev

Thank you, i will go through this.