Creating a new excel by assigning the data received from the invoice to the variable

Help Robot
, ,
4
  • Read Source Excel File
  • Use Read Range to get data into a DataTable (e.g., dtSource).
  • Process and Extract Required Variables
  • Loop through dtSource using a For Each Row.
  • Extract required columns/values and store them as Object.
  • Prepare Destination DataTable
  • Use Build Data Table to create dtTarget with named columns.
  • Example: Columns: Name (String), Age (Int32), Address (String)
  • Add Rows to Destination Table
  • In the loop, construct each row using extracted Object values, converting them to appropriate types.
  • Use Add Data Row activity to add it to dtTarget.
  • Write to New Excel File
  • Use Write Range to write dtTarget into a new Excel file.

Mark as SOLUTION if you found this as solution

Happy Automation