1. Home
  2. Save Sheet to Image File

Save Sheet to Image File

Select menu: File | Save As

This menu is displayed when saving a vector spreadsheet to an image file (BMP, JPG, PNG, GIF, TIF, etc). The menu specifies the format that the colour information takes (RGB values or individual red, green and blue values), and which columns contain the pixel location (X and Y coordinates) and associated colour values.

  1. From the menu select File | Save As then select an image file type.

Sheet format for colour values

There are two formats that can be used to specify the colour of each pixel:

Vector with X, Y and single RGB column Three columns need to be specified from the spreadsheet, giving the horizontal position X, vertical position Y and colour of each pixel (RGB).
Vector with X, Y, Red, Green and Blue columns Five columns need to be specified from the spreadsheet, giving the horizontal position X, vertical position Y, Red, Green and Blue colour component of each pixel.

Note the RGB value is 256*256*Red + 256*Green + Blue, and that the Y value is measured from the top left of the image so that (0,0) is the top left hand corner of the image.

The following calculations show how to convert red, green and blue to RGB values in command mode using the CALCULATE directive:

CALCULATE rgb = RGB(red; green; blue)
CALCULATE red = RED(rgb)
CALCULATE green = GREEN(rgb)
CALCULATE blue = BLUE(rgb)

Columns for image data

Depending on the selection of the sheet format above, there are 3 or 5 dropdown lists of the columns in the spreadsheet. Select from the columns in the spreadsheet one column for each item.

See also

The IMPORT and EXPORT procedures can be used in the command language to load and save images in Genstat.

Updated on March 18, 2019

Was this article helpful?