xlsxir icon indicating copy to clipboard operation
xlsxir copied to clipboard

parse `inlineStr` cells within `t` XML elements

Open superhawk610 opened this issue 2 years ago • 1 comments

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.

superhawk610 avatar Dec 13 '21 23:12 superhawk610

I was getting nil values for text fields in some XLSX files until applying this patch.

👍🏻

nathany-copia avatar Jan 17 '22 18:01 nathany-copia

Here the spec:

https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.inlinestring?view=openxml-2.8.1#remarks

RodolfoSilva avatar Jan 16 '23 22:01 RodolfoSilva