Adding an Excel Template to a Report

eMACH-Sigma enables you to add an excel sheet template to your reports, to fetch the data based on the dynamic values and formula expressions provided in the excel sheet, with accordance to your needs and requirements.

Let's consider that the following demo excel sheet template needs to be added to a report. The dynamic values and formula expression provided in the excel sheet template is based on the data sets available in the demoxl_template table present in the database or schema. It's assumed that a database connection had already been created in eMACH-Sigma Studio, thereby establishing a connection with the database in which the demo_xl template table is available. Refer Creating a Database Connection for detailed information on creating a database connection in eMACH-Sigma Studio. 



Let's see how to add an excel sheet template to a report. For adding an excel sheet template to a report, perform the following steps:

1. Create a data source with the appropriate data element (e.g. demoxl_template), based on which the dynamic values and formula expressions have been specified in the excel sheet.
   
   1. Proceed to click Save to save the configured data source.

   Ensure that you create the data source using a relevant data element. In the provided example, the demoxl_template DB is the used data element from the database or schema, for which the database connection had already been created in eMACH-Sigma Studio. For detailed information on creating data sources in eMACH-Sigma Studio, refer Creating a DB Data Source. 

   
   
   
2. Create a report with the newly created data source (e.g. EXCEL TEMPLATE DS) and provide the necessary configuration details as per your needs and requirements.
   
   1. Click the Additional Info tab.

   
   
   

3. In the Additional Info tab, click the Browse Files option and select the relevant excel template sheet, e.g. Template10.
   
   
   
   

4. Once the excel template sheet gets uploaded, click Save to save the report.

   While editing the excel template report, click the Additional Info tab and then click the Download  icon to download the excel sheet template, which had been uploaded earlier.
   
   
   
   

   To replace the existing excel sheet template with a new one, click the Edit  icon to replace the existing excel sheet template with a new excel template.
   
    
   
   

   On clicking the Edit  icon, the Browse Files option will appear and you can click the Browse Files option to add a new excel sheet template of your choice to the edited report.
   
   

   
   
   
   

5. Access the report in the eMACH-Sigma Application and then click Run to generate the report.
   
   1. Download the generated report in the selected XLS format.
      
      
      
      
   The fetched data of the downloaded report is displayed in the XLS file, as shown in the following screen shot.