convert_json_to_excel
Convert a local UTF-8 JSON file to Excel (XLSX), with configurable worksheet names, formatting, and data conversion options.
Instructions
Convert a local JSON file to Excel (XLSX) using the PDF4me ConvertJsonToExcel API. Provide the file path to UTF-8 JSON. Options: worksheet_name, title formatting, number/date conversion and formats, ignore_null_values, first_row/first_column (1-based), and optional output path.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Local path to the JSON file (.json). | |
| first_row | No | First data row (1-based). | |
| output_dir | No | ||
| date_format | No | Date format string for the API. | 01/01/2025 |
| first_column | No | First data column (1-based). | |
| is_title_bold | No | Bold title row when supported. | |
| number_format | No | Number format string for the API. | 11 |
| worksheet_name | No | Target worksheet name. | Sheet1 |
| output_file_name | No | ||
| ignore_null_values | No | Skip null values when building the sheet. | |
| is_title_wrap_text | No | Wrap text in title row when supported. | |
| convert_number_and_date | No | Enable number/date cell conversion. |