styles.xml中缺少cellStyleXfs节点 [英] cellStyleXfs node is missing in styles.xml

问题描述

大家好，

我收到了一个xlsx文件，发现styles.xml中没有cellStyleXfs节点，这在APACHE POI api处理文件时会导致异常。

I received a xlsx file and found there is no cellStyleXfs node in the styles.xml, which cause exception when handling the file by APACHE POI api.

有人可能会提供缺少cellStyleXfs的可能原因吗？

Could someone provide probable reasons for the missing of cellStyleXfs?

谢谢

<?xml version="1.0" encoding="UTF-8"?>
<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<numFmts>
<numFmt numFmtId="0" formatCode="General"/>
<numFmt numFmtId="1" formatCode="#0"/>
<numFmt numFmtId="2" formatCode="M/d/yy h:mm a"/>
</numFmts>
<fonts>
<font><sz val="11"/><color theme="1"/><name val="Calibri"/><family val="2"/><scheme val="minor"/></font>
<font><sz val="9"/><color rgb="000000"/><name val="SansSerif"/><b val="false"/><i val="false"/><u val="single"/><strike val="false"/><family val="2"/></font>
<font><sz val="9"/><color rgb="000000"/><name val="SansSerif"/><b val="false"/><i val="false"/><u val="none"/><strike val="false"/><family val="2"/></font>
</fonts>
<fills>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="solid"><fgColor rgb="FFFFFF"/></patternFill></fill>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="solid"><fgColor rgb="FF0000"/></patternFill></fill>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="solid"><fgColor rgb="FFFF33"/></patternFill></fill>
<fill><patternFill patternType="solid"><fgColor rgb="339900"/></patternFill></fill>
<fill><patternFill patternType="solid"><fgColor rgb="FFFFFF"/></patternFill></fill>
</fills>
<borders>
<border><left/><right/><top/><bottom/><diagonal/></border>
</borders>
<cellXfs>
<xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"/>
<xf numFmtId="0" fontId="1" fillId="2" borderId="0" xfId="1" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true" horizontal="left" vertical="top"/><protection hidden="false" locked="true"/></xf>
<xf numFmtId="0" fontId="0" fillId="3" borderId="0" xfId="2" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true"/><protection hidden="false" locked="false"/></xf>
<xf numFmtId="0" fontId="2" fillId="4" borderId="0" xfId="3" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true" horizontal="left" vertical="top"/><protection hidden="false" locked="true"/></xf>
<xf numFmtId="0" fontId="2" fillId="5" borderId="0" xfId="4" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true" horizontal="right" vertical="top"/><protection hidden="false" locked="true"/></xf>
<xf numFmtId="1" fontId="2" fillId="6" borderId="0" xfId="5" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true" horizontal="left" vertical="top"/><protection hidden="false" locked="true"/></xf>
<xf numFmtId="2" fontId="2" fillId="7" borderId="0" xfId="6" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true" horizontal="left" vertical="top"/><protection hidden="false" locked="true"/></xf>
<xf numFmtId="0" fontId="0" fillId="8" borderId="0" xfId="7" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true"/><protection hidden="false" locked="false"/></xf>
<xf numFmtId="0" fontId="0" fillId="9" borderId="0" xfId="8" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true"/><protection hidden="false" locked="false"/></xf>
<xf numFmtId="0" fontId="0" fillId="10" borderId="0" xfId="9" applyAlignment="1" applyProtection="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"><alignment wrapText="true"/><protection hidden="false" locked="false"/></xf>
</cellXfs>
<dxfs count="0"/><tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleLight16"/>
</styleSheet>

推荐答案

您好pupifan

Hello pupifan

感谢您与Microsoft支持部门联系。支持工程师将与您联系以进一步提供帮助。

Thank you for contacting Microsoft Support. A support engineer will be in touch to assist further.

问候。

这篇关于styles.xml中缺少cellStyleXfs节点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！