Property: Formatter for Workbook
- Updated2024-09-12
- 1 minute(s) read
DataPlugin > Properties > Property: Formatter for Workbook
Property: Formatter for Workbook
Returns the Formatter object that contains information about the format of the workbook that the DataPlugin is currently processing.
Set oCellFormatter = Object.Formatter
| Object | Workbook Object with this property |
| oCellFormatter | CellFormatter Returned object |
The following example sets the Formatter object properties that are required for reading the following values:
0,3 958,4 29,8¶ 0,4 1137,7 36,4¶ 0,5 #NV 44,1¶ 0,6 1474,6 #NV¶ 0,7 #NV 68,4¶ Dim oGroup: Set oGroup = Root.ChannelGroups.Add("MyChannelGroup") Workbook.Formatter.NoValueSign = "#NV" Dim oSheet: Set oSheet = Workbook.Sheets(1) Dim oBlock: Set oBlock = oSheet.GetCellBlock(1,1) Dim iCol, oChannel For iCol = 1 to 3 Set oChannel= oBlock.Channels.Add("Channel") Call oGroup.Channels.AddDirectAccessChannel(oChannel) Next