Home -> My Folders -> Click on "Create a new folder" link on left side -> add a name for folder (for example: first_sample) -> Click on the "Create" button -> click on new folder which was created by you
-> Click on "Create a new report" on left side -> add a name for report (for example: multisheet_excel) -> click on "Create" button
-> click on "Edit" link
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVnh1HTeKugv4fu7-C35SD-zsTbPM6H-DfzXHtVASUBTNWjp-VK_dmmhZIwx4IIDZEUoj7l_pmAbLLbFWR4rrzuByhmzJ4IXsLPoqm4FWr9BI0IzKPNSFy_qSMP_J_ZGsqRa0nUqUXTac-/s200/02.png)
-> click on "Data Model" -> New ->
Name: first_query
Type: Sql Query
Data Source: choose you data schema
SQL Query:
select EMP.JOB as JOB,
EMP.SAL as SAL,
EMP.HIREDATE as HIREDATE,
EMP.EMPNO as EMPNO,
EMP.ENAME as ENAME,
EMP.COMM as COMM,
EMP.MGR as MGR,
EMP.DEPTNO as DEPTNO
from ZSUZSI.EMP EMP
-> Click on "Save" on left side and top of page
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvCLV9XQsof8vvJXryV_Z9a11PCWvNa5Icud-JAq1ybZW08rDWw7YkikYtCiE_FpwBjCzzOM8ez95sygbUmew6WPgzr_qV54rP3MVcBKwwmYwZsuyi57S0Gw3SKKGlvO2ETqzRuA33nzZH/s200/03.png)
-> Click on "View" on right side and top of page
-> Click on "View" button
If you see the XML data then you can start multi-sheet Excel template.
2) Create multi-sheet Excel template
->Start MS Excel -> create new excel file like the following pictures:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm_St6zjRpfCzvJ8AkTCPmaqIMYm1sJxrPO2CCqHbkXDSJSRHVsYc-YaOHgP-0Cd3XdT1Cr1oGDxfRepOKuPXSUunysJUpCPImGhFPggflSoC1VRjMRgEyty6tWc4tAmDi8C1HAOS6k20C/s200/04_1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoN3Ecnn5SZ8svcbOXQH3sOBW0LbOpQa67h8NEPTEeWVsRwGBv_LO3EItZtGsH5ZLuinchfHrQ4byHSECc5KXtZffV4SpXlbuColfIwc0NUARrkL7VJSc3Wu4ao0qRQPEz6ipuXwcqVdxJ/s200/04_2.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRsd_OvKaqKGMS2Fysf6c9aZigoWEnzBckhbfy1semfDwVXZkKlM_Yc3ID1-6iaT3uZ7t7BoG8qFyBTEkA8y7U_Jh_4VC6HnQRXB9x1Z6Aw98ScWY4fnOGoFHPM5v4RgBnQQMNLpYMabmx/s200/04_3.png)
3) Convert Excel file to XSL file
-> Save As your excel file and change your file type to XML Spreadsheet type -> use the XLS Processor Engine for Oracle program for convert the xml file to xsl file
4)Upload excel template
In Oracle BI Publisher Enterprise edit your report ->Click on "Layout" -> Manage Template Files ->Upload Template: browse your xsl file and click on Upload button -> click on "New" on top of side bar (create a new layout)->
Name: first_layout
Template: your uploaded XSL file
Template Type: XSL Stylesheet(XML)
Output Format: All Formats
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs3taenOs8t6VzBRs2p5yRj2aJfsFNnbnRJ4qmKB75D4civT8j2fx3BUPFRnZ1o5-DjPBagrmpR66w6Ll_PdkF0AFua9rOe0CqemZ1fkYdDFWmhlBL83F0D2BI7FLEiJSsbYNiDnGxcuU4/s200/05.png)
-> Click on "Save"
-> Click on "View" link on right side and top of page
-> select "first_layout" and "XML" for template and click on View button, after that click on Export button and save the XML file. -> change this file's extension (XML) to XLS and open it.