Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating cool reports as Excel sheets
Message
From
05/04/2010 15:09:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/04/2010 19:30:49
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01458478
Message ID:
01458798
Views:
109
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform