MySQL Forums
Forum List  »  MySQL for Excel

MySQL Excel Add-in - Better Error Messages
Posted by: Sam Benson
Date: November 24, 2019 05:43PM


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



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

Exception thrown by:

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)

Options: ReplyQuote

Written By
MySQL Excel Add-in - Better Error Messages
November 24, 2019 05:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.