Property: Column for CellPosition
- Updated2024-09-12
- 1 minute(s) read
DataPlugin > Properties > Property: Column for CellPosition
Property: Column for CellPosition
Specifies the column number of a cell in a worksheet.
Object.Column
| Object | CellPosition Object with this property |
| Object.Column | 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(1,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