Import JSON files to Excel File

Usage

import_json_files_to_excel(
  json_dir,
  file = file.path(json_dir, "umberto-results.xlsx"),
  overwrite = FALSE,
  open = TRUE,
  expand_keys = c("process", "place", "exchange")
)

Arguments

json_dir: path to directory containing .json files
file: path to Excel file to be created. Default: "umberto-results.xlsx" within json_dir
overwrite: whether or not to overwrite the Excel file if it exists. Default: FALSE.
open: logical indicating whether or not to open the created Excel file
expand_keys: If this argument is not NULL but a vector of (key) column names, all sheets are expanded to the same number of rows. All possible combinations of values in these key columns are then given in each sheet even though there are no values for these key value combinations. Default: c("indicator", "process", "place", "exchange")

Value

path to created Excel file