How to extract only the data from column B and insert it into a web page, each row must be inserted into the following fields
in excel read range use Excel.Sheet(“Sheetname”).Range(“B:B”) this ensures only B column is read or instead of B:B use A1 and in for each row currentrow(1).ToString will give data for each row for each iteration
else directly use dt.rows(0)(1).ToString will give the value of first row second column similarly increase 0 to 1,2,3 to get each row
dt is the datatable in which data is present
cheers
Just read range the whole sheet and then only use the column you want.
It worked @Anil_G
Thank you.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.