How to parse this kind of excel files?

Question

Parsing

Good day!

The problem is the following. I have an excel file with multiple tables on one sheet. The columns of these tables occupy several columns of the Excel file (that is, the cells are merged) and in different numbers. The question is how to parse it? How do I get the lists that will be related to a particular table (and not get a list of values ​​from all tables in it's heap) and how do I get the values ​​of the cells when they are merged and they all combine a different number of cells? I would be grateful if there are any tips for implementing in C#.

Link to file

PS: I don't need a complete solution, just the general parsing logic.

Answer 1

You read the title, then down a line and to the right until you reach a blank space, then back to the left and down a line. So until you get to a new heading. Along the way, you check that the cell is not merged. If combined, you skip. Well, this is in general terms.