Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting memo field into Excel template
Message
 
À
18/10/2001 08:50:19
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00569882
Message ID:
00570233
Vues:
17
The row height of this row in worksheet probably was changed. Try to set row height to AutoFit preformatted or make it in code:
oExcel = CreateObject("Excel.Application")
With oExcel
	.Workbooks.Open('e:\testfile')
	.WorkSheets(1).Activate
	.ActiveSheet.Rows("3:3").AutoFit
	.ActiveSheet.Cells(3,1).Value = 'Very long string from VFP 0123456789'
	.ActiveSheet.Cells(3,1).WrapText = .T.    && It works for me
	.visible = .T.
EndWith
HTH,
Alex

>Unfortunatly that does not solve it..I have tried to 'wrap text' by formatting the cell before population and tried to 'wrap text' through automation after population.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform