(Excel) Decimal Integer List Encoding

The "decList" encoding was added in Chilkat v9.5.0.66 to encode and decode binary bytes from comma-separated decimal integers.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: This example requires Chilkat v9.5.0.66 or greater.


byteVals = "84,104,101,32,116,114,117,101,32,115,105,103,110,32,111,102,32,105,110,116,101,108,108,105,103,101,110,99,101,32,105,115,32,110,111,116,32,107,110,111,119,108,101,100,103,101,32,98,117,116,32,105,109,97,103,105,110,97,116,105,111,110,46"

' Demonstrate encoding/decoding comma-separated decimal integrs to/from binary.
Dim binData As Chilkat.BinData
Set binData = Chilkat.NewBinData
Dim success As Boolean
success = binData.AppendEncoded(byteVals,"decList")

' Examine the data in hex
Debug.Print "HEX: "; binData.GetEncoded("hex")

' Decode to a StringBuilder
Dim sb As Chilkat.StringBuilder
Set sb = Chilkat.NewStringBuilder
success = sb.AppendBd(binData,"us-ascii",0,0)

' The bytes were actually the us-ascii char values for the string
' "The true sign of intelligence is not knowledge but imagination."
Debug.Print sb.GetAsString()

' Now get the bytes in decimal list format again:
Debug.Print binData.GetEncoded("decList")

' The output of this example is:
' HEX: 5468652074727565207369676E206F6620696E74656C6C6967656E6365206973206E6F74206B6E6F776C656467652062757420696D6167696E6174696F6E2E
' The true sign of intelligence is not knowledge but imagination.
' 84,104,101,32,116,114,117,101,32,115,105,103,110,32,111,102,32,105,110,116,101,108,108,105,103,101,110,99,101,32,105,115,32,110,111,116,32,107,110,111,119,108,101,100,103,101,32,98,117,116,32,105,109,97,103,105,110,97,116,105,111,110,46