Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Code for excel model
Message
From
10/11/2005 12:14:18
 
 
To
10/11/2005 11:39:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01067207
Message ID:
01067246
Views:
13
Here are a few lines to get you started.

loObject = CREATEOBJECT("Excel.Application")
loObject.Visible = .T.
loWorkbook = loObject.Workbooks.Add()
loWorkBook.Sheets(1).Cells(1,1).Value = "HelloWorld"

You might want to consider getting the Hentzenwerke automation book.

Mace


>I just need a small code sample to do the following from VFP program: To create an Excel
>file with a single sheet, fill cells with some data from my dbf, apply colors and fonts
>to cells. Other features of Excel (like setting formulas) are not required. I do not
>want to use the command COPY TO .. TYPE XLS. Can anybody help me? Thanks in advance.
Previous
Reply
Map
View

Click here to load this message in the networking platform