/*11 addWorksheet*/ create or replace function test_11_addWorksheet return clob is begin plxls_xml.init; -- Initialize instance plxls_xml.addWorksheet(p_Name => 'WS1'); -- add worksheet plxls_xml.addRow; -- add a row to the current Worksheet plxls_xml.addCell_String_1('Hello WS1!'); -- add a cell to the current row plxls_xml.addWorksheet(p_Name => 'WS2'); -- add worksheet plxls_xml.addRow; -- add a row to the current Worksheet plxls_xml.addCell_String_1('Hello WS2!'); -- add a cell to the current row plxls_xml.addWorksheet( -- add worksheet p_Name => 'WS last protected', p_Protected => true ); plxls_xml.addRow; -- add a row to the current Worksheet plxls_xml.addCell_String_1('Hello Protected!'); -- add a cell to the current row return plxls_xml.getdoc; end; /