GENERATED: JUL 19,2019 - 1:30PM
CHT Excel Class Example [V10.19.07]

Previous Page

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 215 HNDWINDO.INC
(0003) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 39 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 215 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(3) Class Instances Found In JumpStartSplash07


Copyright © 1996-2019
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Classes By Procedure In HNDTESTEXCEL.APP