How to extract value based on the header OR how to extract headers value from ods file in Ruby?

Question

Want to extract values under "Location" header.

EDIT: —-following extracted from following comments. It originally appeared this was a web related thing, but no, the OP is dealing with a spreadsheet, not a web page.)—-

This is an excel sheet and I want to extract the table values based on the header.

For Example :

xlsx = Roo::Spreadsheet.open('Demo.xls') values_under_headers = values_of("Location")

Something same which gives values from 1007,1008,1009.....

Answer 1

HTML code for what? This is an excel sheet and I want to extract the table values based on the header.

For Example :

xlsx = Roo::Spreadsheet.open('Demo.xls') values_under_headers = values_of("Location")

Something same which gives values from 1007,1008,1009.....