Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OK, OK, I'm also exporting to Excel
Message
 
 
À
02/06/1999 13:43:13
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00225494
Message ID:
00225752
Vues:
20
Dragan,

I'd talk directly to the Excel cells, it's quite easy.

If you want to stay _cliptext route, you can always strip off the first line:

_cliptext = substr( _cliptext, at( chr(13), _cliptext ) + 1 )

>I'm developing an app where the results should be appended to an existing Excel table. I've tried the _vfp.datatoclip() and it works perfectly, except for a couple of glitches:
>
>I'm using format 3 (delimited with tabs), which pastes fine in Excel, but it seems to need some extra formatting afterwards. Excel expects character fields to be trimmed, and it loses most of the column formatting. The appearance of the field names is another unnecessary headache - I'd have to remember to delete it afterwards.
>
>I'm thinking of building the _cliptext string in this tab/cr delimited format, trimming where necessary etc. Is this the better way to do it? Or has someone already walked this path and knows of a more efficient way?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform