Error with Excel Importer duing import: Document contains invalid data
When I try to import a simple Excel spreadsheet with 2 columns and 1 worksheet, I get the following error: com.mendix.core.CoreException: com.mendix.core.CoreException: Document contains invalid data and Caused by: XLS_DATA-2ndPass: an exception occured near row: 2, the exception is: replication.ValueParser$ParseException: The value in column: 2 is not valid the error message was: 2 Does anyone have any idea what might be causing this error? Thanks!
The Importer starts to count columns with 0 (zero), I presume you created the template manualy, and have column 1 and 2 defined ?
In that case simply shift to 0 & 1, that should do the trick
Note: you may have problems when trying to import Excel 2007 and higher at the moment, save as 2003/97 if you are unsure
Note: once you get it to work, the create template from Excel is realy handy
Note: remember to set the uploader to a proper files-size, as defualt it comes with "just" 5 Mb.