Chapter 18. EEData class

Class EEData

(ExcelExplorer 4.0)

Class to operate data of different types used in MS Excel. Excel can store information in different codings depending on used locale (UTF-16, ASCII, etc.). Therefore the string data cannot be accessed directly. Instead Excel Explorer provides functionality to convert readed data to the appropriate representation.

This class is widely used for representing Excel text data, font names and more. To obtain actual string data in the needed format use one of the methods provided by this class. Text also can contains rich text info (text formatting inside a string) and asian phonetics - see RichText and Phonetic methods for more information.

Object of this class returned by

EEWorksheet::Title
EECell::Data
EEDataRichText::Data
EEDataPhonetic::Data
EEDataPhonetic::Phonetic
EEFont::Name
EEFormat::String
EELink::Link
EELink::TextMark
EELink::Target
EELink::QuickTip

Methods

IsUnicode - Returns what coding used for the data - 16-bit Unicode or 8-bit
Plain - Returns data unmodified
HTML - Convert data to well-formatted HTML string
UTF8 - Returns data in UTF-8 coding
IsRichText - Returns whether string contains any rich text parts or not
false  RichText - Returns rich text settings for the string, if any
IsPhonetic - Returns whether asian phonetic data found for the string
false  Phonetic - Returns phonetic data if any