* The contents described here is Ver 0.30 point.

How to create Excel tool in Board explained.

Get the Board create Excel Tools

And download the file from the following link, please out a file from a ZIP file.

Creating a board layout parameters

To define a parameter or board layout need to save in the.xlsx file and edit in Excel. You can also edit the file in the sample distribution, and can be created from scratch based on.

Even Board container definition file name output file name can be anything, but eventually.

Board container parameter

Create a 'Container' sheet to create a Board container parameter. You must create this sheet.

Create a second column 1 'Key' column Value' header in the first line.

Enter the distinguished name that identifies the values in the key column, it fit each value in the Value column enter will continue. In one of the following parameter can be specified.

  • IdentityName
  • Author
  • Version
  • IsExcludeNextBoard
  • Order
  • KeyReleaseTimingWhenActiveWindowChange
  • PixelPerCentimeter

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
IdentityName This parameter is required.
PixelPerCentimeter Rectangular shape is used in the key layout, size in cm defined shapes in Excel. One Genta I specify here because the size of the key in the senor pixel from the cm to convert pixel scale (1 cm per pixel count). Windows in 96-DPI environment this number is approximately 38.0952. This value is used if left blank. Because different cm, point, pixel values in environments other than 96 DPI otherwise may need to adjust this parameter.

Board para meter

Create a 'Boards' seats to create a parameter of the Board. You must create this sheet.

Type the distinguished name of the parameters of the Board in the first line.

Minutes of Board the second and subsequent lines displayed per row, type the header parameter to match.

Parameters can be specified in the column will be less.

  • IdentityName
  • Position
  • StartPositionType
  • PositionOffset
  • NextBoardPositionType
  • CenterPosition
  • FontSizeScale
  • BoardScale
  • ImageName
  • ImageRenderMode

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
Position

Usually enter the here the size of the Board is automatically determined according to Keeley out if left blank. However, position is (0, 0) to become for the position must see PositionOffset' parameter 'StartPositionType' and you must.

Each parameter is X, Y, Width, Height entered separated by commas.

PositionOffset Each parameter is X, Y type separated by commas.
CenterPosition Each parameter is X, Y type separated by commas.

Key layout

Create {_Layout sheet to create the key layout. Specify the index of the Board starting with 1 "{x}" part. If you need to view multiple boards this sheet is required to only the number of the Board.

This sheet into shape, we will create a layout of keys. It is recommended that so may place any shape, but at the moment only rectangular keys can be created using rectangular shape.

Enter the distinguished name of the key in the shape once you place the shape. This distinguished name works in conjunction with keepelameta. Please note that is not the text that appears in the key.

Text that you type when you enter a distinguished name if no keepelameta is set to keepelameta "KeyType" and "DisplayText". Please note that the specified does not exist "KeyType" fail to load in the application.

The size of the cells when you position shapes on the back is output effect.

Key parameters

Create {_KeyDefine sheet to create a keepelameta. Specify the index of the Board starting with 1 "{x}" part. If you need to view multiple boards this sheet is required to only the number of the Board.

Type the distinguished name of the key parameter in the first line.

Only number keys to target board the second and subsequent lines of each row type according to the parameters of the header.

Parameters can be specified in the column will be less.

  • Name
  • KeyType
  • Position
  • DisplayText
  • FontSize
  • ImageName
  • ImageRenderMode
  • IsToggle
  • IsOneClickToggleRelease
  • Options
  • Processes

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
Name Keepelameta entered the name you enter here and name shapes in the layout sheet work together applies to key for the target position. Layout sheet even Board container definition file output is based on layout sheets, because the name here is no problem.
KeyType If left blank the value in the Name column is used.
Position So I will use will be preferentially used if you enter here the position and size, typically keylayout sheet set in position and size is basically missing, may be. If you enter 'X, Y, Width, Height"type separated by commas. The unit is a logical pixel.
DisplayText If left blank the value in the Name column is used. To wrap text in a cell that breaks the actual display text.
Options If you want to use according to enter.
Processes If you want to use according to enter.

Create a Board container definition file

Create

Move the boards definition files (.xlsx) created a "BoardCreator.xlsm" file folder.

Once you have moved the file open the 'BoardCreator.xlsm'. .Xlsx files in the folder by clicking the Board container definition file generation button in the sheet Board container definition files are generated based on.

Board container definition file successfully processing the same folder with the ".setting' extension is created.

About security

If you opened an Excel file that contains the macro is 'BoardCreator.xlsm' and warning is displayed as shown in figure. (In some cases message differs from the figure)

Allow the macro can run if you receive alerts. You can't create a Board container definition file and does not allow.

Board container definition file deployment

Place the Boards \Default\ folder of the Board container definition file (.setting) created a "TiitanTouchBoard.exe" folder in the. After deployment, one Genta's are loaded when you start the senor.

If incorrect parameter specified when running, so review the setting of the Board when the rebuild.