Information générale
Catégorie:
Produits tierce partie
Terry,
I believe, that your reply should go to the originator, but not to me.
>In addition - sometimes its faster to VFP copy a cursor XLS - and then open the spread sheet and make your column header changes - rather than iterate through each record and formatting each cell.
>
>>Examples are below, though they may not represent what you actually need.
>>Try to record a macro in Excel when formatting columns/cells as you need, and translate vba code to foxpro.
>>
>>Objexcel.Range("b4").NumberFormat = "0;-0;;@"
>>Objexcel.columns("B:B").NumberFormat ="$#,##0.00_);[Red]($#,##0.00);;@"
>>
>>>Does anyone have a code example of formatting a cell through automation?
>>>
>>>I create spread sheets through automation and unfortunately, some columns have numbers with leading zeros. The leading zeros are removed unless I change category to text in the Format Cells dialog.
>>>
>>>Thanx.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement