How to add a new column in excel data table

Help Studio
, ,
1

Hi Guys,

I wanted to add a new column named as “Status” in the excel (Data Table) .To write a status Fail or Pass after each transaction processing.

The number of columns can get vary always in the excel. i need to add the ‘status’ as a column name at the end before processing.

Let me know how to do this. Thank you!

2

Hi @vinutha1 ,

Use add to column activity, it will add column at the end
image

3

Hi @vinutha1

use ADD Data Column activity and create a column status Along with your current DT.

image
image622×604 13 KB

Regards

4

@pravin_calvin

I did the same. But its not updating the column and not even showing any error.

5

@vinutha1

If possible can you share me your workflow or screenshot?

Regards

6

@pravin_calvin

image
image1370×486 96.7 KB

7

image
image1406×517 114 KB

8

Hi @vinutha1

Are you updating any value to the column Status?

Regards

9

Yup…am suppose to update. Before that i need to add the ‘status’ column so that later i can update the results of each transaction.

10

could be because your argument type for the column is object. Try changing to string

11

@vinutha1

Add data column is like a temp column added to the datatable which re using to update try with updating with column name(“Status”) and write range the data table.

Hope Clear with the above explanation!

Regards

12

U mean, after add data column am supposed to use write range?

13

@Em126351

Tried…dint work

14

@vinutha1

Please refer to the xaml below.

Main.xaml (6.8 KB)
New Microsoft Excel Worksheet.xlsx (8.4 KB)

I have created with working example of add data column.

Regards

15

@pravin_calvin

Thanks a lot…it worked!

16

@vinutha1

Happy Automation!

Regards

17

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