New DocsDocumentationWorkflowsWorkflowsPricingSupport
API V2

Convert JSON To Excel

  • Method: POST
  • Endpoint: /api/v2/ConvertJsonToExcel

Parameter

File NameString, Required

Name of the file.

doc NameString, Required

Content of the base file.

Work Sheet NameString, Required

Specify the name of the worksheet. You can assign any name, but it must be provided as a string.
For example, entering sheet1 will create or refer to a worksheet named sheet1.

Is Title Wrap Text Boolean, Required
  • Selecting true will wrap the title text so that if it is too long, it continues on the next line within the same cell.
  • Selecting false will keep the title text on a single line, which may cause it to be cut off or overflow if it is longer than the cell width.
Is Title Bold Boolean, Required
  • Selecting true will make the title text bold, emphasizing it for better visibility.
  • Selecting false will keep the title text in normal (regular) formatting without bold styling.
Convert Number And Date Boolean, Required
Default: false
  • Selecting true will convert numeric values and dates into standard number and date formats (e.g., 1234 → 1,234, 2025-08-29 → 29-Aug-2025).
  • Selecting false will keep the values as plain text without conversion.
Number Format String, Required

Specify any value, but ensure that it is provided as a string. This means the value should be enclosed in quotation marks when required by the system.
For example, entering ‘11’ (as a string) will be accepted.

Date FormatString, Required

Specify the date in string format. This means the date should be entered as text rather than a numeric or system-generated value.
For example, you can provide the date as 01/01/2025 in string format to ensure it is processed correctly.

Ignore null valuesString, Required
Default: false
  • Selecting true will skip or exclude any fields that contain null values.
  • Selecting false will include null values in the output, which may result in blank fields being displayed or processed.
First Rowinteger, Required

Specify any value, but it must be provided as an integer. This means only whole numbers are accepted (no decimals or text).
For example, entering 1 is valid, while values like 1.5 or ‘one’ will not be processed correctly.

First Columninteger, Required

pecify any value, but it must be provided as an integer. This means only whole numbers are accepted (no decimals or text).
For example, entering 1 is valid, while values like 1.5 or ‘one’ will not be processed correctly.

Output

File ContentBinary

Output file content from the PDF4me Connect

Header
Content-Type:application/json
Authorization: Please copy key from the link.

Payload

{
  "docContent": "Please put text base64 content",
  "docName": "output",
  "worksheetName": "Sheet1",
  "isTitleWrapText": true,
  "isTitleBold": true,
  "convertNumberAndDate": false,
  "numberFormat": "11",
  "dateFormat": "01/01/2025",
  "ignoreNullValues": false,
  "firstRow": 1,
  "firstColumn": 1
}

PDF4me api samples

CSharp(C#)
Java
JavaScript
Python
Salesforce
n8n
Google Script
AWS Lambda
Other Docs