Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Sheet Formatting
Message
De
16/01/2006 00:05:00
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Excel Sheet Formatting
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01087027
Message ID:
01087027
Vues:
76
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform