ExcelSheet::ExportRows (open)

Return the rows in an excel sheet

Syntax

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

RECORD ARRAY FUNCTION ExportRows(RECORD options)

Parameters

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