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.

Count Global Template Name Qty Global Template Description
(0001) AACHTControlPanel(HNDTools) 1 © CHT AACHTControlPanel - CHT Global Control Panel (hndtools.tpl)
(0002) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx - CHT Application Styling System
(0003) HNDCMPControlPanel(HNDTools) 1 © CHT Project Builder Support - Interface to the CHT Project Builder.
(0004) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0005) INIFile(HNDTools) 1 © CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0006) VblFileNames(HNDTools) 1 © CHT VblFileNames - Incorporate variable file names and defaults into your app from the dictionary.
(6) Global Templates Found

1 - Procedure Template Type: Menu
MainWindow ()
Count Local Template Name Qty Local Template Description
(0007) AppStartSplashProcedure(HNDTools) 1 © CHT AppStartSplashProcedure - Application Splash screen earlier with an option for threaded/unthre
(0008) EmbedHNDExcelClassFunctions(HNDTools) 1 © CHT EmbedHNDExcelClassFunctions - EXCEL An Instance Of: HNDExcelClass
(0009) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0010) HandyHelpFileFetch(HNDTools) 1 © CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(6)
(0011) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0012) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(6) Local Templates Found In MainWindow

2 - Procedure Template Type: Splash
JumpStartSplash07 ()
Count Local Template Name Qty Local Template Description
(0013) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0014) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp - An application build number or version stamp.
(0015) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp - An application copyright stamp.
(0016) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0017) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0018) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(6) Local Templates Found In JumpStartSplash07

Copyright © 1996-2023 - CHT Version: [27A.02.00]
Gus M. Creces, CHT (Clarion Handy Tools)
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates