Overview
The Excel connector for Bizagi is available for download at Bizagi Connectors Xchange.
Through this connector, you will be able to connect your Bizagi processes to an Excel spreadsheet and fetch or update information.
For more information about this connector's capabilities, visit Bizagi Connectors Xchange.
Before You Start
In order to test and use this connector, you will need:
1.Bizagi Studio previously installed.
2.This connector previously installed, via the Connectors Xchange as described at Bizagi Connectors Xchange article, or through a manual installation as described in the Installing and managing connectors article.
|
To connect to an Excel spreadsheet, you do not need accounts nor authentication credentials. This connector does not include an authentication mechanism, and therefore works for Excel spreadsheets which are already uploaded into Bizagi processes (accessible via Xpath). |
Configuring the Connector
In order to configure the connector, follow the steps presented at the Configuration chapter in the Installing and managing connectors article.
For this configuration, you only need to create a system configuration instance, but no specific parameters are needed.
|
•This connector does not launch an Excel application instance; instead, it directly accesses the data in .xls or .xlsx files. Therefore, you do not need to have Excel installed or any additional plug-ins. •Please note that macros within the Excel file cannot be executed. •Additionally, accessing data through this connector may result in significant delays, depending on the size of the Excel file. |
Using the Connector
This connector features an available method that reads content from a specific cell in Excel.
To learn overall how/where to configure the use of a connector, refer to the Using connectors documentation.
When using the connector, make sure you consider the following details for each of the two available methods.
Get Cell Data
This method allows you to map an attached Excel file and specify the name of the sheet and the cell name from which you want to obtain information (its value, formula, etc).
To configure its inputs, consider:
•Cellname: The cell name, e.g "A1".
•Workbookdata: A file type attribute in Bizagi which holds the Excel file.
•Worksheetname: The name of the worksheet applicable to the cell.
To configure its outputs when getting started and testing, you may map Value to store the information contained in the cell (or similarly, store formatted Text or formula, as managed by Excel).
For more information about how to extend this connector and use its methods, refer to the used API's documentation at https://www.npmjs.com/package/xlsx.
Last Updated 12/10/2025 5:00:40 PM