dom4j生成复杂excel表格

生成后效果:

 

基础模板:sae.xml

<?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"><LastAuthor>Administrator</LastAuthor><Created>2018-08-14T01:13:58Z</Created><LastSaved>2018-08-14T02:42:34Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><KSOProductBuildVer dt:dt="string">2052-10.1.0.7400</KSOProductBuildVer><KSOReadingLayout dt:dt="boolean">1</KSOReadingLayout></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>28695</WindowWidth><WindowHeight>13200</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></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="_ &quot;¥&quot;* #,##0.00_ ;_ &quot;¥&quot;* \-#,##0.00_ ;_ &quot;¥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;¥&quot;* #,##0_ ;_ &quot;¥&quot;* \-#,##0_ ;_ &quot;¥&quot;* &quot;-&quot;_ ;_ @_ "/></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="Default" ss:Name="Normal"><Alignment/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#D8E4BC" 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="#DAEEF3" ss:Pattern="Solid"/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#EBF1DE" ss:Pattern="Solid"/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#A7BFDE"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#1F497D" ss:Bold="1"/></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="s45" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#92CDDC" 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="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C4D79B" ss:Pattern="Solid"/></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="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#B1A0C7" 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="#DA9694" ss:Pattern="Solid"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#1F497D" 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="s17" ss:Name="标题"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="18" ss:Color="#1F497D" ss:Bold="1"/></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="s18" ss:Name="解释性文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#7F7F7F" ss:Italic="1"/></Style><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#4F81BD"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="15" ss:Color="#1F497D" ss:Bold="1"/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#4F81BD"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="13" ss:Color="#1F497D" ss:Bold="1"/></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="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#95B3D7" 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="s48" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FABF8F" 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="#B8CCE4" 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="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#4F81BD" 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="#FDE9D9" ss:Pattern="Solid"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#4F81BD"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#4F81BD"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C0504D" 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="#B7DEE8" 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="#F2DCDB" 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="s46" ss:Name="强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#F79646" 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="s47" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FCD5B4" 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="#DCE6F1" ss:Pattern="Solid"/></Style><Style ss:ID="s42" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCC0DA" 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="#E6B8B7" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#4BACC6" 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="#9BBB59" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#8064A2" 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="#E4DFEC" ss:Pattern="Solid"/></Style><Style ss:ID="s49"><Alignment/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s50"><Alignment/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s51"><Alignment ss:Horizontal="Center"/><Borders/><Font ss:FontName="方正小标宋_GBK" x:CharSet="134" ss:Size="18"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s52"><Alignment ss:Horizontal="Justify"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s53"><Alignment/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s54"><Alignment/><Borders/><Font ss:FontName="Wingdings" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s55"><Alignment ss:Horizontal="Left"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s56"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s57"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s58"><Alignment ss:Vertical="Top"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s59"><Alignment ss:Vertical="Top" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s60"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s61"><Alignment ss:WrapText="1"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s62"><Alignment ss:Horizontal="Center" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s63"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s64"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s65"><Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s66"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s67"><Alignment/><Borders><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s68"><Alignment/><Borders><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s69"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s70"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s71"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s72"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s73"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s74"><Alignment/><Borders><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s75"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s76"><Alignment ss:Horizontal="Left"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s77"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s78"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s79"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s80"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s81"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s82"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s83"><Alignment ss:WrapText="1"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s84"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s85"><Alignment ss:Horizontal="Center" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s86"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s87"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s88"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s89"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s90"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s91"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s92"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s93"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s94"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s95"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s96"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s97"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s98"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s99"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s100"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s101"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s102"><Alignment ss:Horizontal="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s103"><Alignment ss:Horizontal="Center" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s104"><Alignment ss:Vertical="Top"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s105"><Alignment ss:Vertical="Top" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s106"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s107"><Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s108"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s109"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s110"><Alignment ss:WrapText="1"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s111"><Alignment/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s112"><Alignment/><Borders><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style></Styles>
</Workbook>

代码:

private void exportExcel() {
    try {
        File file = ResourceUtils.getFile("classpath:static/templates/sae.xml");
        SAXReader reader = new SAXReader();
        Document doc = reader.read(file);
        Element workBook = doc.getRootElement();
        Namespace namespace = workBook.getNamespace();
            Element workSheet = workBook.addElement(new QName("Worksheet",namespace));
            workSheet.addAttribute("ss:Name","Sheet1");
                    Element names = workSheet.addElement(new QName("Names",namespace));
                        Element namedRange = names.addElement(new QName("NamedRange",namespace));
                        namedRange.addAttribute("ss:Name","Print_Area");
                        namedRange.addAttribute("ss:RefersTo","=Sheet1!R1C1:R45C16");
                Element table = workSheet.addElement(new QName("Table",namespace));
                table.addAttribute("ss:ExpandedColumnCount","23");
                table.addAttribute("ss:ExpandedRowCount","45");
                table.addAttribute("x:FullColumns","1");
                table.addAttribute("x:FullRows","1");
                table.addAttribute("ss:StyleID","s50");
                table.addAttribute("ss:DefaultColumnWidth","54");
                table.addAttribute("ss:DefaultRowHeight","14.25");
                    Element column1 = table.addElement(new QName("Column",namespace));
                    column1.addAttribute("ss:StyleID","s50");
                    column1.addAttribute("ss:Width","66.75");
                    column1.addAttribute("ss:AutoFitWidth","0");
                    column1.addAttribute("ss:Index","2");
                    Element column2 = table.addElement(new QName("Column",namespace));
                    column2.addAttribute("ss:StyleID","s50");
                    column2.addAttribute("ss:Width","69.75");
                    column2.addAttribute("ss:AutoFitWidth","0");
                    column2.addAttribute("ss:Index","7");
                    Element column3 = table.addElement(new QName("Column",namespace));
                    column3.addAttribute("ss:StyleID","s50");
                    column3.addAttribute("ss:Width","63.75");
                    column3.addAttribute("ss:AutoFitWidth","0");
                    Element column4 = table.addElement(new QName("Column",namespace));
                    column4.addAttribute("ss:StyleID","s50");
                    column4.addAttribute("ss:Width","68.25");
                    column4.addAttribute("ss:AutoFitWidth","0");
                    Element column5 = table.addElement(new QName("Column",namespace));
                    column5.addAttribute("ss:StyleID","s50");
                    column5.addAttribute("ss:Width","64.5");
                    column5.addAttribute("ss:AutoFitWidth","0");
                    Element row1 = table.addElement(new QName("Row",namespace));
                    row1.addAttribute("ss:StyleID","s50");
                    row1.addAttribute("ss:Index","2");
                        Element row1cell1 = row1.addElement(new QName("Cell",namespace));
                        row1cell1.addAttribute("ss:StyleID","s50");
                        row1cell1.addAttribute("ss:Index","2");
                            Element data1 = row1cell1.addElement(new QName("Data",namespace));
                            data1.addAttribute("ss:Type","String");
                            data1.setText("附表1");
                    Element row2 = table.addElement(new QName("Row",namespace));
                    row2.addAttribute("ss:StyleID","s50");
                    row2.addAttribute("ss:Index","4");
                    row2.addAttribute("ss:Height","22.5");
                        Element row2cell1 = row2.addElement(new QName("Cell",namespace));
                        row2cell1.addAttribute("ss:StyleID","s51");
                        row2cell1.addAttribute("ss:Index","4");
                        Element row2cell2 = row2.addElement(new QName("Cell",namespace));
                        row2cell2.addAttribute("ss:StyleID","s51");
                        Element row2cell3 = row2.addElement(new QName("Cell",namespace));
                        row2cell3.addAttribute("ss:StyleID","s51");
                        Element row2cell4 = row2.addElement(new QName("Cell",namespace));
                        row2cell4.addAttribute("ss:StyleID","s51");
                        Element row2cell5 = row2.addElement(new QName("Cell",namespace));
                        row2cell5.addAttribute("ss:StyleID","s51");
                            Element row2cell5data1 = row2cell5.addElement(new QName("Data",namespace));
                            row2cell5data1.addAttribute("ss:Type","String");
                            row2cell5data1.setText("药 品 不 良 反 应 / 事 件 报 告 表");
                        Element row2cell6 = row2.addElement(new QName("Cell",namespace));
                        row2cell6.addAttribute("ss:StyleID","s51");
                    Element row3 = table.addElement(new QName("Row",namespace));
                    row3.addAttribute("ss:StyleID","s50");
                        Element row3cell1 = row3.addElement(new QName("Cell",namespace));
                        row3cell1.addAttribute("ss:StyleID","s52");
                        row3cell1.addAttribute("ss:Index","2");
                            Element row3cell1data1 = row3cell1.addElement("ss:Data");
                            row3cell1data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                            row3cell1data1.addAttribute("ss:Type","String");
                                Element row3cell1data1font = row3cell1data1.addElement(new QName("Font",row3cell1data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row3cell1data1font.addAttribute("html:Face","Wingdings");
                                row3cell1data1font.setText("首次报告¨þ");
                        Element row3cell3 = row3.addElement(new QName("Cell",namespace));
                        row3cell3.addAttribute("ss:StyleID","s53");
                        row3cell3.addAttribute("ss:Index","10");
                            Element row3cell3data1 = row3cell3.addElement(new QName("Data",namespace));
                            row3cell3data1.addAttribute("ss:Type","String");
                            row3cell3data1.setText("编码:");
                        Element row3cell4 = row3.addElement(new QName("Cell",namespace));
                        row3cell4.addAttribute("ss:StyleID","s75");
                        row3cell4.addAttribute("ss:MergeAcross","4");
                    Element row4 = table.addElement(new QName("Row",namespace));
                    row4.addAttribute("ss:StyleID","s50");
                        Element row4cell1 = row4.addElement(new QName("Cell",namespace));
                        row4cell1.addAttribute("ss:StyleID","s53");
                        row4cell1.addAttribute("ss:Index","2");
                            Element row4cell1data1 = row4cell1.addElement(new QName("Data",namespace));
                            row4cell1data1.addAttribute("ss:Type","String");
                            row4cell1data1.setText("报告类型:");
                        Element row4cell2 = row4.addElement(new QName("Cell",namespace));
                        row4cell2.addAttribute("ss:StyleID","s53");
                            Element row4cell2data1 = row4cell2.addElement("ss:Data");
                            row4cell2data1.addAttribute("ss:Type","String");
                            row4cell2data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell2data1font = row4cell2data1.addElement(new QName("Font",row4cell2data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell2data1font.addAttribute("html:Face","Wingdings");
                                row4cell2data1font.setText("新的¨");
                        Element row4cell3 = row4.addElement(new QName("Cell",namespace));
                        row4cell3.addAttribute("ss:StyleID","s53");
                            Element row4cell3data1 = row4cell3.addElement("ss:Data");
                            row4cell3data1.addAttribute("ss:Type","String");
                            row4cell3data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell3data1font = row4cell3data1.addElement(new QName("Font",row4cell3data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell3data1font.addAttribute("html:Face","Wingdings");
                                row4cell3data1font.setText("严重¨");
                        Element row4cell4 = row4.addElement(new QName("Cell",namespace));
                        row4cell4.addAttribute("ss:StyleID","s53");
                            Element row4cell4data1 = row4cell4.addElement("ss:Data");
                            row4cell4data1.addAttribute("ss:Type","String");
                            row4cell4data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell4data1font = row4cell4data1.addElement(new QName("Font",row4cell4data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell4data1font.addAttribute("html:Face","Wingdings");
                                row4cell4data1font.setText("一般¨");
                        Element row4cell5 = row4.addElement(new QName("Cell",namespace));
                        row4cell5.addAttribute("ss:StyleID","s53");
                        row4cell5.addAttribute("ss:Index","7");
                            Element row4cell5data1 = row4cell5.addElement(new QName("Data",namespace));
                            row4cell5data1.addAttribute("ss:Type","String");
                            row4cell5data1.setText("报告单位类别:");
                        Element row4cell6 = row4.addElement(new QName("Cell",namespace));
                        row4cell6.addAttribute("ss:StyleID","s53");
                            Element row4cell6data1 = row4cell6.addElement("ss:Data");
                            row4cell6data1.addAttribute("ss:Type","String");
                            row4cell6data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell6data1font = row4cell6data1.addElement(new QName("Font",row4cell6data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell6data1font.addAttribute("html:Face","Wingdings");
                                row4cell6data1font.setText("医疗机构¨");
                        Element row4cell7 = row4.addElement(new QName("Cell",namespace));
                        row4cell7.addAttribute("ss:StyleID","s53");
                            Element row4cell7data1 = row4cell7.addElement("ss:Data");
                            row4cell7data1.addAttribute("ss:Type","String");
                            row4cell7data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell7data1font = row4cell7data1.addElement(new QName("Font",row4cell7data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell7data1font.addAttribute("html:Face","Wingdings");
                                row4cell7data1font.setText("经营企业¨");
                        Element row4cell8 = row4.addElement(new QName("Cell",namespace));
                        row4cell8.addAttribute("ss:StyleID","s53");
                            Element row4cell8data1 = row4cell8.addElement("ss:Data");
                            row4cell8data1.addAttribute("ss:Type","String");
                            row4cell8data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell8data1font = row4cell8data1.addElement(new QName("Font",row4cell8data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell8data1font.addAttribute("html:Face","Wingdings");
                                row4cell8data1font.setText("生产企业¨");
                        Element row4cell9 = row4.addElement(new QName("Cell",namespace));
                        row4cell9.addAttribute("ss:StyleID","s53");
                            Element row4cell9data1 = row4cell9.addElement("ss:Data");
                            row4cell9data1.addAttribute("ss:Type","String");
                            row4cell9data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell9data1font = row4cell9data1.addElement(new QName("Font",row4cell9data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row4cell9data1font.addAttribute("html:Face","Wingdings");
                                row4cell9data1font.setText("个人¨");
                        Element row4cell10 = row4.addElement(new QName("Cell",namespace));
                        row4cell10.addAttribute("ss:StyleID","s53");
                            Element row4cell10data1 = row4cell10.addElement("ss:Data");
                            row4cell10data1.addAttribute("ss:Type","String");
                            row4cell10data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                                Element row4cell10data1font = row4cell10data1.addElement(new QName("Font",row4cell10data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                    row4cell10data1font.addAttribute("html:Face","Wingdings");
                                    row4cell10data1font.setText("其他¨");
                    Element row5 = table.addElement(new QName("Row",namespace));
                    row5.addAttribute("ss:StyleID","s50");
                    row5.addAttribute("ss:Index","8");
                    row5.addAttribute("ss:Height","36");
                        Element row5cell1 = row5.addElement(new QName("Cell",namespace));
                        row5cell1.addAttribute("ss:StyleID","s54");
                        Element row5cell2 = row5.addElement(new QName("Cell",namespace));
                        row5cell2.addAttribute("ss:StyleID","s76");
                        row5cell2.addAttribute("ss:MergeAcross","1");
                            Element row5cell2data1 = row5cell2.addElement(new QName("Data",namespace));
                            row5cell2data1.addAttribute("ss:Type","String");
                            row5cell2data1.setText("患者姓名:阿三");
                        Element row5cell3 = row5.addElement(new QName("Cell",namespace));
                        row5cell3.addAttribute("ss:StyleID","s77");
                        row5cell3.addAttribute("ss:MergeAcross","1");
                            Element row5cell3data1 = row5cell3.addElement("ss:Data");
                            row5cell3data1.addAttribute("ss:Type","String");
                            row5cell3data1.addNamespace("","http://www.w3.org/TR/REC-html40");
                            row5cell3data1.setText("");
                                Element row5cell3data1font1 = row5cell3data1.addElement(new QName("Font",row5cell3data1.getNamespaceForURI("http://www.w3.org/TR/REC-html40")));
                                row5cell3data1font1.addAttribute("html:Face","Wingdings");
                                row5cell3data1font1.setText("性别:男¨女¨");
                        Element row5cell4 = row5.addElement(new QName("Cell",namespace));
                        row5cell4.addAttribute("ss:StyleID","s78");
                        row5cell4.addAttribute("ss:MergeAcross","1");
                            Element row5cell4data1 = row5cell4.addElement(new QName("Data",namespace));
                            row5cell4data1.addAttribute("ss:Type","String");
                            row5cell4data1.setText("出生日期: 年 月 日 或年龄:");
                        Element row5cell5 = row5.addElement(new QName("Cell",namespace));
                        row5cell5.addAttribute("ss:StyleID","s79");
                        row5cell5.addAttribute("ss:MergeAcross","1");
                            Element row5cell5data1 = row5cell5.addElement(new QName("Data",namespace));
                            row5cell5data1.addAttribute("ss:Type","String");
                            row5cell5data1.setText("民族:");
                        Element row5cell6 = row5.addElement(new QName("Cell",namespace));
                        row5cell6.addAttribute("ss:StyleID","s80");
                        row5cell6.addAttribute("ss:MergeAcross","1");
                            Element row5cell6data1 = row5cell6.addElement(new QName("Data",namespace));
                            row5cell6data1.addAttribute("ss:Type","String");
                            row5cell6data1.setText("体重(kg):");
                        Element row5cell7 = row5.addElement(new QName("Cell",namespace));
                        row5cell7.addAttribute("ss:StyleID","s81");
                        row5cell7.addAttribute("ss:MergeAcross","3");
                            Element row5cell7data1 = row5cell7.addElement(new QName("Data",namespace));
                            row5cell7data1.addAttribute("ss:Type","String");
                            row5cell7data1.setText("联系方式:");
                    Element row6 = table.addElement(new QName("Row",namespace));
                    row6.addAttribute("ss:StyleID","s50");
                        Element row6cell1 = row6.addElement(new QName("Cell",namespace));
                        row6cell1.addAttribute("ss:StyleID","s104");
                        row6cell1.addAttribute("ss:Index","2");
                        row6cell1.addAttribute("ss:MergeAcross","2");
                        row6cell1.addAttribute("ss:MergeDown","2");
                            Element row6cell1data1 = row6cell1.addElement(new QName("Data",namespace));
                            row6cell1data1.addAttribute("ss:Type","String");
                            row6cell1data1.setText("原患疾病:");
                        Element row6cell2 = row6.addElement(new QName("Cell",namespace));
                        row6cell2.addAttribute("ss:StyleID","s105");
                        row6cell2.addAttribute("ss:MergeAcross","2");
                        row6cell2.addAttribute("ss:MergeDown","2");
                            Element row6cell2data1 = row6cell2.addElement(new QName("Data",namespace));
                            row6cell2data1.addAttribute("ss:Type","String");
                            row6cell2data1.setText("医院名称: 病历号/门诊号:");
                        Element row6cell3 = row6.addElement(new QName("Cell",namespace));
                        row6cell3.addAttribute("ss:StyleID","s82");
                        row6cell3.addAttribute("ss:MergeAcross","1");
                            Element row6cell3data1 = row6cell3.addElement(new QName("Data",namespace));
                            row6cell3data1.addAttribute("ss:Type","String");
                            row6cell3data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row6cell3data1.setText("既往药品不良反应/事件:有");
                                Element row6cell3data1font1 = row6cell3data1.addElement(new QName("Font",namespace));
                                row6cell3data1font1.addAttribute("html:Face","Wingdings");
                                row6cell3data1font1.setText("¨");
                        Element row6cell4 = row6.addElement(new QName("Cell",namespace));
                        row6cell4.addAttribute("ss:StyleID","s70");
                        Element row6cell5 = row6.addElement(new QName("Cell",namespace));
                        row6cell5.addAttribute("ss:StyleID","s70");
                        Element row6cell6 = row6.addElement(new QName("Cell",namespace));
                        row6cell6.addAttribute("ss:StyleID","s70");
                        Element row6cell7 = row6.addElement(new QName("Cell",namespace));
                        row6cell7.addAttribute("ss:StyleID","s70");
                        Element row6cell8 = row6.addElement(new QName("Cell",namespace));
                        row6cell8.addAttribute("ss:StyleID","s60");
                            Element row6cell8data1 = row6cell8.addElement(new QName("Data",namespace));
                            row6cell8data1.addAttribute("ss:Type","String");
                            row6cell8data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row6cell8data1.setText("无");
                                Element row6cell8data1font1 = row6cell8data1.addElement(new QName("Font",namespace));
                                row6cell8data1font1.addAttribute("html:Face","Wingdings");
                                row6cell8data1font1.setText("¨");
                            row6cell8data1.setText("不详");
                                Element row6cell8data1font2 = row6cell8data1.addElement(new QName("Font",namespace));
                                row6cell8data1font2.addAttribute("html:Face","Wingdings");
                                row6cell8data1font2.setText("¨");
                        Element row6cell9 = row6.addElement(new QName("Cell",namespace));
                        row6cell9.addAttribute("ss:StyleID","s71");
                    Element row7 = table.addElement(new QName("Row",namespace));
                    row7.addAttribute("ss:StyleID","s50");
                        Element row7cell1 = row7.addElement(new QName("Cell",namespace));
                        row7cell1.addAttribute("ss:StyleID","s83");
                        row7cell1.addAttribute("ss:MergeAcross","1");
                        row7cell1.addAttribute("ss:Index","8");
                            Element row7cell1data1 = row7cell1.addElement(new QName("Data",namespace));
                            row7cell1data1.addAttribute("ss:Type","String");
                            row7cell1data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row7cell1data1.setText("家族药品不良反应/事件:有");
                                Element row7cell1data1font1 = row7cell1data1.addElement(new QName("Font",namespace));
                                row7cell1data1font1.addAttribute("html:Face","Wingdings");
                                row7cell1data1font1.setText("¨");
                        Element row7cell2 = row7.addElement(new QName("Cell",namespace));
                        row7cell2.addAttribute("ss:StyleID","s72");
                        Element row7cell3 = row7.addElement(new QName("Cell",namespace));
                        row7cell3.addAttribute("ss:StyleID","s72");
                        Element row7cell4 = row7.addElement(new QName("Cell",namespace));
                        row7cell4.addAttribute("ss:StyleID","s72");
                        Element row7cell5 = row7.addElement(new QName("Cell",namespace));
                        row7cell5.addAttribute("ss:StyleID","s72");
                        Element row7cell6 = row7.addElement(new QName("Cell",namespace));
                        row7cell6.addAttribute("ss:StyleID","s61");
                            Element row7cell6data1 = row7cell6.addElement(new QName("Data",namespace));
                            row7cell6data1.addAttribute("ss:Type","String");
                            row7cell6data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row7cell6data1.setText("无");
                                Element row7cell6data1font1 = row7cell6data1.addElement(new QName("Font",namespace));
                                row7cell6data1font1.addAttribute("html:Face","Wingdings");
                                row7cell6data1font1.setText("¨");
                                row7cell6data1.setText("不详");
                                Element row7cell6data1font2 = row7cell6data1.addElement(new QName("Font",namespace));
                                row7cell6data1font2.addAttribute("html:Face","Wingdings");
                                row7cell6data1font2.setText("¨");
                        Element row7cell7 = row7.addElement(new QName("Cell",namespace));
                        row7cell7.addAttribute("ss:StyleID","s73");
                    Element row8 = table.addElement(new QName("Row",namespace));
                    row8.addAttribute("ss:StyleID","s50");
                        Element row8cell1 = row8.addElement(new QName("Cell",namespace));
                        row8cell1.addAttribute("ss:StyleID","s74");
                        row8cell1.addAttribute("ss:Index","15");
                    Element row9 = table.addElement(new QName("Row",namespace));
                    row9.addAttribute("ss:StyleID","s50");
                    row9.addAttribute("ss:Height","22");
                        Element row9cell1 = row9.addElement(new QName("Cell",namespace));
                        row9cell1.addAttribute("ss:StyleID","s106");
                        row9cell1.addAttribute("ss:MergeAcross","13");
                        row9cell1.addAttribute("ss:Index","2");
                        row9cell1.addAttribute("ss:Index","2");
                        row9cell1.addAttribute("ss:MergeDown","1");
                            Element row9cell1data1 = row9cell1.addElement(new QName("Data",namespace));
                            row9cell1data1.addAttribute("ss:Type","String");
                            row9cell1data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row9cell1data1.setText("相关重要信息:吸烟史");
                                Element row9cell1data1font1 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font1.addAttribute("html:Face","Wingdings");
                                row9cell1data1font1.setText("¨");
                                row9cell1data1.setText("饮酒史");
                                Element row9cell1data1font2 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font2.addAttribute("html:Face","Wingdings");
                                row9cell1data1font2.setText("¨");
                                row9cell1data1.setText("妊娠期");
                                Element row9cell1data1font3 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font3.addAttribute("html:Face","Wingdings");
                                row9cell1data1font3.setText("¨");
                                row9cell1data1.setText("肝病史");
                                Element row9cell1data1font4 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font4.addAttribute("html:Face","Wingdings");
                                row9cell1data1font4.setText("¨");
                                row9cell1data1.setText("肾病史");
                                Element row9cell1data1font5 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font4.addAttribute("html:Face","Wingdings");
                                row9cell1data1font4.setText("¨");
                                row9cell1data1.setText("过敏史");
                                Element row9cell1data1font6 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font6.addAttribute("html:Face","Wingdings");
                                row9cell1data1font6.setText("¨");
                                row9cell1data1.setText("其他");
                                Element row9cell1data1font7 = row9cell1data1.addElement(new QName("Font",namespace));
                                row9cell1data1font7.addAttribute("html:Face","Wingdings");
                                row9cell1data1font7.setText("¨");
                    Element row10 = table.addElement(new QName("Row",namespace));
                    row10.addAttribute("ss:StyleID","s50");
                    Element row11 = table.addElement(new QName("Row",namespace));
                    row11.addAttribute("ss:StyleID","s50");
                    row11.addAttribute("ss:Height","27");
                        Element row11cell1 = row11.addElement(new QName("Cell",namespace));
                        row11cell1.addAttribute("ss:StyleID","s62");
                        row11cell1.addAttribute("ss:Index","2");
                            Element row11cell1data1 = row11cell1.addElement(new QName("Data",namespace));
                            row11cell1data1.addAttribute("ss:Type","String");
                            row11cell1data1.setText("药品");
                        Element row11cell2 = row11.addElement(new QName("Cell",namespace));
                        row11cell2.addAttribute("ss:StyleID","s63");
                            Element row11cell2data1 = row11cell2.addElement(new QName("Data",namespace));
                            row11cell2data1.addAttribute("ss:Type","String");
                            row11cell2data1.setText("批准文号");
                        Element row11cell3 = row11.addElement(new QName("Cell",namespace));
                        row11cell3.addAttribute("ss:StyleID","s63");
                            Element row11cell3data1 = row11cell3.addElement(new QName("Data",namespace));
                            row11cell3data1.addAttribute("ss:Type","String");
                            row11cell3data1.setText("商品名称");
                        Element row11cell4 = row11.addElement(new QName("Cell",namespace));
                        row11cell4.addAttribute("ss:StyleID","s62");
                            Element row11cell4data1 = row11cell4.addElement(new QName("Data",namespace));
                            row11cell4data1.addAttribute("ss:Type","String");
                            row11cell4data1.setText("通用名称(含剂型)");
                        Element row11cell5 = row11.addElement(new QName("Cell",namespace));
                        row11cell5.addAttribute("ss:StyleID","s84");
                        row11cell5.addAttribute("ss:MergeAcross","1");
                            Element row11cell5data1 = row11cell5.addElement(new QName("Data",namespace));
                            row11cell5data1.addAttribute("ss:Type","String");
                            row11cell5data1.setText("生产厂家");
                        Element row11cell6 = row11.addElement(new QName("Cell",namespace));
                        row11cell6.addAttribute("ss:StyleID","s62");
                            Element row11cell6data1 = row11cell6.addElement(new QName("Data",namespace));
                            row11cell6data1.addAttribute("ss:Type","String");
                            row11cell6data1.setText("生产批号");
                        Element row11cell7 = row11.addElement(new QName("Cell",namespace));
                        row11cell7.addAttribute("ss:StyleID","s85");
                        row11cell7.addAttribute("ss:MergeAcross","2");
                            Element row11cell7data1 = row11cell7.addElement(new QName("Data",namespace));
                            row11cell7data1.addAttribute("ss:Type","String");
                            row11cell7data1.setText("用法用量 (次剂量、途径、日次数)");
                        Element row11cell8 = row11.addElement(new QName("Cell",namespace));
                        row11cell8.addAttribute("ss:StyleID","s86");
                        row11cell8.addAttribute("ss:MergeAcross","1");
                            Element row11cell8data1 = row11cell8.addElement(new QName("Data",namespace));
                            row11cell8data1.addAttribute("ss:Type","String");
                            row11cell8data1.setText("用药起止时间");
                        Element row11cell9 = row11.addElement(new QName("Cell",namespace));
                        row11cell9.addAttribute("ss:StyleID","s87");
                        row11cell9.addAttribute("ss:MergeAcross","1");
                            Element row11cell9data1 = row11cell9.addElement(new QName("Data",namespace));
                            row11cell9data1.addAttribute("ss:Type","String");
                            row11cell9data1.setText("用药原因");
                    Element row12 = table.addElement(new QName("Row",namespace));
                    row12.addAttribute("ss:StyleID","s50");
                        Element row12cell1 = row12.addElement(new QName("Cell",namespace));
                        row12cell1.addAttribute("ss:StyleID","s99");
                        row12cell1.addAttribute("ss:Index","2");
                        row12cell1.addAttribute("ss:MergeDown","2");
                            Element row12cell1data1 = row12cell1.addElement(new QName("Data",namespace));
                            row12cell1data1.addAttribute("ss:Type","String");
                            row12cell1data1.setText("怀疑药品");
                        Element row12cell2 = row12.addElement(new QName("Cell",namespace));
                        row12cell2.addAttribute("ss:StyleID","s64");
                        Element row12cell3 = row12.addElement(new QName("Cell",namespace));
                        row12cell3.addAttribute("ss:StyleID","s64");
                        Element row12cell4 = row12.addElement(new QName("Cell",namespace));
                        row12cell4.addAttribute("ss:StyleID","s64");
                        Element row12cell5 = row12.addElement(new QName("Cell",namespace));
                        row12cell5.addAttribute("ss:StyleID","s64");
                        Element row12cell6 = row12.addElement(new QName("Cell",namespace));
                        row12cell6.addAttribute("ss:StyleID","s56");
                            Element row12cell6data1 = row12cell6.addElement(new QName("Data",namespace));
                            row12cell6data1.addAttribute("ss:Type","String");
                            row12cell6data1.setText("批准文号");
                        Element row12cell7 = row12.addElement(new QName("Cell",namespace));
                        row12cell7.addAttribute("ss:StyleID","s64");
                        Element row12cell8 = row12.addElement(new QName("Cell",namespace));
                        row12cell8.addAttribute("ss:StyleID","s64");
                        Element row12cell9 = row12.addElement(new QName("Cell",namespace));
                        row12cell9.addAttribute("ss:StyleID","s64");
                        Element row12cell10 = row12.addElement(new QName("Cell",namespace));
                        row12cell10.addAttribute("ss:StyleID","s64");
                        Element row12cell11 = row12.addElement(new QName("Cell",namespace));
                        row12cell11.addAttribute("ss:StyleID","s64");
                        Element row12cell12 = row12.addElement(new QName("Cell",namespace));
                        row12cell12.addAttribute("ss:StyleID","s64");
                        Element row12cell13 = row12.addElement(new QName("Cell",namespace));
                        row12cell13.addAttribute("ss:StyleID","s64");
                        Element row12cell14 = row12.addElement(new QName("Cell",namespace));
                        row12cell14.addAttribute("ss:StyleID","s64");
                    Element row13 = table.addElement(new QName("Row",namespace));
                    row13.addAttribute("ss:StyleID","s50");
                        Element row13cell1 = row13.addElement(new QName("Cell",namespace));
                        row13cell1.addAttribute("ss:StyleID","s64");
                        row13cell1.addAttribute("ss:Index","3");
                        Element row13cell2 = row13.addElement(new QName("Cell",namespace));
                        row13cell2.addAttribute("ss:StyleID","s64");
                        Element row13cell3 = row13.addElement(new QName("Cell",namespace));
                        row13cell3.addAttribute("ss:StyleID","s64");
                        Element row13cell4 = row13.addElement(new QName("Cell",namespace));
                        row13cell4.addAttribute("ss:StyleID","s64");
                        Element row13cell5 = row13.addElement(new QName("Cell",namespace));
                        row13cell5.addAttribute("ss:StyleID","s64");
                        Element row13cell6 = row13.addElement(new QName("Cell",namespace));
                        row13cell6.addAttribute("ss:StyleID","s64");
                        Element row13cell7 = row13.addElement(new QName("Cell",namespace));
                        row13cell7.addAttribute("ss:StyleID","s64");
                        Element row13cell8 = row13.addElement(new QName("Cell",namespace));
                        row13cell8.addAttribute("ss:StyleID","s64");
                        Element row13cell9 = row13.addElement(new QName("Cell",namespace));
                        row13cell9.addAttribute("ss:StyleID","s64");
                        Element row13cell10 = row13.addElement(new QName("Cell",namespace));
                        row13cell10.addAttribute("ss:StyleID","s64");
                        Element row13cell11 = row13.addElement(new QName("Cell",namespace));
                        row13cell11.addAttribute("ss:StyleID","s64");
                        Element row13cell12 = row13.addElement(new QName("Cell",namespace));
                        row13cell12.addAttribute("ss:StyleID","s64");
                        Element row13cell13 = row13.addElement(new QName("Cell",namespace));
                        row13cell13.addAttribute("ss:StyleID","s64");
                    Element row14 = table.addElement(new QName("Row",namespace));
                    row14.addAttribute("ss:StyleID","s50");
                        Element row14cell1 = row14.addElement(new QName("Cell",namespace));
                        row14cell1.addAttribute("ss:StyleID","s64");
                        row14cell1.addAttribute("ss:Index","3");
                        Element row14cell2 = row14.addElement(new QName("Cell",namespace));
                        row14cell2.addAttribute("ss:StyleID","s64");
                        Element row14cell3 = row14.addElement(new QName("Cell",namespace));
                        row14cell3.addAttribute("ss:StyleID","s64");
                        Element row14cell4 = row14.addElement(new QName("Cell",namespace));
                        row14cell4.addAttribute("ss:StyleID","s64");
                        Element row14cell5 = row14.addElement(new QName("Cell",namespace));
                        row14cell5.addAttribute("ss:StyleID","s64");
                        Element row14cell6 = row14.addElement(new QName("Cell",namespace));
                        row14cell6.addAttribute("ss:StyleID","s64");
                        Element row14cell7 = row14.addElement(new QName("Cell",namespace));
                        row14cell7.addAttribute("ss:StyleID","s64");
                        Element row14cell8 = row14.addElement(new QName("Cell",namespace));
                        row14cell8.addAttribute("ss:StyleID","s64");
                        Element row14cell9 = row14.addElement(new QName("Cell",namespace));
                        row14cell9.addAttribute("ss:StyleID","s64");
                        Element row14cell10 = row14.addElement(new QName("Cell",namespace));
                        row14cell10.addAttribute("ss:StyleID","s64");
                        Element row14cell11 = row14.addElement(new QName("Cell",namespace));
                        row14cell11.addAttribute("ss:StyleID","s64");
                        Element row14cell12 = row14.addElement(new QName("Cell",namespace));
                        row14cell12.addAttribute("ss:StyleID","s64");
                        Element row14cell13 = row14.addElement(new QName("Cell",namespace));
                        row14cell13.addAttribute("ss:StyleID","s64");
                    Element row15 = table.addElement(new QName("Row",namespace));
                    row15.addAttribute("ss:StyleID","s50");
                        Element row15cell1 = row15.addElement(new QName("Cell",namespace));
                        row15cell1.addAttribute("ss:StyleID","s64");
                        row15cell1.addAttribute("ss:Index","3");
                        Element row15cell2 = row15.addElement(new QName("Cell",namespace));
                        row15cell2.addAttribute("ss:StyleID","s64");
                        Element row15cell3 = row15.addElement(new QName("Cell",namespace));
                        row15cell3.addAttribute("ss:StyleID","s64");
                        Element row15cell4 = row15.addElement(new QName("Cell",namespace));
                        row15cell4.addAttribute("ss:StyleID","s64");
                        Element row15cell5 = row15.addElement(new QName("Cell",namespace));
                        row15cell5.addAttribute("ss:StyleID","s64");
                        Element row15cell6 = row15.addElement(new QName("Cell",namespace));
                        row15cell6.addAttribute("ss:StyleID","s64");
                        Element row15cell7 = row15.addElement(new QName("Cell",namespace));
                        row15cell7.addAttribute("ss:StyleID","s64");
                        Element row15cell8 = row15.addElement(new QName("Cell",namespace));
                        row15cell8.addAttribute("ss:StyleID","s64");
                        Element row15cell9 = row15.addElement(new QName("Cell",namespace));
                        row15cell9.addAttribute("ss:StyleID","s64");
                        Element row15cell10 = row15.addElement(new QName("Cell",namespace));
                        row15cell10.addAttribute("ss:StyleID","s64");
                        Element row15cell11 = row15.addElement(new QName("Cell",namespace));
                        row15cell11.addAttribute("ss:StyleID","s64");
                        Element row15cell12 = row15.addElement(new QName("Cell",namespace));
                        row15cell12.addAttribute("ss:StyleID","s64");
                        Element row15cell13 = row15.addElement(new QName("Cell",namespace));
                        row15cell13.addAttribute("ss:StyleID","s64");
                    Element row16 = table.addElement(new QName("Row",namespace));
                    row16.addAttribute("ss:StyleID","s50");
                        Element row16cell1 = row16.addElement(new QName("Cell",namespace));
                        row16cell1.addAttribute("ss:StyleID","s100");
                        row16cell1.addAttribute("ss:Index","2");
                        row16cell1.addAttribute("ss:MergeDown","2");
                                Element row16cell1data1 = row16cell1.addElement(new QName("Data",namespace));
                                row16cell1data1.addAttribute("ss:Type","String");
                                row16cell1data1.setText("并用药品");
                        Element row16cell2 = row16.addElement(new QName("Cell",namespace));
                        row16cell2.addAttribute("ss:StyleID","s64");
                        Element row16cell3 = row16.addElement(new QName("Cell",namespace));
                        row16cell3.addAttribute("ss:StyleID","s64");
                        Element row16cell4 = row16.addElement(new QName("Cell",namespace));
                        row16cell4.addAttribute("ss:StyleID","s64");
                        Element row16cell5 = row16.addElement(new QName("Cell",namespace));
                        row16cell5.addAttribute("ss:StyleID","s64");
                        Element row16cell6 = row16.addElement(new QName("Cell",namespace));
                        row16cell6.addAttribute("ss:StyleID","s64");
                        Element row16cell7 = row16.addElement(new QName("Cell",namespace));
                        row16cell7.addAttribute("ss:StyleID","s64");
                        Element row16cell8 = row16.addElement(new QName("Cell",namespace));
                        row16cell8.addAttribute("ss:StyleID","s64");
                        Element row16cell9 = row16.addElement(new QName("Cell",namespace));
                        row16cell9.addAttribute("ss:StyleID","s64");
                        Element row16cell10 = row16.addElement(new QName("Cell",namespace));
                        row16cell10.addAttribute("ss:StyleID","s64");
                        Element row16cell11 = row16.addElement(new QName("Cell",namespace));
                        row16cell11.addAttribute("ss:StyleID","s64");
                        Element row16cell12 = row16.addElement(new QName("Cell",namespace));
                        row16cell12.addAttribute("ss:StyleID","s64");
                        Element row16cell13 = row16.addElement(new QName("Cell",namespace));
                        row16cell13.addAttribute("ss:StyleID","s64");
                        Element row16cell14 = row16.addElement(new QName("Cell",namespace));
                        row16cell14.addAttribute("ss:StyleID","s64");
                    Element row17 = table.addElement(new QName("Row",namespace));
                    row17.addAttribute("ss:StyleID","s50");
                        Element row17cell1 = row17.addElement(new QName("Cell",namespace));
                        row17cell1.addAttribute("ss:StyleID","s64");
                        row17cell1.addAttribute("ss:Index","3");
                        Element row17cell2 = row17.addElement(new QName("Cell",namespace));
                        row17cell2.addAttribute("ss:StyleID","s64");
                         Element row17cell3 = row17.addElement(new QName("Cell",namespace));
                        row17cell3.addAttribute("ss:StyleID","s64");
                        Element row17cell4 = row17.addElement(new QName("Cell",namespace));
                        row17cell4.addAttribute("ss:StyleID","s64");
                        Element row17cell5 = row17.addElement(new QName("Cell",namespace));
                        row17cell5.addAttribute("ss:StyleID","s64");
                        Element row17cell6 = row17.addElement(new QName("Cell",namespace));
                        row17cell6.addAttribute("ss:StyleID","s64");
                        Element row17cell7 = row17.addElement(new QName("Cell",namespace));
                        row17cell7.addAttribute("ss:StyleID","s64");
                        Element row17cell8 = row17.addElement(new QName("Cell",namespace));
                        row17cell8.addAttribute("ss:StyleID","s64");
                        Element row17cell9 = row17.addElement(new QName("Cell",namespace));
                        row17cell9.addAttribute("ss:StyleID","s64");
                        Element row17cell10 = row17.addElement(new QName("Cell",namespace));
                        row17cell10.addAttribute("ss:StyleID","s64");
                        Element row17cell11 = row17.addElement(new QName("Cell",namespace));
                        row17cell11.addAttribute("ss:StyleID","s64");
                        Element row17cell12 = row17.addElement(new QName("Cell",namespace));
                        row17cell12.addAttribute("ss:StyleID","s64");
                        Element row17cell13 = row17.addElement(new QName("Cell",namespace));
                        row17cell13.addAttribute("ss:StyleID","s64");
                    Element row18 = table.addElement(new QName("Row",namespace));
                    row18.addAttribute("ss:StyleID","s50");
                        Element row18cell1 = row18.addElement(new QName("Cell",namespace));
                        row18cell1.addAttribute("ss:StyleID","s64");
                        row18cell1.addAttribute("ss:Index","3");
                        Element row18cell2 = row18.addElement(new QName("Cell",namespace));
                        row18cell2.addAttribute("ss:StyleID","s64");
                        Element row18cell3 = row18.addElement(new QName("Cell",namespace));
                        row18cell3.addAttribute("ss:StyleID","s64");
                        Element row18cell4 = row18.addElement(new QName("Cell",namespace));
                        row18cell4.addAttribute("ss:StyleID","s64");
                        Element row18cell5 = row18.addElement(new QName("Cell",namespace));
                        row18cell5.addAttribute("ss:StyleID","s64");
                        Element row18cell6 = row18.addElement(new QName("Cell",namespace));
                        row18cell6.addAttribute("ss:StyleID","s64");
                        Element row18cell7 = row18.addElement(new QName("Cell",namespace));
                        row18cell7.addAttribute("ss:StyleID","s64");
                        Element row18cell8 = row18.addElement(new QName("Cell",namespace));
                        row18cell8.addAttribute("ss:StyleID","s64");
                        Element row18cell9 = row18.addElement(new QName("Cell",namespace));
                        row18cell9.addAttribute("ss:StyleID","s64");
                        Element row18cell10 = row18.addElement(new QName("Cell",namespace));
                        row18cell10.addAttribute("ss:StyleID","s64");
                        Element row18cell11 = row18.addElement(new QName("Cell",namespace));
                        row18cell11.addAttribute("ss:StyleID","s64");
                        Element row18cell12 = row18.addElement(new QName("Cell",namespace));
                        row18cell12.addAttribute("ss:StyleID","s64");
                        Element row18cell13 = row18.addElement(new QName("Cell",namespace));
                        row18cell13.addAttribute("ss:StyleID","s64");
                    Element row19 = table.addElement(new QName("Row",namespace));
                    row19.addAttribute("ss:StyleID","s50");
                        Element row19cell1 = row19.addElement(new QName("Cell",namespace));
                        row19cell1.addAttribute("ss:StyleID","s88");
                        row19cell1.addAttribute("ss:Index","2");
                        row19cell1.addAttribute("ss:MergeAcross","6");
                            Element row19cell1data1 = row19cell1.addElement(new QName("Data",namespace));
                            row19cell1data1.addAttribute("ss:Type","String");
                            row19cell1data1.setText("不良反应/事件名称:");
                        Element row19cell2 = row19.addElement(new QName("Cell",namespace));
                        row19cell2.addAttribute("ss:StyleID","s89");
                        row19cell2.addAttribute("ss:MergeAcross","6");
                                Element row19cell2data1 = row19cell2.addElement(new QName("Data",namespace));
                                row19cell2data1.addAttribute("ss:Type","String");
                                row19cell2data1.setText("不良反应/事件发生时间: 年 月 日");
                        Element row19cell3 = row19.addElement(new QName("Cell",namespace));
                        row19cell3.addAttribute("ss:StyleID","s54");
                        row19cell3.addAttribute("ss:Index","23");
                    Element row20 = table.addElement(new QName("Row",namespace));
                    row20.addAttribute("ss:StyleID","s50");
                            Element row20cell1 = row20.addElement(new QName("Cell",namespace));
                            row20cell1.addAttribute("ss:StyleID","s107");
                            row20cell1.addAttribute("ss:Index","2");
                            row20cell1.addAttribute("ss:MergeAcross","13");
                            row20cell1.addAttribute("ss:MergeDown","7");
                                Element row20cell1data1 = row20cell1.addElement(new QName("Data",namespace));
                                row20cell1data1.addAttribute("ss:Type","String");
                                row20cell1data1.setText("不良反应/事件过程描述(包括症状、体征、临床检验等)及处理情况(可附页):应/事件过程描述(包括症状、体征、临床检验等)及处理情况(可应/事件过程描述(包括症状、体征、临床检验等)及处 理情况(可应/事件过程描述(包括症状、体征、临床检验等)及 处理情况(可应/事件过程描述(包括症状、体征、临床检验等)及处理情况(可应/事件过程描述(包括症状、体征、临床检验等)及处理情况(可应/事件过程描述(包括症状、体征、临床检验等)及处理情况(可");
                    Element row21 = table.addElement(new QName("Row",namespace));
                    row21.addAttribute("ss:StyleID","s50");
                    Element row22 = table.addElement(new QName("Row",namespace));
                    row22.addAttribute("ss:StyleID","s50");
                    Element row23 = table.addElement(new QName("Row",namespace));
                    row23.addAttribute("ss:StyleID","s50");
                    Element row24 = table.addElement(new QName("Row",namespace));
                    row24.addAttribute("ss:StyleID","s50");
                    Element row25 = table.addElement(new QName("Row",namespace));
                    row25.addAttribute("ss:StyleID","s50");
                    Element row26 = table.addElement(new QName("Row",namespace));
                    row26.addAttribute("ss:StyleID","s50");
                    Element row27 = table.addElement(new QName("Row",namespace));
                    row27.addAttribute("ss:StyleID","s50");
                    Element row28 = table.addElement(new QName("Row",namespace));
                    row28.addAttribute("ss:StyleID","s50");
                    row28.addAttribute("ss:Height","25");
                        Element row28cell1 = row28.addElement(new QName("Cell",namespace));
                        row28cell1.addAttribute("ss:StyleID","s108");
                        row28cell1.addAttribute("ss:Index","2");
                        row28cell1.addAttribute("ss:MergeAcross","13");
                        row28cell1.addAttribute("ss:MergeDown","1");
                            Element row28cell1data1 = row28cell1.addElement(new QName("Data",namespace));
                            row28cell1data1.addAttribute("ss:Type","String");
                            row28cell1data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row28cell1data1.setText("不良反应/事件的结果:痊愈");
                                Element row28cell1data1font1 = row28cell1data1.addElement(new QName("Font",namespace));
                                row28cell1data1font1.addAttribute("html:Face","Wingdings");
                                row28cell1data1font1.setText("¨");
                                row28cell1data1.setText("好转");
                                Element row28cell1data1font2 = row28cell1data1.addElement(new QName("Font",namespace));
                                row28cell1data1font2.addAttribute("html:Face","Wingdings");
                                row28cell1data1font2.setText("¨");
                            row28cell1data1.setText("未好转");
                            Element row28cell1data1font3 = row28cell1data1.addElement(new QName("Font",namespace));
                            row28cell1data1font3.addAttribute("html:Face","Wingdings");
                            row28cell1data1font3.setText("¨");
                            row28cell1data1.setText("不详");
                            Element row28cell1data1font4 = row28cell1data1.addElement(new QName("Font",namespace));
                            row28cell1data1font4.addAttribute("html:Face","Wingdings");
                            row28cell1data1font4.setText("¨");
                            row28cell1data1.setText("有后遗症");
                            Element row28cell1data1font5 = row28cell1data1.addElement(new QName("Font",namespace));
                            row28cell1data1font5.addAttribute("html:Face","Wingdings");
                            row28cell1data1font5.setText("¨");
                            row28cell1data1.setText("表现:死亡");
                            Element row28cell1data1font6 = row28cell1data1.addElement(new QName("Font",namespace));
                            row28cell1data1font6.addAttribute("html:Face","Wingdings");
                            row28cell1data1font6.setText("¨");
                            row28cell1data1.setText("直接死因:死亡时间:  年  月  日");
                    Element row29 = table.addElement(new QName("Row",namespace));
                    row29.addAttribute("ss:StyleID","s50");
                        Element row29cell1 = row29.addElement(new QName("Cell",namespace));
                        row29cell1.addAttribute("ss:StyleID","s109");
                        row29cell1.addAttribute("ss:Index","2");
                        row29cell1.addAttribute("ss:MergeAcross","13");
                        row29cell1.addAttribute("ss:MergeDown","1");
                            Element row29cell1data1 = row29cell1.addElement(new QName("Data",namespace));
                            row29cell1data1.addAttribute("ss:Type","String");
                            row29cell1data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row29cell1data1.setText("停药或减药后,反应/事件是否消失或减轻?是");
                                Element row29cell1data1font1 = row29cell1data1.addElement(new QName("Font",namespace));
                                row29cell1data1font1.addAttribute("html:Face","Wingdings");
                                row29cell1data1font1.setText("¨");
                    row29cell1data1.setText("否");
                    Element row29cell1data1font2 = row29cell1data1.addElement(new QName("Font",namespace));
                    row29cell1data1font2.addAttribute("html:Face","Wingdings");
                    row29cell1data1font2.setText("¨");
                    row29cell1data1.setText("不明");
                    Element row29cell1data1font3 = row29cell1data1.addElement(new QName("Font",namespace));
                    row29cell1data1font3.addAttribute("html:Face","Wingdings");
                    row29cell1data1font3.setText("¨");
                    row29cell1data1.setText("未停药或未减量 再次使用可疑药品后是否再次出现同样反应/事件?是");
                    Element row29cell1data1font4 = row29cell1data1.addElement(new QName("Font",namespace));
                    row29cell1data1font4.addAttribute("html:Face","Wingdings");
                    row29cell1data1font4.setText("¨");
                    row29cell1data1.setText("否");
                    Element row29cell1data1font5 = row29cell1data1.addElement(new QName("Font",namespace));
                    row29cell1data1font5.addAttribute("html:Face","Wingdings");
                    row29cell1data1font5.setText("¨");
                    row29cell1data1.setText("不明");
                    Element row29cell1data1font6 = row29cell1data1.addElement(new QName("Font",namespace));
                    row29cell1data1font6.addAttribute("html:Face","Wingdings");
                    row29cell1data1font6.setText("¨");
                    row29cell1data1.setText("未再使用");
                    Element row30 = table.addElement(new QName("Row",namespace));
                    row30.addAttribute("ss:StyleID","s50");
                        Element row30cell1 = row30.addElement(new QName("Cell",namespace));
                        row30cell1.addAttribute("ss:StyleID","s90");
                        row30cell1.addAttribute("ss:Index","2");
                        row30cell1.addAttribute("ss:MergeAcross","13");
                            Element row30cell1data1 = row30cell1.addElement(new QName("Data",namespace));
                            row30cell1data1.addAttribute("ss:Type","String");
                            row30cell1data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row30cell1data1.setText("对原患疾病的影响: 不明显");
                                Element row30cell1data1font1 = row30cell1data1.addElement(new QName("Font",namespace));
                                row30cell1data1font1.addAttribute("html:Face","Wingdings");
                                row30cell1data1font1.setText("¨");
                            row30cell1data1.setText("病程延长");
                            Element row30cell1data1font2 = row30cell1data1.addElement(new QName("Font",namespace));
                            row30cell1data1font2.addAttribute("html:Face","Wingdings");
                            row30cell1data1font2.setText("¨");
                            row30cell1data1.setText("病情加重");
                            Element row30cell1data1font3 = row30cell1data1.addElement(new QName("Font",namespace));
                            row30cell1data1font3.addAttribute("html:Face","Wingdings");
                            row30cell1data1font3.setText("¨");
                            row30cell1data1.setText("导致后遗症");
                            Element row30cell1data1font4 = row30cell1data1.addElement(new QName("Font",namespace));
                            row30cell1data1font4.addAttribute("html:Face","Wingdings");
                            row30cell1data1font4.setText("¨");
                            row30cell1data1.setText("导致死亡");
                            Element row30cell1data1font5 = row30cell1data1.addElement(new QName("Font",namespace));
                            row30cell1data1font5.addAttribute("html:Face","Wingdings");
                            row30cell1data1font5.setText("¨");
                    Element row31 = table.addElement(new QName("Row",namespace));
                    row31.addAttribute("ss:StyleID","s50");
                        Element row31cell1 = row31.addElement(new QName("Cell",namespace));
                        row31cell1.addAttribute("ss:StyleID","s101");
                        row31cell1.addAttribute("ss:Index","2");
                        row31cell1.addAttribute("ss:MergeDown","1");
                            Element row31cell1data1 = row31cell1.addElement(new QName("Data",namespace));
                            row31cell1data1.addAttribute("ss:Type","String");
                            row31cell1data1.setText("关联性评价");
                        Element row31cell2 = row31.addElement(new QName("Cell",namespace));
                        row31cell2.addAttribute("ss:StyleID","s110");
                        row31cell2.addAttribute("ss:MergeAcross","12");
                        row31cell2.addAttribute("ss:MergeDown","1");
                            Element row31cell2data1 = row31cell2.addElement(new QName("Data",namespace));
                            row31cell2data1.addAttribute("ss:Type","String");
                            row31cell2data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row31cell2data1.setText("报告人评价: 肯定");
                            Element row31cell2data1font1 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font1.addAttribute("html:Face","Wingdings");
                            row31cell2data1font1.setText("¨");
                            row31cell2data1.setText("很可能");
                            Element row31cell2data1font2 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font2.addAttribute("html:Face","Wingdings");
                            row31cell2data1font2.setText("¨");
                            row31cell2data1.setText("可能");
                            Element row31cell2data1font3 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font3.addAttribute("html:Face","Wingdings");
                            row31cell2data1font3.setText("¨");
                            row31cell2data1.setText("可能无关");
                            Element row31cell2data1font4 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font4.addAttribute("html:Face","Wingdings");
                            row31cell2data1font4.setText("¨");
                            row31cell2data1.setText("待评价");
                            Element row31cell2data1font5 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font5.addAttribute("html:Face","Wingdings");
                            row31cell2data1font5.setText("¨");
                            row31cell2data1.setText("无法评价");
                            Element row31cell2data1font6 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font6.addAttribute("html:Face","Wingdings");
                            row31cell2data1font6.setText("¨");
                            row31cell2data1.setText("签名: 报告单位评价: 肯定");
                            Element row31cell2data1font7 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font7.addAttribute("html:Face","Wingdings");
                            row31cell2data1font7.setText("¨");
                            row31cell2data1.setText("很可能");
                            Element row31cell2data1font8 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font8.addAttribute("html:Face","Wingdings");
                            row31cell2data1font8.setText("¨");
                            row31cell2data1.setText("可能");
                            Element row31cell2data1font9 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font9.addAttribute("html:Face","Wingdings");
                            row31cell2data1font9.setText("¨");
                            row31cell2data1.setText("可能无关");
                            Element row31cell2data1font10 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font10.addAttribute("html:Face","Wingdings");
                            row31cell2data1font10.setText("¨");
                            row31cell2data1.setText("待评价");
                            Element row31cell2data1font11 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font11.addAttribute("html:Face","Wingdings");
                            row31cell2data1font11.setText("¨");
                            row31cell2data1.setText("无法评价");
                            Element row31cell2data1font12 = row31cell2data1.addElement(new QName("Font",namespace));
                            row31cell2data1font12.addAttribute("html:Face","Wingdings");
                            row31cell2data1font12.setText("¨");
                            row31cell2data1.setText("签名:");
                    Element row32 = table.addElement(new QName("Row",namespace));
                    row32.addAttribute("ss:StyleID","s50");
                    Element row33 = table.addElement(new QName("Row",namespace));
                    row33.addAttribute("ss:StyleID","s50");
                        Element row33cell1 = row33.addElement(new QName("Cell",namespace));
                        row33cell1.addAttribute("ss:StyleID","s102");
                        row33cell1.addAttribute("ss:Index","2");
                        row33cell1.addAttribute("ss:MergeDown","1");
                            Element row33cell1data1 = row33cell1.addElement(new QName("Data",namespace));
                            row33cell1data1.addAttribute("ss:Type","String");
                            row33cell1data1.setText("报告人信息");
                        Element row33cell2 = row33.addElement(new QName("Cell",namespace));
                        row33cell2.addAttribute("ss:StyleID","s91");
                        row33cell2.addAttribute("ss:MergeAcross","3");
                            Element row33cell2data1 = row33cell2.addElement(new QName("Data",namespace));
                            row33cell2data1.addAttribute("ss:Type","String");
                            row33cell2data1.setText("联系电话:");
                        Element row33cell3 = row33.addElement(new QName("Cell",namespace));
                        row33cell3.addAttribute("ss:StyleID","s92");
                        row33cell3.addAttribute("ss:MergeAcross","8");
                            Element row33cell3data1 = row33cell3.addElement(new QName("Data",namespace));
                            row33cell3data1.addAttribute("ss:Type","String");
                            row33cell3data1.setText("职业:医生 医师 护士 其他 :");
                    Element row34 = table.addElement(new QName("Row",namespace));
                    row34.addAttribute("ss:StyleID","s50");
                        Element row34cell1 = row34.addElement(new QName("Cell",namespace));
                        row34cell1.addAttribute("ss:StyleID","s93");
                        row34cell1.addAttribute("ss:Index","3");
                        row34cell1.addAttribute("ss:MergeAcross","4");
                            Element row34cell1data1 = row34cell1.addElement(new QName("Data",namespace));
                            row34cell1data1.addAttribute("ss:Type","String");
                            row34cell1data1.setText("电子邮箱:");
                        Element row34cell2 = row34.addElement(new QName("Cell",namespace));
                        row34cell2.addAttribute("ss:StyleID","s94");
                        row34cell2.addAttribute("ss:MergeAcross","7");
                            Element row34cell2data1 = row34cell2.addElement(new QName("Data",namespace));
                            row34cell2data1.addAttribute("ss:Type","String");
                            row34cell2data1.setText("签名:");
                    Element row35 = table.addElement(new QName("Row",namespace));
                    row35.addAttribute("ss:StyleID","s50");
                        Element row35cell1 = row35.addElement(new QName("Cell",namespace));
                        row35cell1.addAttribute("ss:StyleID","s63");
                        row35cell1.addAttribute("ss:Index","2");
                            Element row35cell1data1 = row35cell1.addElement(new QName("Data",namespace));
                                row35cell1data1.addAttribute("ss:Type","String");
                                row35cell1data1.setText("报告单位信息");
                        Element row35cell2 = row35.addElement(new QName("Cell",namespace));
                        row35cell2.addAttribute("ss:StyleID","s95");
                        row35cell2.addAttribute("ss:MergeAcross","4");
                                Element row35cell2data1 = row35cell2.addElement(new QName("Data",namespace));
                                row35cell2data1.addAttribute("ss:Type","String");
                                row35cell2data1.setText("单位名称:");
                        Element row35cell3 = row35.addElement(new QName("Cell",namespace));
                        row35cell3.addAttribute("ss:StyleID","s96");
                        row35cell3.addAttribute("ss:MergeAcross","1");
                            Element row35cell3data1 = row35cell3.addElement(new QName("Data",namespace));
                            row35cell3data1.addAttribute("ss:Type","String");
                            row35cell3data1.setText("联系人:");
                        Element row35cell4 = row35.addElement(new QName("Cell",namespace));
                        row35cell4.addAttribute("ss:StyleID","s97");
                        row35cell4.addAttribute("ss:MergeAcross","1");
                            Element row35cell4data1 = row35cell4.addElement(new QName("Data",namespace));
                            row35cell4data1.addAttribute("ss:Type","String");
                            row35cell4data1.setText("电话:");
                        Element row35cell5 = row35.addElement(new QName("Cell",namespace));
                        row35cell5.addAttribute("ss:StyleID","s98");
                        row35cell5.addAttribute("ss:MergeAcross","3");
                            Element row35cell5data1 = row35cell5.addElement(new QName("Data",namespace));
                            row35cell5data1.addAttribute("ss:Type","String");
                            row35cell5data1.setText("报告日期: 年 月 日");
                    Element row36 = table.addElement(new QName("Row",namespace));
                    row36.addAttribute("ss:StyleID","s50");
                        Element row36cell1 = row36.addElement(new QName("Cell",namespace));
                        row36cell1.addAttribute("ss:StyleID","s103");
                        row36cell1.addAttribute("ss:Index","2");
                        row36cell1.addAttribute("ss:MergeDown","1");
                            Element row36cell1data1 = row36cell1.addElement(new QName("Data",namespace));
                            row36cell1data1.addAttribute("ss:Type","String");
                            row36cell1data1.setText("生产企业请 填写信息来源");
                        Element row36cell2 = row36.addElement(new QName("Cell",namespace));
                        row36cell2.addAttribute("ss:StyleID","s111");
                        row36cell2.addAttribute("ss:MergeAcross","12");
                        row36cell2.addAttribute("ss:MergeDown","1");
                            Element row36cell2data1 = row36cell2.addElement(new QName("Data",namespace));
                            row36cell2data1.addAttribute("ss:Type","String");
                            row36cell2data1.addAttribute("xmlns","http://www.w3.org/TR/REC-html40");
                            row36cell2data1.setText("医疗机构");
                                Element row36cell2data1font1 = row36cell2data1.addElement(new QName("Font",namespace));
                                row36cell2data1font1.addAttribute("html:Face","Wingdings");
                                row36cell2data1font1.setText("¨");
                            row36cell2data1.setText("经营企业");
                            Element row36cell2data1font2 = row36cell2data1.addElement(new QName("Font",namespace));
                            row36cell2data1font2.addAttribute("html:Face","Wingdings");
                            row36cell2data1font2.setText("¨");
                            row36cell2data1.setText("个人");
                            Element row36cell2data1font3 = row36cell2data1.addElement(new QName("Font",namespace));
                            row36cell2data1font3.addAttribute("html:Face","Wingdings");
                            row36cell2data1font3.setText("¨");
                            row36cell2data1.setText("文献报道");
                            Element row36cell2data1font4 = row36cell2data1.addElement(new QName("Font",namespace));
                            row36cell2data1font4.addAttribute("html:Face","Wingdings");
                            row36cell2data1font4.setText("¨");
                            row36cell2data1.setText("上市后研究");
                            Element row36cell2data1font5 = row36cell2data1.addElement(new QName("Font",namespace));
                            row36cell2data1font5.addAttribute("html:Face","Wingdings");
                            row36cell2data1font5.setText("¨");
                            row36cell2data1.setText("其他");
                            Element row36cell2data1font6 = row36cell2data1.addElement(new QName("Font",namespace));
                            row36cell2data1font6.addAttribute("html:Face","Wingdings");
                            row36cell2data1font6.setText("¨");
                            row36cell2data1.setText(":");
                    Element row37 = table.addElement(new QName("Row",namespace));
                    row37.addAttribute("ss:StyleID","s50");
                    Element row38 = table.addElement(new QName("Row",namespace));
                    row38.addAttribute("ss:StyleID","s50");
                        Element row38cell1 = row38.addElement(new QName("Cell",namespace));
                        row38cell1.addAttribute("ss:StyleID","s112");
                        row38cell1.addAttribute("ss:Index","2");
                        row38cell1.addAttribute("ss:MergeAcross","13");
                        row38cell1.addAttribute("ss:MergeDown","1");
                            Element row38cell1data1 = row38cell1.addElement(new QName("Data",namespace));
                            row38cell1data1.addAttribute("ss:Type","String");
                            row38cell1data1.setText("备注:");
                    Element row39 = table.addElement(new QName("Row",namespace));
                    row39.addAttribute("ss:StyleID","s50");
                    Element row40 = table.addElement(new QName("Row",namespace));
                    row40.addAttribute("ss:StyleID","s50");
                        Element row40cell1 = row40.addElement(new QName("Cell",namespace));
                        row40cell1.addAttribute("ss:StyleID","s68");
                        row40cell1.addAttribute("ss:Index","2");
                        Element row40cell2 = row40.addElement(new QName("Cell",namespace));
                        row40cell2.addAttribute("ss:StyleID","s68");
                        Element row40cell3 = row40.addElement(new QName("Cell",namespace));
                        row40cell3.addAttribute("ss:StyleID","s68");
                        Element row40cell4 = row40.addElement(new QName("Cell",namespace));
                        row40cell4.addAttribute("ss:StyleID","s68");
                        Element row40cell5 = row40.addElement(new QName("Cell",namespace));
                        row40cell5.addAttribute("ss:StyleID","s68");
                        Element row40cell6 = row40.addElement(new QName("Cell",namespace));
                        row40cell6.addAttribute("ss:StyleID","s68");
                        Element row40cell7 = row40.addElement(new QName("Cell",namespace));
                        row40cell7.addAttribute("ss:StyleID","s68");
                        Element row40cell8 = row40.addElement(new QName("Cell",namespace));
                        row40cell8.addAttribute("ss:StyleID","s68");
                        Element row40cell9 = row40.addElement(new QName("Cell",namespace));
                        row40cell9.addAttribute("ss:StyleID","s68");
                        Element row40cell10 = row40.addElement(new QName("Cell",namespace));
                        row40cell10.addAttribute("ss:StyleID","s68");
                        Element row40cell11 = row40.addElement(new QName("Cell",namespace));
                        row40cell11.addAttribute("ss:StyleID","s68");
                        Element row40cell12 = row40.addElement(new QName("Cell",namespace));
                        row40cell12.addAttribute("ss:StyleID","s68");
                        Element row40cell13 = row40.addElement(new QName("Cell",namespace));
                        row40cell13.addAttribute("ss:StyleID","s68");
                        Element row40cell14 = row40.addElement(new QName("Cell",namespace));
                        row40cell14.addAttribute("ss:StyleID","s68");
        Element worksheetOptions = workSheet.addElement(new QName("WorksheetOptions",namespace));
        worksheetOptions.addAttribute("xmlns","urn:schemas-microsoft-com:office:excel");
            Element pageSetup = worksheetOptions.addElement(new QName("PageSetup",namespace));
                    Element header = pageSetup.addElement(new QName("Header",namespace));
                    header.addAttribute("x:Margin","0.3");
                    Element footer = pageSetup.addElement(new QName("Footer",namespace));
                    footer.addAttribute("x:Margin","0.3");
                    Element pageMargins = pageSetup.addElement(new QName("PageMargins",namespace));
                    pageMargins.addAttribute("x:Bottom","0.75");
                    pageMargins.addAttribute("x:Top","0.75");
                    pageMargins.addAttribute("x:Right","0.699305555555556");
                    pageMargins.addAttribute("x:Left","0.699305555555556");
            Element print = worksheetOptions.addElement(new QName("Print",namespace));
                Element validPrinterInfo = print.addElement(new QName("ValidPrinterInfo",namespace));
                Element scale = print.addElement(new QName("Scale",namespace));
                scale.setText("57");
                Element paperSizeIndex = print.addElement(new QName("PaperSizeIndex",namespace));
                paperSizeIndex.setText("9");
            Element selected = worksheetOptions.addElement(new QName("Selected",namespace));
            Element topRowVisible = worksheetOptions.addElement(new QName("TopRowVisible",namespace));
            topRowVisible.setText("0");
            Element leftColumnVisible = worksheetOptions.addElement(new QName("LeftColumnVisible",namespace));
            leftColumnVisible.setText("0");
            Element showPageBreakZoom = worksheetOptions.addElement(new QName("ShowPageBreakZoom",namespace));
            Element pageBreakZoom = worksheetOptions.addElement(new QName("PageBreakZoom",namespace));
            pageBreakZoom.setText("85");
            Element panes = worksheetOptions.addElement(new QName("Panes",namespace));
                Element pane = panes.addElement(new QName("Pane",namespace));
                    Element number = pane.addElement(new QName("Number",namespace));
                    number.setText("3");
                    Element activeRow = pane.addElement(new QName("ActiveRow",namespace));
                    activeRow.setText("45");
                    Element activeCol = pane.addElement(new QName("ActiveCol",namespace));
                    activeCol.setText("16");
                    Element rangeSelection = pane.addElement(new QName("RangeSelection",namespace));
                    rangeSelection.setText("R46C17");
        Element protectObjects = worksheetOptions.addElement(new QName("ProtectObjects",namespace));
        protectObjects.setText("False");
        Element protectScenarios = worksheetOptions.addElement(new QName("ProtectScenarios",namespace));
        protectScenarios.setText("False");
        Element pageBreaks = workSheet.addElement(new QName("PageBreaks",namespace));
        pageBreaks.addAttribute("xmlns","urn:schemas-microsoft-com:office:excel");
            Element colBreaks = pageBreaks.addElement(new QName("ColBreaks",namespace));
                Element colBreak = colBreaks.addElement(new QName("ColBreak",namespace));
                    Element column = colBreak.addElement(new QName("Column",namespace));
                    column.setText("16");
        // 输出冠字号xml文件;
        OutputFormat XML_FORMAT = new OutputFormat();
        File outFile = new File(myConfig.getSaeExportPath());
        if(!outFile.exists()){
            outFile.mkdirs();
        }
        OutputStream xmlOs = new FileOutputStream(outFile+File.separator+"test.xml");
        XMLWriter xmlWriter = new XMLWriter(xmlOs,XML_FORMAT);
        //xmlWriter.setEscapeText(false);
        xmlWriter.write(doc);
        if (xmlOs != null) {
            xmlOs.close();
        }
        if(xmlWriter!=null)xmlWriter.close();
    } catch (IOException e) {
        e.printStackTrace();
    }  catch (DocumentException e) {
        e.printStackTrace();
    }


}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值