I have a spreadsheet where the header row may get moved, so I have no way of knowing which row to start reading. I would like to write a program that will find the row that contains a header I know is in it and then reads all the values under those headers. Is there a way to do this? I’ve kinda hit a wall.
I have attempted a few different methods, but none have worked. I’m thinking maps may be beneficial for storing the data, but I am still struggling to see how to find the header row.
New contributor
Rose South is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
5