I want to extract table and in table i want to get the text in the last row which have value percentage

i want to extract table and in table i want to get the text in the last row which have value percentage
image
i want total percentage

Use this linkq.

dtExcel.AsEnumerable().Select(Function(r) CInt(r.Field(Of String)(“Column”).Replace(“.”,“,”).replace(“,”,“.”).Substring(0, r.Field(Of String)(“Column”).Length-2).Trim)).ToList().Average

Is this table on the web or in an Excel sheet?

3 Likes