Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formating Excel
Message
De
15/08/2005 07:49:39
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Formating Excel
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MySQL
Divers
Thread ID:
01040911
Message ID:
01040911
Vues:
81
Hello Everybody

How to select rows,columns,cells with parameters ?????

I create a excel worksheet from my cursor (simplified example)
l_row = 1
l_col = 1
select cursor
scan
OleApp.Cells(l_row,l_col).Value =xxxx
l_row = l_row + 1
.
.
.

if .....
l_col = l_col +1
i_row = 1
endif
endscan

Now i want to format a block of rows or columns or cells in my scan

This would be the excel syntacs:

Oleapp.Rows("3:3").Select
Oleapp.Selection.Font.Bold = .T.
Oleapp.Selection.Font.size = 12

I don't know how to pass parameters to the select line
Oleapp.Rows("l_row:l_row").Select does not work !


Any help welcomed
Best regards
Albert
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform