Overview
Built on Apache POI, tuned for Jython
DAXL (Duncan Automation XL Spreadsheet Module) is a purpose-built module for Ignition that brings robust Excel and CSV manipulation into the Jython scripting environment. Built on the industry-standard Apache POI framework, DAXL provides a reliable, structured way to integrate spreadsheet data into your SCADA projects without the boilerplate overhead of manual library management.
Integrating spreadsheets into a live industrial environment requires more than a "save" button. DAXL provides the granular control needed for production-grade scripts:
Native Apache POI Support
Fully compatible with .xlsx and .xls formats. If Apache POI can build it, DAXL can handle it — from multi-sheet workbooks to specific cell formatting.
Structured Jython Toolset
DAXL adds a dedicated suite of functions to the system.daxl scope, keeping scripts readable, maintainable, and easy for other integrators to follow.
Bidirectional Data Translation
From spreadsheet to SCADA: parse complex workbooks and map data directly into Ignition datasets for Perspective, Vision, or SQL updates. From SCADA to spreadsheet: extract tag, database, or UI component data into professional-grade workbooks for stakeholders.
Environment Compatibility
Designed to function across the Gateway, Designer, and Client scopes, so reporting and data-entry logic works exactly where you need it.
Function Reference
The system.daxl toolset
Workbook Tools
- system.daxl.workbook.uploadWorkbook
- system.daxl.workbook.downloadWorkbook
- system.daxl.workbook.openWorkbook
- system.daxl.workbook.saveWorkbook
- system.daxl.workbook.newWorkbook
Sheet Tools
- system.daxl.sheet.getSheetCount
- system.daxl.sheet.getSheetNames
- system.daxl.sheet.appendSheet
- system.daxl.sheet.insertSheet
- system.daxl.sheet.copySheet
- system.daxl.sheet.moveSheet
- system.daxl.sheet.renameSheet
- system.daxl.sheet.deleteSheet
Dataset Tools
- system.daxl.dataset.datasetToSheet
- system.daxl.dataset.datasetFromSheet
- system.daxl.dataset.appendDataset
Content Tools
- system.daxl.content.appendRow
- system.daxl.content.insertRow
- system.daxl.content.getCell
- system.daxl.content.setCell
- system.daxl.content.*
Why DAXL
Engineered for reliability
Don't waste billable hours debugging raw Java file streams or managing external .jar files. DAXL provides a stable, supported framework that lets you focus on the logic of your application rather than the mechanics of the file format.
Feedback
What clients are saying
One of the brightest persons I know. A real asset to a project.
Adept at writing and debugging machine code. Good to work with.