Spreadsheet Support Tools Package
This package contains three useful applications that
interface with the .tif file format used by WinTES2 to save thermal images
obtained from Compix thermal imaging cameras.
These applications are useful utilities by themselves, but also serve as
examples for creating other applications that utilize images saved from Compix
This package consists of three downloadable .zip files:
< 2 MB Documentation; Applications 1 & 2.
79 MB Application 3, Selective extraction.
< 2 MB Development notes and source code.
The applications included are:
1. Opens and displays a Compix .tif image.
2. Opens a Compix .tif image and creates a spreadsheet .csv file
of temperature data.
3. Opens a Compix .tif image, interactively aligns a grid of small regions,
then extracts the data for the average temperature of those regions
to a spreadsheet .csv file.
Items 1 and 2 are written in Visual Basic, and item 3 is
written in LabView.
1. Application to open and display a Compix
The principal purpose of this application is to serve as a
Launch the file,
When that program opens, click the "Select" button
to open a standard file browse dialogue.
Select the .tif file you want to display and click "Open"
To read the selected image file, click the "Open"
button. The block to the right of the
"Open" button displays the status of the file read step. The following status values may be
4 -- Warning: The
TIF file contained No Display Parameters.
3 -- Warning: The
TIF file contained No Parameter Data.
0 -- The TIF file was read without error.
-1 -- The TIF file is not a WinTES2 type image file and
cannot be read.
-2 -- The TIF file contained No Thermal Data.
If the read step was successful, you may click the
"Show" button to display the image.
2. Application to create a spreadsheet .csv
file of temperature data.
This application will convert the thermal data in a Compix
WinTES2 TIFF file to a text file
containing the numeric temperature data contained in the TIF image file in a
.csv format (comma separated values) compatible with most spreadsheet programs.
TIFF_to_csv.exe and the window shown to the left will be displayed.
Click the "Select" button to open a standard file
browse dialogue. Select the .tif file
you want to display and convert and click "Open".
The thermal image for the opened file is displayed. An indication of the success or failure of
the open is shown in the space to the right of the Open button. The path and name of the opened file is
displayed above the Open button.
If the file was opened successfully, the "Write
CSV" button will be enabled.
Clicking the "Write CSV" button opens a standard file dialogue
window to enable the user to browse to a folder and to supply a name for the
file to be written. Click
"Save" to complete the writing of the file.
Some spreadsheet programs may not be able to handle
spreadsheets as large as 320 x 240 created by some cameras using WinTES2. Option buttons in the lower right corner of
the TIFF_to_csv window provide the option to write just every other pixel. Make that selection, if needed, before
clicking the "Write CSV" button.
After you have opened an image, and optionally written the
corresponding .csv file, you may click "Close" to exit the
application, or click Open to open a different image.
The file, "Image spreadsheet with colormap.xls"
included in this package is an example of the result of using the .csv output
of this application. It includes some
useful macro definitions to enable coloring the cells of the spreadsheet in a
manner similar to the colormaps used by WinTES2. Select Enable Macros when opening this example spreadsheet. A portion of the spreadsheet is shown
below. The illustration at the top of
this web page is a portion of this spreadsheet.
3. Application to extract regions from a Compix
TIF image to a .csv file.
This application enables the user to interactively align a
grid of circular regions and create a file compatible with most spreadsheet
programs in .csv format containing the average value of each region.
When you launch this application, you will then see the
window shown below overlaid with a standard file browse window. Use that browse window to select the TIF
file from which to extract data.
The color scale shown in the center top of the window
initially spans the range from 0 to 100°C and images spanning a narrow range of
temperature will not show up very well.
Right-click the color scale and select "Auto Scale". Further adjustments may be made as necessary
using LabView's rich range of editing tools for this color scale feature.
The 12 x 8 array of regions can be aligned to the image by
moving any of the four corner regions marked with an "X". The array of regions will stretch and adjust
to uniformly distribute the regions between the corners.
The array of values in the right half of the window
initially displays the average values for the 5 rows x 4 columns of regions
starting from the upper left corner.
The portion of the total array being read out can be adjusted using the
two controls near the upper left corner of the value array.
The number of regions can be changed from the initial
default of 8 rows and 12 columns using the Rows and Columns controls in the
middle center of the window. The
minimum is 2 rows or columns, and the actual maximum is much larger than the
practical maximum of about 100.
Below the thermal image with its overlaid regions is a section
displaying the coordinates of the four corners. One or more of the corners can be selected by clicking the X at
the left of the two-letter corner name (UL,LR,UR, or LL) . The 4-diamond array to the right of the
corners table can then be used to move all selected corners as a group in any
of the four directions.
When the regions have been adjusted to the desired
arrangement, click the OK button below the caption "Save Array" in
the upper right portion of the window.
A standard browse window will be displayed for selecting the name and
path of the .csv file to be written.
After saving the .csv file, the regions may be further
adjusted and another .csv file saved.
In order to process a different image, it is necessary to close the
window and restart the application.