>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