Integration with Microsoft Excel

Queries created in SIGADW can be directly read in Microsoft Excel®.

For this, you must follow some procedures:

1. Access Main:  Configuration - Table, and enable Excel Integration:

If you use Enable, per query option, you must indicate which queries can make the integration.

2. In the option Queries: Pre-defined: you must edit the query and select the option Allow Access through Excel® Integration.

3. After enabling the integration with Microsoft Excel®: users that want to use it must download the integration module through the link provided.

4. XLA file must be saved in the station and opened by the user through MS-Excel®.

5. Enter User and Password, click Login. After validating login, select the data warehouse and query, then click import.

6. If you want, enter selection parameters and click Apply to start the worksheet creation with the application of selection, or click Do not Apply to start the worksheet creation with all rows, or click Cancel to finish the integration process.

7. Wait some minutes, and after loading the worksheet, a dialog box is displayed to save the worksheet. Select place, file name, and click Save. Then, you receive a message of the result of query save.