/*05 Style Alignment*/
create or replace function test_05_Style_Alignment 
  return clob is
  l_ws pls_integer;
  l_row pls_integer;
  l_cell pls_integer;
  l_style_Horizontal pls_integer; 
  l_style_Vertical pls_integer; 
  l_style_Rotate pls_integer;
begin
  plxls_xml.init; -- Initialize instance
  
  l_style_Horizontal := plxls_xml.addStyle(
    p_Name   => 'Style_Horizontal',
    p_Parent => null
    );
  plxls_xml.Style_setAlignment(
    p_style      => l_style_Horizontal,
    p_Horizontal => 'Center'
    );    
  
  l_style_Vertical := plxls_xml.addStyle(
    p_Name   => 'Style_Vertical',
    p_Parent => null
    );
  plxls_xml.Style_setAlignment(
    p_style   => l_style_Vertical,
    p_Vertical => 'Top'
    ); 
    
  l_style_Rotate := plxls_xml.addStyle(
    p_Name   => 'Style_Rotate',
    p_Parent => null
    );
  plxls_xml.Style_setAlignment(
    p_style  => l_style_Rotate,
    p_Rotate => 30
    );   
  
  l_ws := plxls_xml.addWorksheet( -- add worksheet
    p_Name => 'FirstWS'
    ); 
  l_row := plxls_xml.addRow( -- add a row
    p_ws => l_ws
    ); 
  l_cell := plxls_xml.addCell_String( -- add a cell
    p_ws   => l_ws,
    p_row  => l_row,
    p_StyleID => l_style_Horizontal,
    p_data => 'Hello Horizontal!'
    );
  l_cell := plxls_xml.addCell_String( -- add a cell
    p_ws   => l_ws,
    p_row  => l_row,
    p_StyleID => l_style_Vertical,
    p_data => 'Hello Vertical!'
    );  
  l_cell := plxls_xml.addCell_String( -- add a cell
    p_ws   => l_ws,
    p_row  => l_row,
    p_StyleID => l_style_Rotate,
    p_data => 'Hello Rotate!'
    );    
  
  return plxls_xml.getdoc;
end;
/