Prev
Merged
ExcelExplorer Manual Next
IsUnicode

Chapter 19. 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 - Get worksheet title
EECell::Data - Returns formatted cell data
EEDataRichText::Data - Returns string data of this rich text part
EEDataPhonetic::Data - Get base text
EEDataPhonetic::Phonetic - Returns phonetic string, if any
EEFont::Name - Get font name
EEFormat::String - Get format string
EELink::Link - Get hyperlink's URL or file path
EELink::TextMark - Get anchor for the URL string (symbols after # sign) or link within workbook
EELink::Target - Get target frame, if any
EELink::QuickTip - Returns quick tip (hint) for the hyperlink, if any

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

 
Prev
Merged
Home
Up
Next
IsUnicode

 
© 2002-2009 EEPHP.com
All Rights Reserved.