How to pick data from an unstructured excel?

[Anived_Mishra]

Hi community, I have test data in an excel file and I need to pick the highlighted line (which is the last line under that before new number starts) balance value under 2.11.1, 1.10.2 and 2.15.4, what’s the best way to do it ?

Regards

Anived

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

First read the entire file to remove all data
Then use for each row in data table
search for lines
returns the index and then reads the data back to this line
regards,

[Anil_G (Anil Gorthi)]

@Anived_Mishra

Try this linq …it should get only the rows you need

Dt.AsEnumerable.Select(function(x) If(x(0).ToString.Contains("DATE"),i-2,0)).where(function(x) x>0).ToArray

This would give all the indexes you need as array of integers except the dt.Rowcount-1 which you can add at the end

Cheers

[Anived_Mishra]

Hey all, I got a work around. I got the row number for the Gl and the value above that ow will correspond to the previous Gl and the last GL would be the last row in the excel so it’s all good now. Closing this topic as this has been solved :). Thanks for your responses @Nguyen_Van_Luong1 @Anil_G