Json to Excel

[Filip (Filip Belák)]

Hi, i have problem with Excel Serializer v3.2.0, I define name of sheet in first step, and when task gets to 3rd step error message occures : Input does not contain column ‘SHEET1’ with sheet names.

But in first step, is this JSON where is the column name defined.

Between this two steps is Json To Excel Converter (v 3.0.4)

[tomas (Tomas Belak)]

Hi Filip,

you are mixing two connectors. There are two ways how to get data into Excel:

Excel serialiser

Here you have to provide flat data schema with data and configure it based on manual here: Excel serializer - Help center

Second option is to use

JSON to Excel

Here you have to specify special JSON with structure you have on your picture and then send it to JSON to Excel connector: JSON to Excel converter - Help center

Regards, Tomas.

[Filip (Filip Belák)]

Thanks, I have another problem, what does mean "file"scheme in this configuration?

[tomas (Tomas Belak)]

Hi,

without seeing configuration schema I can’t help. @Filip

Tomas.

[Filip (Filip Belák)]

HI, here it is

STEP 1:
`const obj = {
“Sheets”: [
{
“Name”: “First sheet”,
“DisplayHeader”: true,
“Columns”: [
{
“Name”: “ID”,
“DataType”: “int”
},
{
“Name”: “Name”,
“DataType”: “string”
},
{
“Name”: “Created”,
“DataType”: “datetime”,
“Format”: “MM/dd/yyyy”
},
{
“Name”: “IsActive”,
“DataType”: “bool”
},
{
“Name”: “Score”,
“DataType”: “double”
},
{
“Name”: “Formula”,
“DataType”: “formula”,
“Format”: “General”
}
],
“Rows”: [
[
1,
“Jan”,
“2020-12-08T15:37:00Z”,
true,
3.7,
“A2+E2”
],
[
2,
“Petr”,
“2021-12-08T15:37:00Z”,
false,
1.23,
“A3+E3”
]
]
}
]
}

return [{“JSON”: JSON.stringify(obj)}];`

[tomas (Tomas Belak)]

Hi,

This looks like a problem with Microsoft email connector. Please follow with @hana.foltynova and register defect for this issue.

Tomas.