Hi friends. I am having troubles with importing relatively large Excel sheets --not huge, but rather large (60 000+ rows, 150 columns).
When I try to import the database as a whole, I get the following error:
Import::fmterr: Cannot import data as XLS format.
I separated the Excel file into several files, one per column. If I try to import them manually, I can, but if I try to import them programmatically (Map[Import, names], where names are the names of each column file) I get the same error messages,
I increased the available memory, to no avail
<< JLink`;
InstallJava[];
ReinstallJava[JVMArguments -> "-Xmx1024m"]
Any tips or assistance are very much appreciated
Francisco
