Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IMPORT vs EXPORT of an excel-sheet.
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
IMPORT vs EXPORT of an excel-sheet.
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01178859
Message ID:
01178859
Views:
58
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.
Next
Reply
Map
View

Click here to load this message in the networking platform