Excel Sheet having two datas

Help Studio
, ,
1

image
image924×521 14.8 KB

Here is an excel having two school data in a single sheet. But i want to extract this data separately. The problem is that it should be dynamic we cant expect in which row data should be updated. I need this in linq query

1 Like
2

Hi @ajnaraya ,
I have same process with your topic
My solution is read all then split by key word
first you read all file to get data table,
then check index by 'School" to get each data
regards,

1 Like
3

Check this out

@ajnaraya

4

Hi @ajnaraya

Have you trie with Look up Rnage activity → Lookup the Name as column header

Get the index of the name and pass that index in the Read range activity

Regards
Gokul

1 Like
5

@ajnaraya

  1. Read all the data into Datatable
  2. Then get the rowindex of Name and then use that row index to split the data as you need

dt.AsEnumerable.Select(function(x,i) If(x(0).ToString.Equals("Name"),i,-1)).Where(function(x) x>0).ToArray()

Thsi will give you the index of all the name rows…as array use it to split the data as needed

cheers

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.