...
- 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.
- Proceed to click Save to save the configured data source.
Note 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 Sigma Studio. For detailed information on creating data sources in Sigma Studio, refer Creating a DB Data Source.
- 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.
- Click the Additional Info tab.
- In the Additional Info tab, click the Browse Files option and select the relevant excel template sheet, e.g. Template10.
- Once the excel template sheet gets uploaded, click Save to save the report.
- Access the report in the Sigma Application and then click Run to generate the report.
- Download the generated report in the selected XLS format.
- Download the generated report in the selected XLS format.
...