Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Reference Guide
Main menu
Connect to Database
Connecting to databases directly without client libraries installed
Connecting to an Oracle database
Connecting to a DB2 database
Options
General options
Thumbnail options
Hex view
The work area
SQL editor
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Post-processing Office files
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data
DICOM images
Hidden Excel worksheets

Hidden Excel worksheets

When you export embedded Excel worksheets from OLE Object columns, the worksheets may be hidden by default. To view the worksheets, you would need to unhide them.

xls_unhide  

SQL Image Viewer can automatically unhide the worksheets for you if the following 2 conditions are met:

· you have Excel installed on the machine that you are exporting the files from  
· the version of Excel you have is able to open all the exportedworksheets  

To unhide the worksheets using SQL Image Viewer, in the Export Items Wizard, click on the Office post-processing options button.

export-step1e  
 
On the next screen. select the Unhide workbook option.

export-step1d_unhide