User Tools

Site Tools


Guide Section: Processing Events and Performing Actions | EASAP Tree: EVENT PROCESSING > ACTION / PROCESSES

IMAGE EXCEL ACTION extracts images from an Excel spreadsheet.

Set this action in IMAGE > Image From Action: in the DIAGRAM LIST on the Tree.

Additionally setting a file name in Upload Image Name: will create an image file (*.jpg, *.bmp, *.png) which will be uploaded to the EASA Server for storage in the results folder when the EASAP is submitted.

There are two approaches to extract an image from a SPREADSHEET:

  1. Select an existing chart in the spreadsheet using Spreadsheet: and Chart:
  2. Select a range of cells either via a NAMED RANGE or cell range Sheet: and Range:

If the image extracted does not appear the desired size within your diagram, you can use Scale: to change the image’s size.

  • If a range is not set in the 2nd method, then an image capture of the full screen is extracted.
  • If you specify both the Spreadsheet and Sheet parameters or both the Chart and Range parameters, you will encounter an error message since the two methods of defining an image are mutually exclusive.
  • The image size is impacted by the DPI setting on the Excel Server under properties/settings/advanced under Start > Control Panel > Settings tab and then clicking on the 'Advanced' button.
  • IMAGE EXCEL ACTION will save the image in three different file types: *.png, *.bmp* or *.jpg by default.
    Use the filename extension to specify the format. For example to create a *.png file set Upload Image Name: test.png
  • IMAGE EXCEL ACTION is affected by the operating system's DPI setting, meaning that if there are different DPI settings in place for the server and the client computer then the resulting images' size can appear mismatched or out of proportion.
  • Excel 2016 has a limitation of 125 rows, this ACTION will silently fail above this.
  • Some builds of Excel 2016 give low quality images, we recommend updating to a newer build.
    As a workaround set Scale: 2 or higher to raise image quality, (although settting it too high can cause the ACTION to fail)

Essential Parameters: (PROCESSES branch only)
File Name:Enter a filename of the image file, the suffix determines the type of image file (*.png,*.bmp, *.jpg)
Optional Parameters:
Sheet:Select SHEET from a list as image source
Chart:Select a CHART REFERENCE from a list in SPREADSHEET
Range:Select a NAMED RANGE or enter a range reference to capture as screenshot
Range reference format is: cell1:cell2 (ie, B6:G31 )
Scale:Set a scale factor to apply to image size captured from Excel spreadsheet.
Less than 1 will shrink, greater than 1 will enlarge image (setting too high may cause the ACTION to fail)
Delimiter:Set a character to delimit object references in Range:
Default: %
Do if:Enter a logical expression if true ACTION will fire and not otherwise
Default: true
Queue:Set to TRUE to avoid running out of of free Excel processes
On Error: Set to STOP to halt any subsequent PROCESS or ACTION if there is an error