Property: Row for CellPosition
- Updated2024-09-12
- 1 minute(s) read
DataPlugin > Properties > Property: Row for CellPosition
Property: Row for CellPosition
Specifies the row number of a cell in a worksheet.
Object.Row
| Object | CellPosition Object with this property |
| Object.Row | LongInteger with read access |
The following example reads in the values of the first worksheet columnwise from the first row of the first column and saves the values in channels of the first channel group:
Dim oCurrSheet Set oCurrSheet = Workbook.Sheets(1) Dim oCellBlock Set oCellBlock = oCurrSheet.GetCellBlock oCellBlock.Position.Row = 1 oCellBlock.Position.Column = 1 Dim i, oNewChannel For i = 1 to oCurrSheet.MaxPosition.Column Set oNewChannel = oCellBlock.Channels.Add("ExcelRow_"&i) Call Root.ChannelGroups(1).Channels.AddDirectAccessChannel(oNewChannel) Next