SIMPLEXLS – User guide - Lone
Contents
1. Northwind Inc GETCAPTION The software tries to fill the headers with the database caption property to make it more understandable If you know that the source does not contains such property e g in case it is a cursor you should keep it false to ensure quicker converting otherwise set it true oSimpleXLS getcaption T GROUPBACKCOLOR Background color of the group header and group footer sections oSimpleXLS groupbackcolor 255 255 0 GROUPBY Comma separated list of group by field s oSimpleXLS groupby customerid GROUPHEADER Comma separated list of those field s which should be appear in the group header but not groupby conditions therefore not listed in the groupby property oSimpleXLS groupheader shipname shipcountry HEADERBACKCOLOR Background color of the header and footer of the list oSimpleXLS headerbackcolor 255 0 0 ITALIC Comma separated list of italic formatted field s oSimpleXLS italic requireddate MYCAPTION Title of the Excel sheet oSimpleXLS mycaption Sample list 2 4 Lone soft gyviteli Tan csad Bt www lonesoft hu MYDATASOURCE The source table or cursor name if empty working on the selected alias oSimpleXLS mydatasource customers RIGHTORDERED Set it true if your source is already ordered according to the group by fields This makes the converting quicker as the program reorders the source data by the groupby property2. Lone soft gyviteli Tan csad Bt www lonesoft hu SIMPLEXLS User guide Thank you for buying SIMPLEXLS Please study the user guide carefully In case you still have any questions or you find any bugs don t hesitate to write an e mail error lonesoft hu and we will solve the problem as soon as it is possible Basic functions SIMPLEXLS class can convert grouped and formatted XLS file by using also SUM function based on any kind of table cursor or view It makes the converting quicker and the result excel file is more user friendly than other applications Lets see how easy it can be SET CLASSLIB TO simplexls progress bar class SET CLASSLIB TO alap additive SELECT 0 USE HOME samples northwind orders dbf oSimpleXLS CREATEOBJECT sSimplexls oSimpleXLS SimpleXLs Then the process begins which you can follow on a progress bar By pressing ESC you can quit Parameters BOLD Comma separated list of bold formatted field s oSimpleXLS bold customerid shipname DETAIL Comma separated list of detail field s if empty all fields appearing oSimpleXLS detail orderdate requireddate shippeddate freight 1 4 Lone soft gyviteli Tan csad Bt www lonesoft hu FILTERDESC Information text about the filter conditions appears on the top of XLS oSimpleXLS filterDesc All records FIRM User name oSimpleXLS filterDesc
3. ations to indicate a status of a procedure o Working 100 ed 39 266 679 00 00 10 ET CLASSLIB TO alap additive i THIS mydatasource OUNT FOR NOT DELETED TO m nMax_ Initializing process bar Processbar CREATEOBJECT processbar Processbar label3 CAPTION Working Processbar VISIBLE T x other events Processbar nMax m nMax 3 Processbar Fast T Processbar STATUS T Processbar nCurrent 0 0O OF U gt O O00 oo0o0o o oProcessbar nCurrent oProcessbar nCurrent 1 Set the number of steps of the procedure in the oProcessbar nMax initial steps record number closing steps After every step increase the value of the oProcessbar nCurrent The nCurrent_assign method moves the processbar if it gets to nMax closes the object Parameters FAST Moves the graphical indicator cracked fast or smooth slow STATUS Show percent max item current item elapsed time or only the graphical indicator 4 4
4. for the proper result because default rightordered f oSimpleXLS rightordered t SUM Comma separated list of summed field s The program uses SUM function of Excel so if the user changes a number on the sheet the whole workbook will be recalculated This kind of Excel table is more easy to use than those converted from frx oSimpleXLS sum freight UNDERLINE Comma separated list of underlined field s oSimpleXLS italic requireddate XLSNAME If empty the result Excel will appear If filled with a proper filename Excel will be saved but will not appear oSimpleXLS XLSName c sample xls Let see the code that created sample xls SET CLASSLIB TO simplexls SET CLASSLIB TO alap additive SELECT 0 USE HOME samples northwind orders dbf oSimpleXLS CREATEOBJECT sSimplexls oSimpleXLS getcaption t oSimpleXLS detail orderdate requireddate shippeddate freight oSimpleXLS groupby customerid oSimpleXLS groupheader shipname shipcountry oSimpleXLS bold shipname oSimpleXLS italic requireddate oSimpleXLS sum freight oSimpleXLS SimpleXLs In case of huge databases ignoring formatting and or setting the background color white 255 255 255 makes the process quicker 3 4 Using processbar class Lone soft gyviteli Tan csad Bt www lonesoft hu You can use processbar class for your own applic
Download Pdf Manuals
Related Search