Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set color in Excel
Message
From
29/10/2004 02:54:59
 
 
To
28/10/2004 11:05:48
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP1
Miscellaneous
Thread ID:
00955308
Message ID:
00955690
Views:
16
>My application creates an Excel file. I need to make the 1st row of information in the Excel file appear yellow. I tried the following (for each cell):
>


Hi There:)

If you are making complex excel sheet, rather then directly coding
OLE automation, you can have look at mine 'rep2excel' tool here in downloads.
It is based on simple class wrapping cumbersome automation code pieces
for common automation calls into one line calls.

Coloring u wanted could be done by call like;

oXl.paint_box(1,1 , 1,50, 6)

and meny more things like, writing arrays, tables
drawing boxes lines inserting pictures, writing grouped reports etc.

Rgds++
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform