Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

Exporting to Excel

Click on the Export data sets to Excel button (file_excel_normal) on the data sets toolbar. This will start the export process.

Select the data sets you want to export. Each data set will be exported to a different worksheet. Thus, you need to give each worksheet a unique name. You can view the data contained in each data set by selecting the data set in the Available data sets
list.

sql_xls_01  
 
Enter the name of the Excel workbook to save the data sets in, and how many rows should be stored on each worksheet
 
sql_xls_02  
 
You can then select the image and file options to be displayed in the Excel workbook. See the Image and File options topic for details.

sql_xls_03  

SQL Spreadsheets will export the data sets to the Excel workbook you named, and report its progress.
 
sql_xls_04  
 

Once the export process has completed, you can open the Excel file by clicking on the Open workbook
button.

sql_xls_05