Click or drag to resize

ExcelHelperGetCellRangeValues Method

Retrieves the values of a range of cells from the specified worksheet.

Namespace: ema3d.Api.V25.Results
Assembly: ema3d.Api.V25 (in ema3d.Api.V25.dll) Version: 0.0.0.0
Syntax
public string[,] GetCellRangeValues(
	string sheetName,
	string startCell,
	string endCell
)

Parameters

sheetName  String
The name of the worksheet containing the range of cells.
startCell  String
The cell reference of the starting cell (e.g., "A1") of the range.
endCell  String
The cell reference of the ending cell (e.g., "C3") of the range.

Return Value

String
A 2D array of strings containing the values of the cells in the specified range.
Exceptions
ExceptionCondition
ArgumentExceptionThrown if the sheet name, start cell, or end cell is null or empty, or if the specified range is invalid.
See Also