pl/sql利用xml控制excel格式，输出报表

最新推荐文章于 2024-03-21 09:58:05 发布

原创

最新推荐文章于 2024-03-21 09:58:05 发布 · 462 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #xml #plsql

pl/sql利用xml控制excel格式，输出报表

1. 定义标头格式

l_report_title1 VARCHAR2(32676) := '<?xml version="1.0" encoding="ENCODE_CHARSET" ?>
 <?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">
<Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m202287020">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <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" x:Family="Modern" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
  </Style>
  <Style ss:ID="s33">
   <Alignment ss:Vertical="Center"/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Size="12"
    ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s34">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Size="12"
    ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s35">
   <Alignment ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s36">
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"
    ss:Bold="1"/>
  </Style>
  <Style ss:ID="s37">
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Size="12"
    ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s38">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"
    ss:Bold="1"/>
  </Style>
  <Style ss:ID="s39">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s40">
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s41">
   <Alignment ss:Horizontal="Right" ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"
    ss:Bold="1"/>
  </Style>
  <Style ss:ID="s42">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="仿宋" x:CharSet="134" x:Family="Modern" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s43">
   <Alignment ss:Horizontal="Center" ss:Vertical="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" x:Family="Modern" ss:Color="#333333"/>
  </Style>
  <Style ss:ID="s44">
   <Alignment ss:Horizontal="Center" ss:Vertical="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" x:Family="Modern"/>
  </Style>
  <Style ss:ID="s45">
   <Alignment ss:Horizontal="Center" ss:Vertical="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=