Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting memo field into Excel template
Message
 
To
18/10/2001 08:50:19
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00569882
Message ID:
00570233
Views:
16
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform