Reference:1、Code in Cellset

esProc is a programming tool coding in the cellset. Every statement is contained in a cell, which is similar to Excel.


On the left is the Program Cellset window, the active program cellset you are operating on is shown here; The top right area is the Data View section and the bottom right area is the Variable section.

The esProc expression follows the Java conventions to the utmost, such as % for modulus, == and != for equaling and not equaling, the double quotation marks are required to enclose the strings, the \ is used as the conversion marks, and the &&, ||, and ! are logic operator of AND, OR, and NOT.

Depending on the code in the cells, the cell may be in various colors.


The pink indicates the text is of constant type, the black indicates the text is executable code, and the green indicates the text is comments.

If the cell contains value after computing, then the background color will turn to light yellow. You can check the cell value in the Data View section.

In esProc, if any value is in the cell, then you can use the Cell Name directly as the variable name to call the cell value. This is similar to the Excel.

You can also use the named variable. The variable of this type is called Cellset Variable. You can check the cellset variable in the Cellset Variable section.

In the cellset file, you can define the Cellset Parameter by clicking the Program -> Parameter menu item. This can be defined in the Cellset Parameter window.



When setting the cellset parameters, you can also check options and set parameters before computing. Please note that the names of parameter and variable are case sensitive in esProc.


About datathinker

a technical consultant on Database performance optimization, Database storage expansion, Off-database computation. personal blog at: datakeywrod, website: raqsoft
This entry was posted in Reference and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s