Error exporting data to MS Access

[artembrizinskij]

Hello!
I'm trying to create a new data source in ms access from an xlsx file that I created using LargeXlsx.

But I get the following error:

If I just open xlsx in ms excel and resave it (without editing), then the data source is created successfully after that.

[artembrizinskij]

I decided to look into it deeper, and it seems to have already been fixed in this commit ade2fed
As I found out, the row number attribute was required for the export to work

[RFlipper]

@salvois I would appreciate if you find some time to create a new new release with the fix.

[MarkPflug]

This is likely my fault: #21

According to the specification:

<xsd:complexType name="CT_Row">
 <xsd:sequence>
 <xsd:element name="c" type="CT_Cell" minOccurs="0" maxOccurs="unbounded"/>
 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
 </xsd:sequence>
 <xsd:attribute name="r" type="xsd:unsignedInt" use="optional"/>

Note the "r" attribute is marked as optional, so I would argue this is a bug in MS Access.

However, I think #31 added an option to force these attributes to be written, because it seems like a lot of readers don't correctly handle this scenario. So, you should be able to produce compliant files already with slight modification to your code.

[salvois]

Hi @artembrizinskij , @RFlipper ,
I have just released release 1.9.0 which allows to include row and cell references even when redundant.
Please feel free to check whether that solves your issue.
Thanks,
Salvo

[salvois]

Hi @artembrizinskij , @RFlipper ,
I'm closing this issue. Should the problem persist, please reopen it.
Thanks,
Salvo