Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating cool reports as Excel sheets
Message
De
05/04/2010 15:09:46
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
04/04/2010 19:30:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01458478
Message ID:
01458798
Vues:
110
>>If you have found it cool than you probably would like pivot:) It takes some time to see the power (simple pivot doesn't show it really) but once you do it is cooler I think. For example one of the features I like about pivot is that I can 'send' 200-300K rows to Excel sheet (and it may be old versions that had only 64K rows per sheet) under a second to get practically "cross tabbed" data. If you wonder where did a value come from you simply "expand details" and you get the rows that caused that aggregated value. Here is a sample:
>
>While following your suggestion I googled xlconstants.h and came to one of your postings in Foxite on how to create it from Excel.
>
>So thanks again, though Calvin is the one I really need to thank for this one.
>
>Alex

No problem:) Probably Calvin have created the object browser (drag&drop an event from events node on to a code window and voila you get eventhadler class code - for example you could hook to Excel events).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform