无论是动态生成行还是动态生成列，都要注意单元格合并的问题
原因：
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="/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>-05-17T06:23:39Z</Created><LastSaved>-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]"><NumberFormatss:Format="_ "￥"* #,##0_ ;_ "￥"* \-#,##0_ ;_ "￥"* "-"_ ;_ @_ " /></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormatss: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="货币"><NumberFormatss: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）
如果觉得《freemaker导出Excel文件用WPS能打开 而用office打不开》对你有帮助，请点赞、收藏，并留下你的观点哦！
