GENERATED: JAN 12,2023 - 12:49PM
CHT Excel Class Example [V10.23.01. 27.00]

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 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


Copyright © 1996-2023
Gus M. Creces, CHT (Clarion Handy Tools)
All Rights Reserved Worldwide

chtlogo001.gif
Classes By Procedure