Titus Information Systems InterfaceExcel Class

Titus Information Systems, Inc.

Standard Library
InterfaceExcel Class

This class handles Dynamic Data Exchange (DDE) as a client to a Microsoft Excel spreadsheet. Please note that Microsoft Excel must be running and a spreadsheet file with a worksheet of the specified name must be open for this class to function properly. The public member functions and variables are as follows:

InterfaceExcel::InterfaceExcel(): This is the constructor. It initializes the data members.
BOOL InterfaceExcel::Open(CString WorkSheet): This member function creates a DDE session with the specified WorkSheet of Microsoft Excel. Please note that Microsoft Excel must be running and a spreadsheet file with a worksheet of the specified name must be open for this member function to be successful. The value of the function is TRUE if the session is successfully created. If any of the API functions are unsuccessful, the value of the function is FALSE.
BOOL InterfaceExcel::Open(): This member function performs an InterfaceExcel::Open("Sheet1").
BOOL InterfaceExcel::Write(int Row, int Column, CString Text): This member function performs a "poke" to the open worksheet at the specified Row and Column with the data in Text. The value of the function is TRUE if the data transfer is successful. If any of the API functions are unsuccessful, the value of the function is FALSE.
BOOL InterfaceExcel::Read(int Row, int Column, CString&Text): This member function performs a "peek" to the open worksheet at the specified Row and Column and puts the result in Text. The value of the function is TRUE if the data transfer is successful. If any of the API functions are unsuccessful, the value of the function is FALSE.
BOOL InterfaceExcel::Close(): This public member function closes the DDE session. The value of the function is TRUE if the session was successfully closed. If any of the API functions are unsuccessful, the value of the function is FALSE.
CString InterfaceExcel::ErrorMessage: This data member contains the text of the last error. It may be displayed in a message box for the user or written to a log file.