AlchemyJ v4.1.3

Adds new function that retrieves data from a database and exports it directly to an Excel workbook.
November 8, 2021
New Version

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 which is an enhancement over ajWebServiceREST and ajWebServiceSOAP. It supports getting header and cookie values from the response, SSL certificate check, and more.
  • Added AlchemyJ Extended Functions for folder operations: ajCopyFolder, ajDeleteFolder, ajFolderExists, ajMoveFolder, ajRenameFolder, ajFolderList, ajFileProperty and ajCreateFolder.
  • Added support for 39 Excel functions.
  • ajCheckDataItem has been modified to ignore empty records.
  • ajJsonPath has a new Run by Function Point parameter which prevents it from running every time a workbook is calculated.
AlchemyJ v4.1.3
AlchemyJ

AlchemyJ

Generate Java APIs and Web APIs from Microsoft Excel.

Get Quote Buy Now

Got a Question?

Live Chat with our Axisoft licensing specialists now.