Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IMPORT vs EXPORT of an excel-sheet.
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
IMPORT vs EXPORT of an excel-sheet.
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01178859
Message ID:
01178859
Vues:
59
Hello all,

I noticed the following.

When I IMPORT a simple .XLS file, say containing 5 filled rows, I get a table containing 5 records. The fields are named 'A','B','C', etc.
So far so good.

OK.
Now I EXPORT this same table as a new .XLS sheet, and there I get a sheet with 6 filled rows.
The first row contains the names of the DBF-rows.
Rows 2-6 contain the original data.

Is this by design, or is it a flaw.
Can I control this from VFP, meaning I do no want that extra first row.

Or must I (programmatically) open the xls-sheet and delete row(1).

Anyone ???
email recepto, ergo sum.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform