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?