SQL Spreadsheets online help Prev Page Prev Page
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
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
Run task
Scheduling a task

Image and file options

Select how images and binary data should be exported on this page.

You can choose to display images in the spreadsheet itself by selecting the in the spreadsheet item.


You can choose to display images as links in the spreadsheet by selecting the as a link in the spreadsheet


You can also choose to display images in the spreadsheet itself, and also as a link to the full sized image image, by selecting the in the spreadsheet and also as a link


The size of the image in the spreadsheet is determined by the cell size you enter.

For binary data that are not images, you can choose to export them to disk by selecting the Create links to binary data files

For image and binary that are saved to disk, you can select how the exported files will be named. By default, they will be named using the cell reference e.g.

You can also provide the file name to save the file in, by selecting the using values from the previous column item.

When you select this item, the column prior to the binary data column must contain a file name. If you look at Demo 4, you will see that the SQL query retrieves the file name column prior to the binary data column:

In the exported spreadsheet, the link description uses the file name:

When another file of the same name as the exported file exists, you have 3 options. You can choose to make each exported file have a unique name by selecting the generate unique name item. In the screenshot above, rows 10, 12 and 14 actually referenced the same image in the database, but SQL Spreadsheets saved the files using unique file names.

If you choose the generate unique name only if file was not created for this spreadsheet
item, SQL Spreadsheets will not save duplicate files for the current spreadsheet. In the example below, rows 10, 12, and 14 now reference the same image.

Finally, you can choose to overwrite any existing files of the same name by selecting the overwrite existing file item.

All external files will be saved in the same folder as the exported spreadsheet. If you want the files to be saved in a subfolder, enter the name of the subfolder in the Files folder
area. In the example below, the spreadsheet file is saved in the folder F:\Projects\.

If we now enter the value files as below in the Files folder, all exported files will be stored in the F:\Projects\files folder.