Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Export to Excel With Coloured Rows
Message
 
À
11/02/2013 05:02:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01565703
Message ID:
01565722
Vues:
56
Harsh:
Here's the code that you need. This code executes after you have exported the data to Excel, and opened the Excel file in FoxPro via automation.
FOR x = 1 TO oExcel.ActiveSheet.UsedRange.Rows.Count
	IF (filed remarks of my Table has "N" Value)
		oExcel.ActiveSheet.Rows(x).Font.Color = -1003520 && This is the code for blue.  Look up the code for your shade of red.
	ENDIF
ENDFOR
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform