A XLS file is a spread sheet file understood by Spread sheet tools such as Microsoft Excel and Open Office Calc.
Sui is capable of creating a native XLS file from a SQL result-set. This can be achieved in two ways:
- Execute the query and directly create a XLS file
- Export an existing result-set from the Report window to an XLS file
If you are running on Windows and have MS-Excel installed you can choose to directly launch Excel when the XLS file is created.
To set up Sui to automatically invoke Excel, select File->Preferences and the Export tab. Set the parameters as described in the graphics.