/*14 Worksheet setHeader*/
create or replace function test_14_WS_setHeader
  return clob is  
  l_ws pls_integer;
begin
  plxls_xml.init; -- Initialize instance
  l_ws := plxls_xml.addWorksheet(p_Name => 'FirstWS'); -- add worksheet
  
  plxls_xml.WS_setFooter(
    p_ws     => l_ws,
    p_Margin => 20,
    p_Data   => '&CPL/XLS' -- Center, Page number
    );
  
  plxls_xml.addRow; -- add a row to the current Worksheet
  plxls_xml.addCell_String_1('Hello World!'); -- add a cell to the current row
  
  return plxls_xml.getdoc;
end;
/