Get spesific row item

[Aditya_Nugroho]

hello. i have some problems. i want to get row item from datatable. and the master data is different excel file. but, the table is start from cell B4. And i must read range for 1 sheet full, not spesific cells. anyone help me please for my task:( can i make B4 a header?
thanks

[prasath_S]

Hi @Aditya_Nugroho

You can give range in read range as “B4:D100000”

and tick addheader property in read range

[Aditya_Nugroho]

i did that earlier, give a spesific range a “B4:D10000”. but the provisions from my leader, read range must be read full one sheet as “”

[prasath_S]

do you have data before 4th row and do you have data after d column…thanks

[Aditya_Nugroho]

yes i have. after that, any more table. the field is same, just different data.

[prasath_S]

can you show some sample excel files so it would be easy to understand…thanks

[Eric_Wong_Test (Eric Wong)]

Table.xaml (10.9 KB) Data.xlsx (9.2 KB)

Is it like that?

[Aditya_Nugroho]

No. is like this.Data.xlsx (9.0 KB)

just read the data, not header in every table

[Aditya_Nugroho]

Data.xlsx (9.0 KB)
this is my sample masterdata file

[Aditya_Nugroho]

and then this is my sample output

[vignesh.ks]

Hi @Aditya_Nugroho

For this scenario, you have to use two ‘Read Range’ activity. Please find the below screen shot of workflow.

Give cell range for the second ‘Read Range’ activity like below:

Try this and let me know whether it meet’s your expectation.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

[Eric_Wong_Test (Eric Wong)]

dt_data = dt.AsEnumerable.Where(Function (x) x(1).ToString.Contains(“P0”)).CopyToDataTable!

[Aditya_Nugroho]

hello @vignesh.ks big thanks for ur solution. and now my problem task has solved.
regards

[Aditya_Nugroho]

hello @Eric_Wong_Test big thanks for ur help! your wofklflow will be backup for my problem job. regardsss