/*07 Style setFont*/
create or replace function test_07_Style_setFont 
  return clob is
  l_ws pls_integer;
  l_row pls_integer;
  l_cell pls_integer;
  l_style pls_integer; 
begin
  plxls_xml.init; -- Initialize instance
  
  l_style := plxls_xml.addStyle(
    p_Name   => 'FirstStyle',
    p_Parent => null
    );
  
  plxls_xml.Style_setFont(
    p_style         => l_style,
    p_Bold          => true,
    p_Color         => plx_xls_xdoc.c_Fuchsia, -- #FF00FF
    p_FontName      => 'Courier New',
    p_Italic        => true,
    p_Size          => 14,
    p_Family        => 'Modern'
    );
  
  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,
    p_data => 'Hello World!'
    );
  
  return plxls_xml.getdoc;
end;
/