This application illustrates a class called HNDEXCELCLASS which provides a programmatic interface to Microsoft Excel for creating and opening documents. The HNDEXCELCLASS class is introduced to the procedure via a template called EmbedHndExcelClassFunctions. Various controls are provided on the window that call into class functions to illustrate HNDEXCELCLASS features. Supplementary files required by this application are: people.xls, people_import.csv, people_export.csv Several new functions were added into the HNDEXCELCLASS. These are called: EXCEL.OpenCSV() which opens a comma delimited .CSV file, as well as function EXCEL.SaveAscSV() which provides an option to export and save to different CSV formats. The application contains commentary and example code to show how export and import are accomplished. |
PROCEDURE (1): MainWindow (Procedure Template: Menu) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | EXCEL | HNDExcelClass | HND | 157 | HNDEXCEL.INC |
(0002) | HWin | HNDWindow | HND | 205 | HNDWINDO.INC |
(0003) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0004) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(4) Class Instances Found In MainWindow | |||||
PROCEDURE (2): JumpStartSplash07 (Procedure Template: Splash) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HTellMe | HNDWindow | HND | 205 | HNDWINDO.INC |
(0002) | HWin | HNDWindow | HND | 205 | HNDWINDO.INC |
(0003) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0004) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(4) Class Instances Found In JumpStartSplash07 | |||||