General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only