MySQL Excel Add-in - Better Error Messages

[Sam Benson]

Hi

Can the MySQL Excel Addin provide better error messages?


And error message like the one below is good but also useless as it doesn't say which row (or column) is not correctly formatted (Apologies as I don;t know how to format for this forum)

Trying to load some 30,000 rows and hard to figure out which row/s need fixing when the error messages are a little less than helpful

Ideas?

Thanks




Exception message:
Input string was not in a correct format.

Exception thrown by:
MySqlDataTable.AddExcelData

Stack trace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Convert.ToDecimal(String value, IFormatProvider provider)
at System.Data.Common.DecimalStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)