GetOOXMLSpreadsheetRows (open)

Export the first sheet of an Excel (XLSX) file

Syntax

LOADLIB "wh::ooxml/spreadsheet.whlib";

RECORD ARRAY FUNCTION GetOOXMLSpreadsheetRows(BLOB xlsxdoc, RECORD options)

Parameters

BLOB xlsxdoc

Document to load

RECORD options

Options

alltostring

Return all columns as strings (defaults to TRUE)

dotrimwhitespace

Trim all whitespace from strings (defaults to true)

floatmode

How to convert numbers: "integer", "money" (rounds to money and omits trailing zeroes) or "float"

FUNCTION PTR onprogress

Callback that will periodically receive progress records as we import the file. Progress records contain 'cur'(rent) row (0-baesd) and 'total' and do not count the header row

processheaders

Process the first row as headers (defaults to TRUE)

Return value

RECORD ARRAY

Extracted rows