How to add Data to a specific Column Without Loop

Help Activities
, ,
1

Hello all, I want to update some data to a specific column of first row in a datatable using assign activity without suing loop. Can anyone help me with this?

2

@Aswini

You can do like this

dt.Rows(0)("ColumnName") = "Value"

cheers

3

HI @Aswini

Have you Tried with Write cell activity?

or

Use For each Row in Data Tbale activity (Inside the Loop)

Use Assign activity

Currentrow("ColumnName") = "Value"

Regards
Gokul

4

I have tried this but getting error “Exception has been thrown by Target of Invocation.”

5

Hello, i want to add to data table but not to excel.

6

Hi @Aswini

Try this

YourDataTable.Rows(0)("ColumnName") = "NewValue"

7

Hi @Aswini

Have you tried with Add data row activity

image

8

Hey @Aswini

It is working

Please try this

image

Input DataTable:

image

O/P:

image

9

@Aswini

May I know where did you try

Did you try in invoke code?

Cheers

10

Hi @Aswini

Check these steps:

  1. Double check that the column name is spelled correctly and exists in your Datatable.
  2. Verify that the Datatable is not null or empty.
  3. Ensure that the column data type matches the data type of the value you’re trying to assign.
11

i tried in Assign activity

12

Thanks for answering. I have tried the same but getting error ’ Exception has been thrown by Target of invocation. ’

13

Can you show the screenshot of how you are trying @Aswini

and try to run the code in debug mode then you will find out where the error occurs

14

@Aswini

can you share the screenshot where you are getting error

cheers

15

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