无论是动态生成行还是动态生成列,都要注意单元格合并的问题
原因:
1、做模板的excel文件不是wps和office通用的版本,所以生成的excel文件office无法识别
2、模板文件为xml格式的时候,里面有些字段在office中无法识别。参考office报错日志信息修改
在 样式 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Style
标志: NumberFormat
ATTRIB: Format
值: 0_
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 2
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 2
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 3
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 4
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 5
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 6
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 2
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 3
在 表 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Table
标志: Row
ATTRIB: Index
值: 4
在 工作表设置 出现 XML 错误
原因: 无效值
文件: C:\Users\Zhous\AppData\Local\Temp\skmlExcel1526972115396.xls
组: Worksheet
标志: Table
ATTRIB: ExpandedRowCount
值: 6
以上即为无法识别index和numberformat
下面附上模板文件代码
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>mocking</Author>
<LastAuthor></LastAuthor>
<Created>2018-05-17T06:23:39Z</Created>
<LastSaved>2018-05-17T06:31:50Z</LastSaved>
</DocumentProperties>
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<KSOProductBuildVer dt:dt="string">2052-10.1.0.7346
</KSOProductBuildVer>
</CustomDocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowWidth>27525</WindowWidth>
<WindowHeight>13650</WindowHeight>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="s40" ss:Name="强调文字颜色 4">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#FFC000" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#DDEBF7" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s32" ss:Name="适中">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C6500" />
<Interior ss:Color="#FFEB9C" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#E2EFDA" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s20" ss:Name="标题 2">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="2" ss:Color="#5B9BD5" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="13" ss:Color="#44546A"
ss:Bold="1" />
</Style>
<Style ss:ID="s16" ss:Name="警告文本">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FF0000" />
</Style>
<Style ss:ID="s1" ss:Name="货币[0]">
<NumberFormat
ss:Format="_ "¥"* #,##0_ ;_ "¥"* \-#,##0_ ;_ "¥"* "-"_ ;_ @_ " />
</Style>
<Style ss:ID="s8" ss:Name="千位分隔">
<NumberFormat
ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ " />
</Style>
<Style ss:ID="s43" ss:Name="强调文字颜色 5">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#4472C4" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s31" ss:Name="好">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#006100" />
<Interior ss:Color="#C6EFCE" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#F4B084" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#C9C9C9" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s7" ss:Name="差">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C0006" />
<Interior ss:Color="#FFC7CE" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s48" ss:Name="60% - 强调文字颜色 6">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#A9D08E" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#D9E1F2" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s30" ss:Name="汇总">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#5B9BD5" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#5B9BD5" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"
ss:Bold="1" />
</Style>
<Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#DBDBDB" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s44" ss:Name="40% - 强调文字颜色 5">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#B4C6E7" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s25" ss:Name="计算">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00"
ss:Bold="1" />
<Interior ss:Color="#F2F2F2" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s19" ss:Name="标题 1">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="2" ss:Color="#5B9BD5" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="15" ss:Color="#44546A"
ss:Bold="1" />
</Style>
<Style ss:ID="s13" ss:Name="注释">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#B2B2B2" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#B2B2B2" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#B2B2B2" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#B2B2B2" />
</Borders>
<Interior ss:Color="#FFFFCC" ss:Pattern="Solid" />
</Style>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment />
<Borders />
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#EDEDED" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s5" ss:Name="千位分隔[0]">
<NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ " />
</Style>
<Style ss:ID="s46" ss:Name="强调文字颜色 6">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#70AD47" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s45" ss:Name="60% - 强调文字颜色 5">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#8EA9DB" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#FCE4D6" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s34" ss:Name="强调文字颜色 1">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#5B9BD5" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s26" ss:Name="检查单元格">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#3F3F3F" />
<Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#3F3F3F" />
<Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#3F3F3F" />
<Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#3F3F3F" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"
ss:Bold="1" />
<Interior ss:Color="#A5A5A5" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s22" ss:Name="标题 3">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="2" ss:Color="#ACCCEA" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A"
ss:Bold="1" />
</Style>
<Style ss:ID="s17" ss:Name="标题">
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="18" ss:Color="#44546A"
ss:Bold="1" />
</Style>
<Style ss:ID="s10" ss:Name="超链接">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#0000FF"
ss:Underline="Single" />
</Style>
<Style ss:ID="s4" ss:Name="货币">
<NumberFormat
ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ " />
</Style>
<Style ss:ID="s47" ss:Name="40% - 强调文字颜色 6">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#C6E0B4" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#FFF2CC" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#F8CBAD" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s3" ss:Name="输入">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#7F7F7F" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F76" />
<Interior ss:Color="#FFCC99" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s39" ss:Name="强调文字颜色 3">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#A5A5A5" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s24" ss:Name="输出">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#3F3F3F" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#3F3F3F" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#3F3F3F" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#3F3F3F" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F3F"
ss:Bold="1" />
<Interior ss:Color="#F2F2F2" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#FFD966" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#9BC2E6" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s18" ss:Name="解释性文本">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#7F7F7F"
ss:Italic="1" />
</Style>
<Style ss:ID="s15" ss:Name="标题 4">
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A"
ss:Bold="1" />
</Style>
<Style ss:ID="s12" ss:Name="已访问的超链接">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#800080"
ss:Underline="Single" />
</Style>
<Style ss:ID="s11" ss:Name="百分比">
<NumberFormat ss:Format="0%" />
</Style>
<Style ss:ID="s42" ss:Name="40% - 强调文字颜色 4">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#FFE699" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" />
<Interior ss:Color="#BDD7EE" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s29" ss:Name="链接单元格">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"
ss:Color="#FF8001" />
</Borders>
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00" />
</Style>
<Style ss:ID="s28" ss:Name="强调文字颜色 2">
<Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" />
<Interior ss:Color="#ED7D31" ss:Pattern="Solid" />
</Style>
<Style ss:ID="s49" />
<Style ss:ID="s50">
<Alignment ss:Horizontal="Center" />
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="${rsvCountList?size + 2}"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25">
<Row>
<Cell ss:StyleID="s50">
<Data ss:Type="String">所在市</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">大(1)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">大(2)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">中型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">小(1)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">小(2)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">合计</Data>
</Cell>
</Row>
<#list rsvCountList as rsv>
<Row ss:Index="${rsv_index+2}">
<Cell ss:StyleID="s50"><Data ss:Type="String">${rsv.name!}</Data></Cell>
<#list rsv.countList as c>
<Cell ss:StyleID="s50"><Data ss:Type="String">${c.count!}</Data></Cell>
</#list>
<Cell ss:StyleID="s50"><Data ss:Type="String">${rsv.count!}</Data></Cell>
</Row>
</#list>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<Selected />
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>0</ActiveRow>
<ActiveCol>7</ActiveCol>
<RangeSelection>R1C8</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25" />
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25" />
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
ss:ExpandedRowCount="${rsvCountList?size + 2}"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25">
<Row>
<Cell ss:StyleID="s50">
<Data ss:Type="String">所在市</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">大(1)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">大(2)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">中型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">小(1)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">小(2)型</Data>
</Cell>
<Cell ss:StyleID="s50">
<Data ss:Type="String">合计</Data>
</Cell>
</Row>
<#list rsvCountList as rsv>
<Row ss:Index="${rsv_index+2}">
<Cell ss:StyleID="s50"><Data ss:Type="String">${rsv.name!}</Data></Cell>
<#list rsv.countList as c>
<Cell ss:StyleID="s50"><Data ss:Type="String">${c.count!}</Data></Cell>
</#list>
<Cell ss:StyleID="s50"><Data ss:Type="String">${rsv.count!}</Data></Cell>
</Row>
</#list>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<Selected />
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>0</ActiveRow>
<ActiveCol>7</ActiveCol>
<RangeSelection>R1C8</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25" />
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1"
x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54"
ss:DefaultRowHeight="14.25" />
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.511111111111111" />
<Footer x:Margin="0.511111111111111" />
</PageSetup>
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<PageBreakZoom>100</PageBreakZoom>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
上面标红处为常出错的地方
3、报错显示工作簿设置错误
原因:ExpandedRowCount 数字过小,一般多是标签里面关键词出错,如索引
4、报错显示表错误,查看错误日志--属性值为 Null 或缺少属性值
原因:(1)ss:StyleID="s63" 样式没有对应上,或者没定义
(2)