Collection: DirectCellChannels
- Updated2024-09-12
- 1 minute(s) read
(CellBlock | Collections) > Collection: DirectCellChannels
Collection: DirectCellChannels
Collection of all DirectAccess channels. You can use the DirectCellChannels collection to delete or to add DirectAccess channels.
The following example reads in the values of the first worksheet columnwise and saves the values in channels from the first channel group:
Dim oCurrSheet Set oCurrSheet = Workbook.Sheets(1) Dim oCellBlock Set oCellBlock = oCurrSheet.GetCellBlock(2,1) Dim i, Name, oNewChannel For i = 1 to oCurrSheet.MaxPosition.Column Name = oCurrSheet.GetCellValue(1,i) Set oNewChannel = oCellBlock.Channels.Add(Name) Call Root.ChannelGroups(1).Channels.AddDirectAccessChannel(oNewChannel) Next