issue parsing xlsx (formatting?) about xsv HOT 8 CLOSED

      <c r="A1" t="inlineStr">
        <is>
          <t>PartNumber</t>
        </is>
      </c>

This uses an inline string format I haven't seen before, documented here:

https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.inlinestring?redirectedfrom=MSDN&view=openxml-2.8.1

There's some esoteric stuff in here, but I'll make an update soon to deal with this plain text at least.

from xsv.

just noticed that just changing something in that file and saving it again is already enough in order to get the file parse correctly. But what could be wrong with that file then? in excel it is showing all correct?

from xsv.

FYI: I found the root cause why this issue came up for me. it was related to the way the file was created. as mentioned here:
Paxa/fast_excel#63 (comment)

But I didn't have this issue with the previous xlsx-parser I used for importing. So I think this is something that could be fixed in this gem as well.
(For reference. the previous xlsx parser I used for reading excel-files was creek. But that gem has some pending issues that didn't get resolved why I had to switch:

from xsv.

@crepon-philipp could you test against master and see if this solves your issue?

from xsv.

@martijn Hmm, Looking still the same

from xsv.

Weird.. are you sure you are using the master branch from GitHub? I have not yet released a new version.

This is what I get:

irb(main):001:0> w = Xsv::Workbook.open("formatting_issue.xlsx")
irb(main):002:0> w.sheets[0][0]
=> ["PartNumber", "Brand", "SubBrand", "PopulationStatus", "PartType", "UniversalPart", "BasePartNumber", "Gtin", "GtinQualifierCode", "GtinQualifierName", "QuantitySize", "QuantitySizeUom", "ContainerType", "QuantityPerApplication", "QuantityPerApplicationUom", "QuantityPerApplicationQualifier", "EffectiveDate", "AvailableDate", "MinimumOrderQuantity", "MinimumOrderQuantityUom", "PartGroup", "PartSubGroup", "PartCategoryCode", "Unspsc", "VmrsCode", "Position", "DefaultMfrLabel", "DefaultApplicationQty", "Tags"]
irb(main):003:0> w.sheets[0][1]
=> ["P76550M-2", "1234", "1234", "Active (Publish to receiver database)", "Fuel Pump Module Assembly", 0, nil, "00019826103970", "UP", "UPC", 1, "EA", "BX", "1", "EA", "MAX", nil, "2019-08-23", 1, "EA", nil, nil, "550303", "40151532", "044003258", nil, nil, 1, nil]

from xsv.

My bad. Using master it is now working as expected 👍

from xsv.

Great. I completed the support and released Xsv 0.3.18 with these changes.

Thanks for using Xsv!

from xsv.