PhpMyCodeGenerator & PhpMyCellScript / News: Recent posts

This release fixes the instructions FOREACH and ITERATOR to rewind an iterator on the first iteration to follow the behaviour of the PHP foreach construct.
A bug in directory file generation script is fixed to prevent exceeding Excel's max cell size.
Also, a new instruction SELECT_DIR is added to MyExcelScript for selecting a directory through a dialog.

This release fixes some bugs in the directory file generation script, like to make it work with non-ASCII source file, and to handle HTML better to prevent problems in Excel.

This release just fixes the example directory file generation script to make it work on file name with the "$" character.
The example directory file generation script supports more source file extensions too.

This release adds four instructions to MyExcelScript: FOREACH, ITERATE, ECHO_ROW and MKDIR.
FOREACH makes it easier to iterate through an array.
ITERATE is a more general instruction to work with any PHP iterators.
ECHO_ROW and MKDIR are added to support a new script which can process a directory and then generate another script to reproduce the directory.

This release
1) Add the ELSE instruction to MyExcelScript.
2) Add an optional parameter to the following instructions: PHP, STRING, PROMPT, ECHO, MERGE, ASSIGN, CONCAT, so that explicit variables can be used instead of the implicit saved value.
3) Add the instruction ARRAY_MERGE to MyExcelScript, to provide another way to add cell values to an array.
4) Add five instructions FILE_LOAD, FILE_SAVE, FILE_TEMP, FILE_COPY, FILE_TOUCH to MyExcelScript, with an example script to show how to download file and extract file from archive.

This release
1) Add four instructions ODBC_CONNECT, ODBC_TABLES, ODBC_COLUMNS, ODBC_EXEC to MyExcelScript, to make it simpler to get information from DB in the spreadsheet.
2) Improve the REPLACE instruction a bit, such that it does not need to be in the column next to the FIND instruction for it to work.

This release changes the order of the parameters to the FIND instruction, so that the most frequently used optional parameters come first.

This release
1) Add two instructions FIND and REPLACE to MyExcelScript, which intends to make it easier to do editor-like Find/Replace programmatically.
2) Add two scripts to demonstrate how to use the new instructions to extract and sort SQL statements, and insert comments to getter and setter methods.
3) Change the ASSIGN, CONCAT and UNSET instructions to accept variables instead of variable names, so that it is possible to assign or concat the saved value to an array, and unset an array element.

This release fixes a bug that the WHILE instruction does not work properly if the last instruction is INCLUDE.

This release fixes a bug that the WHILE instruction does not work properly if it is the last instruction in a column.
The releases 1.3.0 and 1.4.0 are affected by this bug.

This release makes EVAL the implicit instruction in MyExcelScript, so that it is simpler to provide PHP code in the spreadsheet.

This release adds five instructions to MyExcelScript: EVAL, CONCAT, IF, WHILE, RETURN, which makes the language more expressive.

This release supports passing code generator specific arguments to code generators. It also adds a PROMPT instruction to MyExcelScript, and renames the HEREDOC instruction to STRING.

This release adds an example for interpreting a personal scripting language, called MyExcelScript.