I need to solve Excel issue

Help Activities
, ,
3

Follow below steps

  1. Build one data table with only headers as Description, Quantity and rate and save to data table variable Dt_output

  2. Open excel file and use read range activity to read the complete sheet

  3. Loop through the range

  4. Check if Quantity have value or not

  5. If value available, Use Add Data Row Activity and add details to Dt_output {Description, Quantity, Rate}

  6. Get the last row count of Dt_output

  7. if quantity is blank - read the description and append to last row description of Dt_output

  8. Next loop

At the end -Dt_output will have the required results. Save to another excel file

1 Like