Skip to main content

From Image File

The From Image File function imports an image file like a bitmap, jpeg, gif, or other format into a report worksheet. This can be used in conjunction with the Data Export Range to Bitmap and Chart to Bitmap functions to build reports like executive summaries which show charts and summary data from other more detailed reports.

Settings

Directory

The directory where the image file to import exists. If this is left blank, the Reports Directory of the current project is used (as defined in the Project Explorer). If this is not a full path reference, the setting is used as subfolders of the Reports Directory.

This can be a fixed name or cell reference where the cell reference contains the directory. Fixed names can contain XLReporter Name Types like {YYYY}, {MMM}, etc. See the Name Types chapter for the full list of supported keywords.

Image File

The name of the image file to import.

This can be a fixed name or cell reference where the cell reference contains the directory. Fixed names can contain XLReporter Name Types like {YYYY}, {MMM}, etc.

If this setting contains a full path, that path is used as the Directory.

Example

To import the daily OOE summary that was exported from the Daily OEE report, the following is used:

Placement

Cell

$B$4

Type

Direct

Setting

Value

Directory

Image File

{YY}-{MM}-{DD}_OEE.bmp