Features

• Added support for PERCENTRANK() and SINGLE() Microsoft Excel functions.
• Added ajBigStrFixCheckSum and ajFixCheckSum for computing the checksum of a Financial Information eXchange (FIX) message.
• Added ajSumByte and ajBigStrSumByte that calculate the sum of byte values of each character in a string.
• Added Kafka Integration (Enterprise Edition only) - AlchemyJ Models can send messages to a Kafka Service using ajKafkaSendMessage(). This feature also works in...

Features

• Added AlchemyJ Extended Function: ajDBExportToWorkbook which retrieves data from a database and exports it directly to a Microsoft Excel workbook.
• Added AlchemyJ Extended Function: ajDBImportFromWorkbook which retrieves data from an Excel workbook and inserts it into a database table.
• Added AlchemyJ Extended Function: ajDBRunSPToWorkbook which exports the result of a stored procedure directly to an Excel workbook.
• Added AlchemyJ Extended Function: ajWebService...

Features

• Generating a REST API in debug mode will automatically activate the API Inspector settings.
• Checks the existence of license key in the beginning of API generation.
• Supports Maven server proxy setting.
• CRUD AlchemyJ functions such as ajCreateRec can handle boolean type. It automatically changes TRUE/FALSE in Excel to 1/0 in database.
• Added a validation rule to check whether class name in Java API and endpoint group in REST API is empty.

Fixes

• Having a table...