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_ ;_ * "-"_ ;_ @_ "/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ "/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ "¥"* #,##0_ ;_ "¥"* \-#,##0_ ;_ "¥"* "-"_ ;_ @_ "/></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(); } }