Scheme Data Type Relationships


<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac x16r2 xr" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:x16r2="http://schemas.microsoft.com/office/spreadsheetml/2015/02/main" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision"> <fonts count="7" x14ac:knownFonts="1"> <font> <sz val="11"/> <color theme="1"/> <name val="宋体"/> <charset val="134"/> <scheme val="minor"/> </font> <font> <b/> <sz val="11"/> <color theme="1"/> <name val="宋体"/> <charset val="134"/> <scheme val="minor"/> </font> <font> <sz val="12"/> <color theme="1"/> <name val="宋体"/> <charset val="134"/> <scheme val="minor"/> </font> <font> <b/> <sz val="14"/> <color rgb="FF000000"/> <name val="宋体"/> <charset val="134"/> </font> <font> <b/> <sz val="14"/> <color theme="1"/> <name val="宋体"/> <charset val="134"/> <scheme val="minor"/> </font> <font> <b/> <sz val="12"/> <color rgb="FF000000"/> <name val="微软雅黑"/> <charset val="134"/> </font> <font> <sz val="9"/> <name val="宋体"/> <charset val="134"/> <scheme val="minor"/> </font> </fonts> <fills count="4"> <fill> <patternFill patternType="none"/> </fill> <fill> <patternFill patternType="gray125"/> </fill> <fill> <patternFill patternType="solid"> <fgColor rgb="FFFBE5D6"/> <bgColor indexed="64"/> </patternFill> </fill> <fill> <patternFill patternType="solid"> <fgColor rgb="FFA5A5A5"/> <bgColor indexed="64"/> </patternFill> </fill> </fills> <borders count="4"> <border> <left/> <right/> <top/> <bottom/> <diagonal/> </border> <border> <left style="hair"> <color rgb="FF000000"/> </left> <right style="hair"> <color rgb="FF000000"/> </right> <top style="hair"> <color rgb="FF000000"/> </top> <bottom style="hair"> <color rgb="FF000000"/> </bottom> <diagonal/> </border> <border> <left style="thin"> <color rgb="FF000000"/> </left> <right style="thin"> <color rgb="FF000000"/> </right> <top style="thin"> <color rgb="FF000000"/> </top> <bottom style="thin"> <color rgb="FF000000"/> </bottom> <diagonal/> </border> <border> <left/> <right style="hair"> <color rgb="FF000000"/> </right> <top style="hair"> <color rgb="FF000000"/> </top> <bottom style="hair"> <color rgb="FF000000"/> </bottom> <diagonal/> </border> </borders> <cellStyleXfs count="1"> <xf numFmtId="0" fontId="0" fillId="0" borderId="0"> <alignment vertical="center"/> </xf> </cellStyleXfs> <cellXfs count="18"> <xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"> <alignment vertical="center"/> </xf> <xf numFmtId="0" fontId="1" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="0" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="0" borderId="2" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center" wrapText="1"/> </xf> <xf numFmtId="0" fontId="0" fillId="3" borderId="3" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="3" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="0" borderId="2" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="0" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="0" fillId="0" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center" wrapText="1"/> </xf> <xf numFmtId="0" fontId="3" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="4" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment vertical="center" wrapText="1"/> </xf> <xf numFmtId="0" fontId="5" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="5" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center" wrapText="1"/> </xf> <xf numFmtId="0" fontId="2" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="2" fillId="3" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="3" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="4" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> <xf numFmtId="0" fontId="4" fillId="3" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"> <alignment horizontal="center" vertical="center"/> </xf> </cellXfs> <cellStyles count="1"> <cellStyle name="常规" xfId="0" builtinId="0"/> </cellStyles> <dxfs count="0"/> <tableStyles count="0" defaultTableStyle="TableStyleMedium2" defaultPivotStyle="PivotStyleLight16"/> <extLst> <ext uri="{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"> <x14:slicerStyles defaultSlicerStyle="SlicerStyleLight1"/> </ext> <ext uri="{9260A510-F301-46a8-8635-F512D64BE5F5}" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"> <x15:timelineStyles defaultTimelineStyle="TimeSlicerStyleLight1"/> </ext> </extLst> </styleSheet> 和<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2" xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{00000000-0001-0000-0000-000000000000}"> <dimension ref="A1:O3"/> <sheetViews> <sheetView tabSelected="1" workbookViewId="0"> <selection activeCell="K1" sqref="K1"/> </sheetView> </sheetViews> <sheetFormatPr defaultColWidth="9" defaultRowHeight="13.5" x14ac:dyDescent="0.15"/> <cols> <col min="1" max="1" width="9" style="2"/> <col min="2" max="2" width="17.625" style="6" customWidth="1"/> <col min="3" max="3" width="56.625" style="3" customWidth="1"/> <col min="4" max="4" width="2.625" style="4" customWidth="1"/> <col min="5" max="9" width="2.625" style="2" customWidth="1"/> <col min="10" max="11" width="2.625" style="5" customWidth="1"/> <col min="12" max="15" width="2.625" style="2" customWidth="1"/> </cols> <sheetData> <row r="1" spans="1:15" x14ac:dyDescent="0.15"> <c r="B1" s="7"/> <c r="C1" s="8"/> <c r="D1" s="5"/> </row> <row r="2" spans="1:15" ht="18.75" x14ac:dyDescent="0.15"> <c r="A2" s="1"/> <c r="B2" s="9"/> <c r="C2" s="10"/> <c r="D2" s="15" t="s"> <v>0</v> </c> <c r="E2" s="16"/> <c r="F2" s="16"/> <c r="G2" s="16"/> <c r="H2" s="16"/> <c r="I2" s="16"/> <c r="J2" s="17"/> <c r="K2" s="17"/> <c r="L2" s="16"/> <c r="M2" s="16"/> <c r="N2" s="16"/> <c r="O2" s="16"/> </row> <row r="3" spans="1:15" ht="18" x14ac:dyDescent="0.15"> <c r="A3" s="11" t="s"> <v>1</v> </c> <c r="B3" s="11" t="s"> <v>2</v> </c> <c r="C3" s="12" t="s"> <v>3</v> </c> <c r="D3" s="13"> <v>1</v> </c> <c r="E3" s="13"> <v>2</v> </c> <c r="F3" s="13"> <v>3</v> </c> <c r="G3" s="13"> <v>4</v> </c> <c r="H3" s="13"> <v>5</v> </c> <c r="I3" s="13"> <v>6</v> </c> <c r="J3" s="14"> <v>7</v> </c> <c r="K3" s="14"> <v>8</v> </c> <c r="L3" s="13"> <v>9</v> </c> <c r="M3" s="13"> <v>10</v> </c> <c r="N3" s="13"> <v>11</v> </c> <c r="O3" s="13"> <v>12</v> </c> </row> </sheetData> <sheetProtection formatCells="0" insertHyperlinks="0" autoFilter="0"/> <mergeCells count="1"> <mergeCell ref="D2:O2"/> </mergeCells> <phoneticPr fontId="6" type="noConversion"/> <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/> <pageSetup paperSize="9" orientation="portrait" horizontalDpi="180" verticalDpi="180" r:id="rId1"/> </worksheet> 针对这两个xml文件,我现在想要获取表格里面的内容样式,现在该怎么用poi实现并且放到我需要的对象里面好完成复制
05-15
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值