Import data from Excel files
There are a lot of importer plug-ins that can import data from CSV files. Typically, the CSV files are starting out as Excel files on some computer before being save as CSV and uploaded to BASE. The problem is that Excel is not very transparent when it comes to things such as character encoding, date formats, etc. It is not uncommon that users have to try multiple times before the file can be imported by BASE.
It would be nice to have support for reading data directly from Excel files. An approach to this has already been done in Reggie (http://baseplugins.thep.lu.se/ticket/1110). But this is for a special case only. It would be nice to, for example, add support directly to the
FlatFileParser implementation. This would make it possible for all existing plug-in (I think they are all based on the
FlatFileParser) to use CSV or Excel files without any code changes as long as the data is in the first sheet. With some minor changes it would also be possible to read multi-sheet Excel files and to provide direct access to cells so that data doesn't have to be converted via strings.