Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Coding Excel
Message
 
 
À
05/03/2009 18:45:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01386047
Message ID:
01386048
Vues:
65
>We have a cursor with some memo fields. We need to send this cursor to an excel spreadsheet and include the memofields.
>
>I have managed to create a spreadsheet with all the data but the fields representing the memo columns can be exceedingly wide. I haven't been able to figure out how to
>
>1. Set the width of the memo fields to be (say) 100
>2. Format the cells so that they do proper wordwrapping
>3. Set the height of the row to fully display the largest memo for that row (row heights will not be the same for all rows)

>
>(actually, I don't even know how to do this from within excel, much less with automation)
>
>I hope this is all clear. Could somebody help with the coding for the final formatting portion?
>
>Thanks to all............Rich

Rich,

I'll e-mail you the program I created using Cetin Basoz VFP2Excel as a starting point.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform