Problem With a column created in excel

Help Studio
, ,
1

I have a problem. There is an extra row in excel created which I did not use Add Data Row for, and I’m having a trouble trying to find a way to remove it. It just says, “Text(column 1), 1(column 2)”

I’m using the Array Row property in the Add Data Row activity

Help is very much appreciated. Thank youexcel problem

2

Uncheck addheaders on your writerange activity to eliminate the datatable columns.

3

I did that, and it doesn’t appear. But in using Append Range, it doesn’t have that option, yet I still get the same Text, 1 columns. Sorry to bother you, bro.

4

Hi @carlow050

In this case you have use Header Names of the columns, instead column number, If you give the Names then even there is a change of the index also it will not create problem

Hope this helps you

Thanks

5

I see. The names of the array is the header in the Add Data Row. It wasn’t an entry. hmm. Thanks! I need to find a way to do an entry

6

@carlow050
Build data table before Add Data Row. and can you send the screenshot of build datatable?

7

can i see the Add Data Row property window?
@carlow050

8

In activity Build Data table, initially by default there will be a row as shown below
image

Please remove that row by click “x” mark

Regards,
Murali

2 Likes
9

Are you creating any New datatable ?

Can you please elaborate your process. ?

10

thank you for the tip ! It works !