Display data of particular row using excel activities

[Mansi_08 (Mansi Choubey)]

I am fetching the data of 16th row and displaying it on the console.

keep in mind— index starts from 0,if header is included 16th row will be given as 14 in code.
as 16 = 15 because of index.
16=14 in code if headers are included.
Activities →
read range
Assign
for each
write line

process →
1.read range – give sheet number(example" sheet1")
2.Assign – arr_Row=datatable.rows(14).itemarray

data type of arr_Row should be object
3.for each –
for each item in arr_Row
inside body , give write line activity and write – Convert.ToString(item)
.

please let me know if it useful.

[VirajN (Viraj Nalawade)]

this is extremely helpful, but what is your question?

[Mansi_08 (Mansi Choubey)]

@VirajN

this is extremely helpful, but what is your question

fetch the 16th row from excel sheet.

[VirajN (Viraj Nalawade)]

Are you getting any specific error while doing the steps that you have mentioned?

[Mansi_08 (Mansi Choubey)]

I am sharing a solution.

[VirajN (Viraj Nalawade)]

Why? This topic has been covered already in the forum. What you are doing might account to spamming the forum.

@loginerror

[Mansi_08 (Mansi Choubey)]

because I tried the other solutions, there were not helpful, i have created keeping in mind small things like what data type it should have, array object, a layman should also be able to understand, step by step.

[VirajN (Viraj Nalawade)]

once again this is explained so much better in detail in posts earlier. i am not trying to demotivate you but you should research the forum before posting.

How to select a particular row and get the value of the row in a particular column

I have this excel file that looks like below. I would like to filter and get this particular row which contains (Weekly/MonthlyFile) and the value in the row of the 3rd column (It has a header not shown below but named ‘amount’). In the end i shud get the value ‘111’. How can i go about doing this? Without hardcoding like the row number as the row isnt constant Book1.xlsx (10.9 KB) [image] Thank you xoxo

Excel Automation to get specific data

@shruti, Follow these steps, Read Range - Output to a datatable (Say dt) Assign - Find the index of your desired first row (here PO NUMBER, MODEL,QTY…) integer Count = dt.Rows.IndexOf((From row in dt.Select() Where String.Join(“”,row.ItemArray()).Contains(“PO NUMBER”) Select row).ToArray()(0)) Assign - Extract from that index till last row of datatable dt datatable dtFinal = (From row in dt.Select() Select row).Skip(Count).Take(dt.Rows.Count - Count).CopyToDatatable() Now use thi…

[Mansi_08 (Mansi Choubey)]

I am really grateful Viraj, but what I have developed is way to simpler and easy to understand, isn’t it? less complex and very easy to understand with proper activities and its description .

[VirajN (Viraj Nalawade)]

you haven’t developed anything, this is the standard way to do this. you just wrote it down.

i am not going to continue with spamming the forum.

[Mansi_08 (Mansi Choubey)]

peace

[mohammed_zain]

Thanks bro i got the values of single row,but i want to write in another excel that row which i got.

Thanks a lot.

[mohammed_zain]

Data type should be system.collection.enumerable.

Thanks