Object: CellFormatter
- Updated2024-09-12
- 1 minute(s) read
(General | Objects) > DataPlugin > Workbook > Object: CellFormatter
Object: CellFormatter
The CellFormatter object contains information about the format of the workbook that the DataPlugin is currently processing.
The following example reads in the data of the first worksheet and replaces the character combination NV with NoValue:
Dim oCurrSheet Set oCurrSheet = Workbook.Sheets(1) Dim oCellBlock Set oCellBlock = oCurrSheet.GetCellBlock(1,1) Workbook.Formatter.NoValueSign = "NV" Dim i, oNewChannel For i = 1 to oCurrSheet.MaxPosition.Column Set oNewChannel = oCellBlock.Channels.Add("Excel_Row"&i) Call Root.ChannelGroups(1).Channels.AddDirectAccessChannel(oNewChannel) Next