Data from excel to out of excel

Help Activities
, ,
1

Hi Team,

i have a data table from excel sheet and i need to type it in other place out of excel however i am getting the below error

image

2

Hi @omar_ismail

If you want to get data from one specific column and row this is the expression you have to use.

dt.Rows(rowindex)(“yourcolumnname”).ToString

Hope this helps :slight_smile:

3

@omar_ismail you can’t type a data table in any element, Type Into activity’s input is a String!

To access each cell value you can use

dt.Rows(rowindex)(“yourcolumnname”).ToString

as mentioned by @AJ_Ask in the above post.

Note: Row Index means (Row Number - 1) of the value you want to put from the excel.

It will give a cell value which you can put in Type Into Activity!

Regards,
Ajay Mishra

4

Use ‘Output Data Table Activity’ above your ‘type Into’; as it will convert the data table variable to string variable and then pass this string in Type Into activity.