/*13 Worksheet setFooter*/
create or replace function test_13_WS_setFooter 
  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   => '&C&P' -- 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;
/