Kendo styles.xml is incompatible with MS ODBC Driver

[Alex-Bubblemaster]

Enhancement

Excel files generated by Kendo Excel Export cannot be imported by the MS ODBC Driver. The error reported in this forum thread is: External table is not in expected format.

Current behaviour

If the file is opened and resaved with Excel or if the stles.xml file is replaced with any styles.xml generated by MS Excel, the error does not occur. When compared the styles.xml of Excel does not contain a numberFormat, no other obvious major differences at first glance:

E.g.:

<numFmts count="2">
<numFmt formatCode="#" numFmtId="165" />
<numFmt formatCode="#" numFmtId="166" />
</numFmts>

Expected/desired behavior

If possible, modify the styles.xml template to enable seamless use with OleDB

Environment

• Kendo UI version: 2016.3.914
• jQuery version: 1.12

[bericson]

Hi, has there been any movement on this topic?

[dragonlong206]

My team is facing the same issue. Is there any update?

[donny-situngkir]

Is there any update on this one?