ExcelGetCellAsString

Structure

ExcelGetCellAsString(iRow,iCol)

Type

Function

Description

This function returns the string value of the cell or formula result, if possible. It will throw an exception otherwise.

Parameters: 2

iRow = The row of the cell. 1 is the top row.

iCol = The column of the cell. 1 corresponds to column A

Example

Try

ExcelNewFile(3,"v2003")

ExcelGetSheetByIndex(1)

ShowMessage(ExcelGetCellIsString(1,1)) 'Returns "0"

ExcelSetCellAsString(1,1,"2021-08-11")

ShowMessage(ExcelGetCellAsString(1,1)) 'Returns "2021-08-11"

Except

ShowMessage(LastExceptionMessage)

End Try