tags:

views:

19

answers:

0

I have a C# program to write to Excel which is to support files without headers and files with.

If I write where I want headers, this is fine, but in the case of reading a file without headers, I then want to write a table without headers. If I use the same headings to create a table, I still get F1, F2, F3 etc in the content.

My connection string for writing is:-

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=filename;Extended Properties="Excel 8.0;HDR=No;IMEX=0;"

Any ideas on how to lose the headers?