Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IMPORT vs EXPORT of an excel-sheet.
Message
From
19/12/2006 10:42:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01178859
Message ID:
01178869
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform