Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IMPORT vs EXPORT of an excel-sheet.
Message
De
19/12/2006 10:42:04
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01178859
Message ID:
01178869
Vues:
19
>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 ???

It's by design I think. Foxpro is sending 'data' and in excel data has header line.
Using automation you could just send the content (rows 1-5).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform