Method: GetCellValue for Sheet
- Updated2024-09-12
- 1 minute(s) read
DataPlugin > Methods > Method: GetCellValue for Sheet
Method: GetCellValue for Sheet
Reads out the content of a worksheet cell.
vGetCellValue = Object.GetCellValue(Row, Column)
| Object | Sheet Object with this method |
| Row | LongInteger Specifies the row number of the cell. |
| Column | LongInteger Specifies the column number of the cell. |
| vGetCellValue | Variant Contains the value that has been read out. |
The following example reads out the content of the cell of the first row in the first column and interprets the contents as the channel name:
Dim oCurrSheet: Set oCurrSheet = Workbook.Sheets(1) Dim oCellBlock: Set oCellBlock = oCurrSheet.GetCellBlock(2,1) Dim Name: Name = oCurrSheet.GetCellValue(1,1) Dim oNewChannel: Set oNewChannel = oCellBlock.Channels.Add(Name) Call Root.ChannelGroups(1).Channels.AddDirectAccessChannel(oNewChannel)