xlsxir
xlsxir copied to clipboard
parse `inlineStr` cells within `t` XML elements
When parsing a cell with data type inlineStr
, the value is contained within this XML structure:
<is>
<t>
VALUE
</t>
</is>
Previously, these values were parsed only if they followed a cell wrapped in a v
element. This PR updates the worksheet parser to reset value_type
after parsing each cell, and include t
along with v
as value_type: :value
starters.
I was getting nil
values for text fields in some XLSX files until applying this patch.
👍🏻
Here the spec:
https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.inlinestring?view=openxml-2.8.1#remarks