Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Sheet Formatting
Message
From
16/01/2006 00:05:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Excel Sheet Formatting
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01087027
Message ID:
01087027
Views:
75
Dear Experts

I use following method to export data to Excel
SELECT master1
COPY to C:\gin_exp.xls type xls FIELDS LIKE C*,D* EXCEPT CREDIT,DR_CR

RELEASE ALL LIKE Lo*

loExcel = createobject("Excel.Application")
loWorkbook = loExcel.workbooks.open('C:\gin_exp.xls')
loSheet = loWorkbook.sheets(1)
1) How to make sheet rows height=25
2) How to insert three blank rows at the top of loSheet
3) How to apply following format on loSheet.Range("A7:C10")

FontColor = RGB(255,0,0)
FontSize = 12
FontBold = .T.
DrawBorder= "xlContinuous:xlMedium")

Please Help
Next
Reply
Map
View

Click here to load this message in the networking platform