ExcelSheet::ExportRowsToCallback (open)

Send all rows to a callback function

Syntax

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

MACRO ExportRowsToCallback(FUNCTION PTR callback, RECORD options)

Parameters

FUNCTION PTR callback

Callback to invoke with a VARIANT ARRAY of cells for each lines. Should return TRUE to continue processing, FALSE to stop

RECORD options

Optional options

alltostring

Convert all data to strings

dotrimwhitespace

Trim all whitespace from strings (defaults to true)

floatmode

How to convert numbers when converting to strings: "integer" (the default) rounds to integer values or "money" rounds to money and omits trailing zeroes