 | ExcelHelperGetCellRangeValues Method |
Retrieves the values of a range of cells from the specified worksheet.
Namespace: ema3d.Api.V25.ResultsAssembly: ema3d.Api.V25 (in ema3d.Api.V25.dll) Version: 0.0.0.0
Syntaxpublic string[,] GetCellRangeValues(
string sheetName,
string startCell,
string endCell
)
Public Function GetCellRangeValues (
sheetName As String,
startCell As String,
endCell As String
) As String(,)
public:
array<String^,2>^ GetCellRangeValues(
String^ sheetName,
String^ startCell,
String^ endCell
)
member GetCellRangeValues :
sheetName : string *
startCell : string *
endCell : string -> string[,]
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
StringA 2D array of strings containing the values of the cells in the specified range.
ExceptionsException | Condition |
---|
ArgumentException | Thrown if the sheet name, start cell, or end cell is null or empty, or if the specified range is invalid. |
See Also