XLSX to XML
You need to convert one or more XLSX file to an XML format.
Json
Example
json
{
"name": "file-conversion-xlsx-to-xml",
"taskReferenceName": "xlsx_to_xml",
"description": "The business description of the task",
"type": "SUB_WORKFLOW",
"optional": false,
"inputParameters": {
"mode": "FILE",
"file": "${previous_taskReferenceName.output.file}",
"sheets": [
{
"name": "Test",
"areas": [
{
"startColumn": 1,
"endColumn": 2,
"startLine": 1,
"endLine": 5
}
]
}
]
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Definition
Property | Description |
---|---|
name | The name of the task, must be: file-conversion-xlsx-to-xml |
taskReferenceName | The unique name of the task in your job. |
description | The functional description of this task in your job. |
type | Set SUB_WORKFLOW for this task. |
optional | true : the job continues if there is an error on this task. false : the job fails. |
inputParameters | Input parameters of the task. See below |
Inputs
Property | Description |
---|---|
mode | Enum FILE \ |
file | A valid input. It can reference the output of a previous task, example: ${previous_taskReferenceName.output.file} , or a static file, example: file://assets/file.xlsx , or a user input, example: ${workflow.input.input_key} . |
files | A valid input. It can reference the output of a previous task, example: ${previous_taskReferenceName.output.files} , or a user input, example: ${workflow.input.input_key} . |
sheets | An array of sheet object |
sheets[i].name | The name of the sheet |
sheets[i].areas | An array of objects describing the area that must be parsed. |
Outputs
Property | Type | Description |
---|---|---|
file | An XML file as described below. | |
allFilesTransformed | YES | NO . YES : all files have been transformed successfully. NO : at least one file has not been transformed. |
Output file
Example
xml
<Xlsx-To-Xml>
<File>
<File-Name>products.xlsx</File-Name>
<Sheets>
<Sheet>
<Sheet-Name>products</Sheet-Name>
<Rows>
<R i="1">
<C j="1">EAN</C>
</R>
<R i="2">
<C j="1">1234567890123</C>
</R>
</Rows>
</Sheet>
</Sheets>
</File>
</Xlsx-To-Xml>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Definition
XPath | Description | Occurs |
---|---|---|
Xlsx-To-Xml | Root of the document. | 1 |
./File | For each file. | 1..* |
./File-Name | Original file name. | 1 |
./Sheets | Sheets. | 1 |
./Sheets/Sheet | Sheet, one by sheet. | 0..* |
../Sheet/Sheet-Name | Sheet name | 1 |
../Sheet/Rows | Rows. | 1 |
../Sheet/Rows/R | R = Row, one by row. | 0..* |
../Sheet/Rows/R/@i | i = line index, start index is 1. | 1 |
../Sheet/Rows/C | C = Column. | 0..* |
../Sheet/Rows/C/@j | j = column index, start index is 1. | 1 |
Limits and additional notes
- The limitation of the input file size is 250 Mb.
FAQ
How to convert XLS files?
For now can’t. Only .xslx files can be converted. Therefore you need to save your file with the .xslx extension.
How to convert CSV files?
You can use the task CSV to XML.
Does the empty lines are exported?
No.