How to add 2 columns at the end of all the columns

Help Automation Ops
,
1

How to add 2 columns at the end of all the columns. If the column index is unknown, how to add the columns at the end

2

@anjani_priya

Just use add data column and columns would be added at the end

Cheers

3

Hi @anjani_priya

Try this

image
image809×848 41.4 KB

Cheers!!

4

@anjani_priya

Input:

image
image642×627 7.05 KB

Output:

image
image655×556 6.77 KB

Cheers!!

5

@anjani_priya

  1. Read Range Activity: Use the “Read Range” activity to read the data from your Excel file into a DataTable. Configure the activity to read the desired range from your Excel file and store the output in a DataTable variable (let’s call it dt).
  2. Add Data Column:
  • Add an “Add Data Column” activity.
  • Configure the activity as follows:
    • DataTable: dt
    • Column Name: “NewColumn1” (You can change the name as needed)
    • Data Type: System.String (You can change the data type as needed)
    • Default Value: Leave it blank or specify a default value if needed.
  • Add another “Add Data Column” activity for the second new column:
    • DataTable: dt
    • Column Name: “NewColumn2” (You can change the name as needed)
    • Data Type: System.String (You can change the data type as needed)
    • Default Value: Leave it blank or specify a default value if needed.
  1. Write Range Activity: Use the “Write Range” activity to write the updated DataTable back to your Excel file. Configure the activity to write the DataTable dt to the desired range in your Excel file.
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.