Default name for columns with no name

Mar 20, 2014 at 10:09 AM
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;
  1. Is is possible to change the default behavior of this auto naming of columns with no name? Basically exchange 'Column' with 'F'
  2. 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 :)
Mar 31, 2014 at 7:42 AM
Ok, after reading the documentation I created a patch with the id; 16126. Hopefully it will accepted as my issue is now resolved by it.
Marked as answer by bleze on 3/31/2014 at 12:42 AM
Mar 31, 2014 at 10:41 AM
Thanks for that!
Mar 31, 2014 at 10:42 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.