Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does COPY TO TYPE XLS Still Output Field Names in VFP7?
Message
 
 
À
06/08/2001 16:44:34
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00540385
Message ID:
00540414
Vues:
18
>>>Does anyone know if the COPY TO TYPE XLS still puts the field names as the first row of the spreadsheet in VFP7?
>
>>If you don't want the field names than you can use
COPY TO Myfile.csv DELIMITED
The Excel knows how to open CSV files.
>
>And if you give the target file the extension XLS, you can even open it in Excel, so that's *almost* cool. Unfortunately there's all those quotes and it stuffs all the data in the first column of cells.

In VFP 7 the following command creates a comma delimited file w/o double quotes
COPY TO Myfile.csv DELIMITED WITH "" with CHARACTER ,
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform