How can excel be parsed based on country and cell type?

Question

go

Good afternoon, I tried to parse excel on go using two libraries:
github.com/tealeg/xlsx
github.com/360EntSecGroup-Skylar/excelize/v2

However, if you put the value 40.5 in the cell, then it will turn into 40.5 during parsing. Changing the cell type to tex, etc. Does not help. If you display information about a cell, then it is always numeric and in the Russian locale. If you put in the cell 40.5, 41.5, then everything is parsed normally.

Are there any libraries that take this into account or is there somewhere a set of rules by which excel understands how to display numbers?

Answer 1

So this is an old problem with Excel, treating strings as numbers if they look like numbers.
Put a single apostrophe ( ' ) at the beginning of such a string (the first character) - will not convert, and will not show the apostrophe itself in the cell.
I just don't know how the parsers will react to this trick.