Hello guys,
I have a project which reads variables from excel file and keep them at datatable. After that ı try to write them by using " for each row in datatable " activity. When ı check my dt, it keeps all the values correctly. But when i run the file it just writes “System.Data.DataRow” as variable. Could not manage to understand why. Waiting for ideas. Thanks !
Here is my excel activites;
Here is my for each row in dt activities;
THANKS EVERYONE !
@arif_samet_ipek
After Read Range
Use Output Datatable Activity -->it gives the output as string then you are see your entire datatable data
Use message box
You have given CurrentRow.toString right in the assign activity.
In CurrentRow it stores the whole row data, but you want a column data in a row right.
Then you have to give the column name in the Currentrow then it will give the row data in the specified column. Then you have to use the below expression in the assign activity,
- Assign -> teklimarka = CurrentRow("Sepecify the column name here").toString
The above expression will store the row data in a specific column.
Hope it helps!!
te…marka =CurrentRow.ToString
result to get returned the DataType, as a to String on a complex datatype will not mandatory return values. It is up to the .Net implementation on how the toString() will return an information
As mentioned above:
for column access use CurrentRow(ColNameOrIndex).toString
For a complete row column values ← s for multiple you can do:
String.Join("|" CurrentRow.ItemArray)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale