I have a .xlsx file where only some of the columns in row 1 has names. The columns with no name is automatically named 'Column?' (This is both Caption and ColumnName).
I have previously used Excel by opening as a database via oledb and where these columns were automatically named 'F?'. No I have a backward compatibility problem because of this.
This is giving me problems as I do not feel I can just rename Column? to F? because I cannot seem to differentiate between a column actually named Column2 and one which was internally named Column2 because no name is specified in the spreadsheet.
So basically I have two questions;
- Is is possible to change the default behavior of this auto naming of columns with no name? Basically exchange 'Column' with 'F'
- Or is possible to tell if column didn't actually have a name (was blank). Then I can write the logic myself.
Thanks in advance :)