Json To Excel Smart Plugin Converter

Overview

  • Ability to Export Json to an Excel file
  • Ability to group rows and columns

Key Features & Functionality

  • Ability to Export Json to an Excel file
  • Ability to use existing template or create a file from scratch.
  • Ability to group rows and columns
Anonymous
Parents
  • I don't see any documentation here or much information within the plug-in about the required data format, so I'll specify it here for those looking (including myself in the future once I forget this again)...

    The plug-in expects a JSON string resulting from an array of dictionaries.  Seemingly anything else will produce a hard-to-understand error.  The property names of the dictionary entries will become the column names when the "header" option is enabled.

    e.g.

    a!toJson(
      {
        {
          name: "John",
          age: 30
        },
        {
          name: "Amy",
          age: 45
        }
      }
    )

Comment
  • I don't see any documentation here or much information within the plug-in about the required data format, so I'll specify it here for those looking (including myself in the future once I forget this again)...

    The plug-in expects a JSON string resulting from an array of dictionaries.  Seemingly anything else will produce a hard-to-understand error.  The property names of the dictionary entries will become the column names when the "header" option is enabled.

    e.g.

    a!toJson(
      {
        {
          name: "John",
          age: 30
        },
        {
          name: "Amy",
          age: 45
        }
      }
    )

Children
No Data