XLSX Module

Definition

The XLSX utility module, a standard Skyone Studio module available for use in any flow, was created to convert data between JSON and XLSX (Excel) formats using Base64-encoded files.

The XLSX module consists of two operations:

• Convert JSON to XLSX

• Convert XLSX to JSON

---

XLSX Module Configuration

The XLSX module appears under the Tools option when editing a flow. When added to a flow, it provides two operations:

• Convert JSON to XLSX: Converts JSON content into an XLSX file, returning the result in Base64.

• Convert XLSX to JSON: Converts a Base64-encoded XLSX file into JSON format.

---

Convert JSON to XLSX Operation

This operation allows you to convert JSON content (such as API responses, product lists, customer data, etc.) into XLSX format, enabling the generation of Excel spreadsheets from structured data.

How to use

1. Open your integration flow.

2. Select the Convert JSON to XLSX operation.

3. Click Save.

4. When editing the module, the variable configuration area will be displayed.

---

Configuration fields

Worksheet name

Enter the name to be assigned to the generated XLSX worksheet.

JSON

Provide the JSON-formatted content to be converted.

If preferred, click the plus icon ( + ) to configure a SMOP or use data coming from another module in the flow (for example, an API response).

Converted XLSX (Base64)

After clicking Validate, the generated XLSX file will be displayed in Base64 format.

The module does not provide a direct download of the XLSX file. The result is always generated in Base64.

---

Using the generated Base64

The returned Base64 can be:

• Saved for later use;

• Used directly in the application response;

• Converted into a physical file using:

  • JSONata

  • Transformations in the Data Transformation module

  • External implementations that consume Base64

Example of use in the flow response:

• Drag the parameter generated by the XLSX module into the Return module.

• Define a name for the field.

• The Base64 value will be available as the API output.

---

Convert XLSX to JSON Operation

This operation allows converting a Base64-encoded XLSX file into JSON format, enabling the reading and manipulation of spreadsheet data within the flow.

How to use

1. Select the Convert XLSX to JSON operation.

2. Click Save.

3. When editing the module, the variable configuration area will be displayed.

---

Configuration fields

Worksheet name

Enter the name of the worksheet that will be used to read the XLSX file.

XLSX (Base64)

Provide the content of the XLSX file encoded in Base64.

This field accepts Base64 only, including files generated by the XLSX module itself.

XLSX converted to JSON

After clicking Validate, the worksheet content will be displayed in JSON format.

---

Parameters

Each operation of the XLSX module provides a parameter corresponding to the conversion result:

• Convert JSON to XLSX → returns an XLSX Base64

• Convert XLSX to JSON → returns a JSON

These parameters:

• Are available on the left side of the configuration modal;

• Can be used in subsequent modules in the flow;

• Can be manipulated by the Data Transformation module or by SMOPs.

---

Final considerations

The XLSX module was designed to simplify conversion between JSON and Excel, following the Base64 usage standard adopted by Skyone Studio.

Currently supported:

• JSON → XLSX

• XLSX → JSON

To finalize the module configuration, click Save.