Make

Convert Json To Excel

Parameters

Json File Namestring, Required

Map the file name from the source action

Json Filestring, Required

Map the file Data from the source action

First Rowinteger

You can take any value but it must be integer.

First Columninteger

You can take any value but it must be integer.

WorksheetNamestring

Name of the new worksheet in excel. If empty, it will be set as Sheet1

Convert number and dateboolean

You can take any one -
Yes
No

Date Formatstring

Format for date and time string. check for formats here - link

Number Formatstring

Format for numbers. check for formats here - link

Ignore Null Valuesboolean
Default: no

You can select any one -
Yes
No

Set title to Boldboolean
Default: no

You can select any one -
Yes
No

Wrap Title textboolean
Default: no

You can select any one -
Yes
No

Output

Convert Json To Excel module in Make