I want to add one column at last of the excel file i have using read range workbook activity for reading file

Help Studio
, ,
1

i want to add one column at last of the excel file i have use read range workbook activity for reading file and its mandatory

2

Use the Add Data Column activity to add a column to the datatable. Then populate it depending upon your needs. Then Write Range to a new Excel file and delete the old Excel file.

3

hi @venkatasai ,

  • The Read Range activity reads the data from the Excel file into a DataTable.
  • The Add DataColumn activity adds a new column to the DataTable.
  • The Write Range activity writes the modified DataTable back to the Excel file.

image
image719Ă—460 16.1 KB

image
image724Ă—269 7.96 KB

4

i need configuration properties of the add data column

5

please provide properties of the add data column activity i got error object reference is not set to anyinstance like that

6

The error message “Object reference not set to an instance of an object” typically occurs when you’re trying to access or use an object that has not been initialized or assigned a value yet.

In the context of the Add DataColumn activity, this error could occur if you haven’t properly initialized the DataTable variable before using it. Make sure that the DataTable variable you’re trying to add a column to has been assigned a value .

check the data table

image
image410Ă—515 21 KB

1 Like
7

Hey @venkatasai

Try This:

image
image362Ă—447 11 KB

Column Name: “New Column”
Type Argument: The Type of value you want to store in new added column.
Default Value: You can also add a default value all the rows in that column will have same values.
AutoIncrement: Value will be Automatically incremented!

Refer Below mentioned documentation for better understanding:

Regards,
Ajay Mishra