/*02 DocumentProperties*/
create or replace function test_02_DocumentProperties 
  return clob is
  l_ws pls_integer;
  l_row pls_integer;
  l_cell pls_integer;
begin
  plxls_xml.init; -- Initialize instance
  plxls_xml.setDocumentProperties( -- metadata
    p_Title         => 'Title text',
    p_Subject       => 'Subject text',
    p_Author        => 'Author text',
    p_Keywords      => 'Keywords text',
    p_Description   => 'Description text',
    p_LastAuthor    => 'LastAuthor text',
    p_Created       => sysdate,
    p_Category      => 'Category text',
    p_Manager       => 'Manager text',
    p_Company       => 'Company text',
    p_HyperlinkBase =>  null,
    p_Version       => '1.2345'
    );
  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_data => 'Hello World!'
    );
  
  return plxls_xml.getdoc;
end;
/