Skip to content

Instantly share code, notes, and snippets.

@jennybc

jennybc/styles-no-prefix.xml

Created May 21, 2016 19:35
Show Gist options
  • Save jennybc/b519cb2b06ad83c201fddac1c28171e9 to your computer and use it in GitHub Desktop.
Save jennybc/b519cb2b06ad83c201fddac1c28171e9 to your computer and use it in GitHub Desktop.
Download ZIP
XML default namespace woes
Raw
styles-no-prefix.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006">
<numFmts count="1">
<numFmt numFmtId="164" formatCode="&quot;$&quot;#,##0.00"/>
</numFmts>
<fonts count="4">
<font>
<sz val="10.0"/>
<color rgb="FF000000"/>
<name val="Arial"/>
</font>
<font/>
<font>
<u/>
<color rgb="FF0000FF"/>
</font>
<font>
<b/>
<name val="Courier New"/>
</font>
</fonts>
<fills count="2">
<fill>
<patternFill patternType="none"/>
</fill>
<fill>
<patternFill patternType="lightGray"/>
</fill>
</fills>
<borders count="1">
<border>
<left/>
<right/>
<top/>
<bottom/>
</border>
</borders>
<cellStyleXfs count="1">
<xf borderId="0" fillId="0" fontId="0" numFmtId="0" applyAlignment="1" applyFont="1"/>
</cellStyleXfs>
<cellXfs count="16">
<xf borderId="0" fillId="0" fontId="0" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="4" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="2" numFmtId="0" xfId="0" applyFont="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="11" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="10" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="4" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="10" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="11" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="3" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="2" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="12" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="164" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyFont="1" applyNumberFormat="1"/>
</cellXfs>
<cellStyles count="1">
<cellStyle xfId="0" name="Normal" builtinId="0"/>
</cellStyles>
<dxfs count="1">
<dxf>
<font/>
<fill>
<patternFill patternType="solid">
<fgColor rgb="FFE69138"/>
<bgColor rgb="FFE69138"/>
</patternFill>
</fill>
<alignment/>
<border>
<left/>
<right/>
<top/>
<bottom/>
</border>
</dxf>
</dxfs>
</styleSheet>
Raw
styles-yes-prefix.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<styleSheet xmlns:d1="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006">
<numFmts count="1">
<numFmt numFmtId="164" formatCode="&quot;$&quot;#,##0.00"/>
</numFmts>
<fonts count="4">
<font>
<sz val="10.0"/>
<color rgb="FF000000"/>
<name val="Arial"/>
</font>
<font/>
<font>
<u/>
<color rgb="FF0000FF"/>
</font>
<font>
<b/>
<name val="Courier New"/>
</font>
</fonts>
<fills count="2">
<fill>
<patternFill patternType="none"/>
</fill>
<fill>
<patternFill patternType="lightGray"/>
</fill>
</fills>
<borders count="1">
<border>
<left/>
<right/>
<top/>
<bottom/>
</border>
</borders>
<cellStyleXfs count="1">
<xf borderId="0" fillId="0" fontId="0" numFmtId="0" applyAlignment="1" applyFont="1"/>
</cellStyleXfs>
<cellXfs count="16">
<xf borderId="0" fillId="0" fontId="0" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="4" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="2" numFmtId="0" xfId="0" applyFont="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="11" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="10" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="4" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="10" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="11" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="3" numFmtId="0" xfId="0" applyAlignment="1" applyFont="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="2" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="12" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="164" xfId="0" applyAlignment="1" applyFont="1" applyNumberFormat="1">
<alignment/>
</xf>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyFont="1" applyNumberFormat="1"/>
<xf borderId="0" fillId="0" fontId="1" numFmtId="3" xfId="0" applyFont="1" applyNumberFormat="1"/>
</cellXfs>
<cellStyles count="1">
<cellStyle xfId="0" name="Normal" builtinId="0"/>
</cellStyles>
<dxfs count="1">
<dxf>
<font/>
<fill>
<patternFill patternType="solid">
<fgColor rgb="FFE69138"/>
<bgColor rgb="FFE69138"/>
</patternFill>
</fill>
<alignment/>
<border>
<left/>
<right/>
<top/>
<bottom/>
</border>
</dxf>
</dxfs>
</styleSheet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment