ExcelSetCellAsString

Structure

ExcelSetCellAsString(iRow,iCol,sValue)

Type

Procedure

Description

This procedure sets the indicated cell of the current sheet to the string value.

Parameters: 3

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

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

sValue = The string to set the cell to.

Example

Try

ExcelNewFile(3,"v2003")

ExcelGetSheetByIndex(1)

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

ExcelSetCellAsString(1,1,"This is a string")

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

Except

ShowMessage(LastExceptionMessage)

End Try