As a developer of an enterprise application I don't want to come to a full stop with an Exception when allowing my end user to upload their own Excel files for further processing,
My end users can upload an excel file that is presented to them in the gui. It is convenient to use a DataTable in my code instead of writing all cases myself. In the gui they can select different columns and map them to objects in their custom installation for synchronization. The rationale is that the duplicated columns are derived columns that makes sense by looking in the column to the left. Eg. Price_2015,Price_2016,Change,Price_2017,Change
Currently we are getting a datatable with OleDb, using the Microsoft.ACE.OLEDB.12.0 as a Provider. Now the duplicate column names gets named with a running number. Dupe, Dupe1, Dupe2 etc. This works fine since Change and Change2 from the example above isn't relevant to map and is ignored by the user.
This should be an option in ExportTableOptions, RenameDuplicateColumns. Preferebly an enum with options like RenameStrategy.Exception (default), RenameStrategy.RunningNumber vs RenameStrategy.ColumnLetter where ColumnLetter results in DupeG, DupeH, DupeM etc. instead.