Home Home Applications Products Products Support Support Downloads Downloads Company Company

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 cameras.

This package consists of three downloadable .zip files:

BasicSStools.zip   < 2 MB    Documentation; Applications 1 & 2.
Extraction.zip      79 MB     Application 3, Selective extraction.
TIFFaccess.zip    < 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 .tif image.

The principal purpose of this application is to serve as a development example.

Launch the file, TestWT2FileIO.exe .

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 displayed:

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.

Launch 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 100C 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.

Compix is a registered trademark of Compix Incorporated. Copyright © 2010 Compix Incorporated. All rights reserved.