Can anybody assist me to spooling of information into different sheets for various queries inside a stand out from Oracle.

Query1-->Sheet1
Query2-->Sheet2
Query3-->Sheet3

Thanks

Another named Jason Bennett includes a package known as ExcelDocumentType. Haven't done much by using it besides download it, however it looks promising.

I've developed ORA_Stand out www.oraexcel.com, an Oracle PL/SQL package that may create Stand out documents with sheets.

Code and build Stand out document with data according to your question:

BEGIN  
   ORA_EXCEL.new_document; 

   -- Sheet 1
   ORA_EXCEL.add_sheet('Sheet1');
   ORA_EXCEL.add_row;
   ORA_EXCEL.set_cell_value('A', 'Id');
   ORA_EXCEL.set_cell_value('B', 'First name');
   ORA_EXCEL.set_cell_value('C', 'Last name');      
   FOR rec IN(SELECT * FROM table1) LOOP
       ORA_EXCEL.add_row;
       ORA_EXCEL.set_cell_value('A', red.id);
       ORA_EXCEL.set_cell_value('B', red.first_name);
       ORA_EXCEL.set_cell_value('C', red.last_name);
   END LOOP;

   --Sheet 2      
   ORA_EXCEL.add_sheet('Sheet2');
   ORA_EXCEL.add_row;
   ORA_EXCEL.set_cell_value('A', 'Id');
   ORA_EXCEL.set_cell_value('B', 'First name');
   ORA_EXCEL.set_cell_value('C', 'Last name');      
   FOR rec IN(SELECT * FROM table2) LOOP
       ORA_EXCEL.add_row;
       ORA_EXCEL.set_cell_value('A', red.id);
       ORA_EXCEL.set_cell_value('B', red.first_name);
       ORA_EXCEL.set_cell_value('C', red.last_name);
   END LOOP;

   -- Sheet 3
   ORA_EXCEL.add_sheet('Sheet3');
   ORA_EXCEL.add_row;
   ORA_EXCEL.set_cell_value('A', 'Id');
   ORA_EXCEL.set_cell_value('B', 'First name');
   ORA_EXCEL.set_cell_value('C', 'Last name');      
   FOR rec IN(SELECT * FROM table3) LOOP
       ORA_EXCEL.add_row;
       ORA_EXCEL.set_cell_value('A', red.id);
       ORA_EXCEL.set_cell_value('B', red.first_name);
       ORA_EXCEL.set_cell_value('C', red.last_name);
   END LOOP;      

   -- EXPORT_DIR is Oracle directory
   ORA_EXCEL.save_to_file('EXPORT_DIR', 'example.xlsx');
END;

I've upgraded package, so you can now export query to sheet on following way:

BEGIN
    ORA_EXCEL.new_document;

    ORA_EXCEL.add_sheet('Employees');
    ORA_EXCEL.query_to_sheet('select * from employees');

    ORA_EXCEL.add_sheet('Departments');
    ORA_EXCEL.query_to_sheet('select * from departments');

    ORA_EXCEL.add_sheet('Locations');
    ORA_EXCEL.query_to_sheet('select * from locations');

    ORA_EXCEL.save_to_file('EXPORT_DIR', 'example.xlsx');
END;