Note: for v17 and earlier, move manifest.json to Contents

4d-plugin-xlsxio

very simple XLSX library based on XLSXIO

Syntax

json:=XLSX TO JSON (path;options;error)

Parameter	Type	Description
path	TEXT	location of .XLSX document
options	LONGINT	options
error	TEXT	on outout, error in JSON; on input the sheet name to read
json	TEXT	values in JSON

XLSX SHEET NAMES (path;names)

Parameter	Type	Description
path	TEXT	location of .XLSX document
names	TEXT ARRAY	sheet names

JSON TO XLSX (path;json;row_height;detection_rows;error)

Parameter	Type	Description
path	TEXT	location of .XLSX document
json	TEXT	values in JSON
json	LONGINT	row height
json	LONGINT	number of rows used to detect column widths
error	TEXT	error in JSON

• Options for XLSX TO JSON

XLSXIOREAD_SKIP_NONE 0
XLSXIOREAD_SKIP_EMPTY_ROWS 1
XLSXIOREAD_SKIP_EMPTY_CELLS 2
XLSXIOREAD_SKIP_ALL_EMPTY 3
XLSXIOREAD_SKIP_EXTRA_CELLS 4

Remarks

Only the first sheet is exported with JSON TO XLSX

All values are imported as text with XLSX TO JSON

Values can be text, number, or bool with JSON TO XLSX, but you would need to use Collection for that.

For more information see https://github.com/brechtsanders/xlsxio

Examples

$path:=System folder(Desktop)+"sample.xlsx"

  //all values are returned as string
$json:=XLSX TO JSON ($path;XLSXIOREAD_SKIP_EMPTY_ROWS;$json_e)

$xlsx:=JSON Parse($json)
$_err:=JSON Parse($json_e)

$row_height:=1  //set row height
$detection_rows:=10  //how many rows to buffer to detect column widths

$path:=System folder(Desktop)+"sample-copy.xlsx"
  //only 1 sheet is supported
JSON TO XLSX ($path;$json;$row_height;$detection_rows;$json_e)

OPEN URL($path;"Microsoft Excel")