Table of Contents

TXlsFile.GetListOfValues Method

This method will return all numeric values in the collection of ranges, and the rest of cells which are not numeric in nonNumericCells. It is for internal use.

Syntax

Unit: FlexCel.XlsAdapter

procedure TXlsFile.GetListOfValues(const ranges: TArray<TXlsCellRange>; const values: TFList<Double>; const duplicates: HashSet<TCellRowAndCol>; out vSum: Double); override;

Parameters

<-> Parameter Type Description
const ranges TArray<​TXls​Cell​Range> Ranges where we want to get the cell values.
const values TFList<Double> List where we will return all values in the cells.
const duplicates HashSet<TCellRowAndCol> If not null, this list will be filled with all the cells which contain duplicated values.
out vSum Double Sum of all values in the range.

See also