Tool to convert JSON data to Excel format. Use when you need to transform JSON arrays into Excel spreadsheets with customizable formatting options.
rowintegerThe first row to be written to (0-indexed).
columnintegerThe first column to be written to (0-indexed).
jsonDatastringThe JSON data to be converted to an Excel document. Must be a valid JSON string representing an array of objects.
dateFormatstringSet the date and time format. See: https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
cultureNamestringChange the thread culture used to process the request.
fileContentstringBase64-encoded content of a source JSON file. Use this instead of jsonData if you have a JSON file.
ignoreNullsbooleanIgnore JSON properties which contain null values.
isTitleBoldbooleanSet the title to bold.
numericFormatstringSet the numeric format. See: https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
worksheetNamestringThe name of the worksheet that the JSON data is added to.
outputFilenamestringThe filename of the output Excel document.
titleFontColourstringEnum for title font color options.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.