Add data row problem

Help Activities
, ,
1

I want to add new URL row in excel files
{CurrentRow(“Rank”).ToString+new Object(CurrentRow(“Firm Name / Headquarters”).ToString)+CurrentRow(“MP / CEO”).ToString+CurrentRow(“Net Revenue”).ToString+CurrentRow(“Url”).ToString}
can you check the error please

Company data
Company data949×205 14 KB

capture 8
capture 8558×587 20.7 KB

2

Hi @UJJVAL_BHAGAT

You need to use , in add Data Row. Try yhe below syntax:

{CurrentRow(“Rank”).ToString, (CurrentRow(“Firm Name / Headquarters”).ToString), CurrentRow(“MP / CEO”).ToString, CurrentRow(“Net Revenue”).ToString, CurrentRow(“Url”).ToString}

Regards

3

@UJJVAL_BHAGAT,

You should be pass array to Add Data Ro like below:
New Object() {CurrentRow(“Rank”).ToString, (CurrentRow(“Firm Name / Headquarters”).ToString), CurrentRow(“MP / CEO”).ToString, CurrentRow(“Net Revenue”).ToString, CurrentRow(“Url”).ToString}

Thanks,
Ashok :slight_smile:

4

@UJJVAL_BHAGAT

You need not do add row again as the data is already in datatable

The previous assign will take care of adding url in the respective column

After the loop just write back the datatable to excel

Cheers