Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel reports
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00523238
Message ID:
00523285
Views:
11
>Hello all:
>
>We like to compose our reports as Excel files.
>
>Currently we hard code our reports as comma separated values and then tinker with the resulting excel file to add the excel formatting using the excel object functions.
>
>Would anyone know of any third party tools that would make this easier?
>
>Bruce Strom

Actually, OLE Automation makes Excel easy to manipulate.

Here's a start:
oExcel = CREATE("Excel.Application")
oExcel.VISIBLE = .T.
oExcel.SheetsInNewWorkbook = 1
oExcel.Workbooks.Add()
There are books on this subject, but I've found it fairly easy to learn Excel's language from MS's VBAXL8.HLP file. I'm not sure where I got this from - if you can't find it, I can send it to you.
Brien R. Givens

Brampwood Systems
Previous
Reply
Map
View

Click here to load this message in the networking platform