Reading the data from excel

Learning Hub Academy Feedback
1

Hello alll,
how to read the column data , but the column name is number like 12…
and the data i want to read is present in 7 row…

please help me out with this…

Thanks and Regards
paro…

2

have you tried read cell/column

3

it wont work because my column name is number…any other way

4

screenshot of your data

5

ERROR
ERROR1600×309 20.8 KB

ABOVE IS THE SCREENSHOT…

6

Hi @parvati,

Is the value you are getting will always be there in column 12 and the rows start point, length, decimal and type rows will be constant i mean always these 4 will be there, if yes can you use read range and tell how many rows are there.

datatable.rows(datatable.rows.count).item(12).tostring

7

read cell will work for this. your excel is showing in R1C1, do some research on it to convert to the other cell reference style and use it in read cell

8

it is not working…

9

not an efficient way of doing if you only need a cell

10

If you doesn’t know how many rows are there, then how you will use read cell and give cell reference

11

unless i am reading his topic wrong. but didn’t he mention column = 12 and row = 7. ?

12

I think you didn’t read my post properly thats y i have asked first are these rows constant, so there should be generalized soulution which works in all scenario not a particular one.

13

@parvati,

Can you be more specific what you want to achieve and as garywjd91 mentioned if the rows are constant then you can use Read cell activity, were you able to resolve the issue.

14

I want to read the data of row 7…

Thanks
Paro…

15

Did you use read cell and were you able to get the value

16

In The Priority Pannel the is an out put the Filed

There you can create the DataTable by Pressing the Ctrl+K short key

Then the sheet is OutPut’s DataTable by the help of for each Row you can get the Data Where it is present in the column

The Syntax Like

Algorithm

use for 1 . For Each Row activity Pass the OutPut Resulted Table as Variable.

For item DataTableName
{
Message Box Activity: row.Item(Column_Number_That_You_Are Trying_To_Extract).To.String;
}

I Hope It Will Helpful