Excel to JSON
Convert values from an Excel spreadsheet to JSON for use in your application. You can download this system service from Grexx Marketplace. This system service is also used by Excel to activity.
Input
Use a casetype activity to add inputs to the Start Systemservice Excel to JSON form.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| Column without header prefix | String | No | If First row contains headers is false (see below) columns are provided with a header automatically. This header consists of a prefix and a sequence number (for example, column_1, column_2...). Default: column_. |
| Excel file | File | Yes | Excel file to convert to JSON |
| First row contains headers | Boolean | No | |
| Keep empty lines | Boolean | No | Default: false |
Output
Outputs are added to the Result Systemservice Excel to JSON form when the Systemservice Excel to JSON case is closed.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| JSONs | JSON (multivalue) | No | Set containing values in JSON format. |