Group Abstract Group Abstract

Message Boards Message Boards

Import large Excel sheets?

12 Replies

Friends: success! I saved the file as csv and I could import it without problems. The morale: it is still easier in csv...

As some asked, indeed the Excel file had some columns with extra formatting and non-ascii characters, which must be the source of the problems

Thanks to all Francisco

POSTED BY: Eric Smith
Posted 7 years ago

We're working hard to make XLS and XLSX as robust of an option as CSV, so use whichever format best suits your needs!

POSTED BY: Sean Cheren
POSTED BY: Eric Smith
Posted 7 years ago

Hi Eric, keep your eyes peeled for the next version of Wolfram Language, the bug involving sheets with charts in XLS and XLSX has been solved, among many other important bug fixes.

POSTED BY: Sean Cheren

Hi Sean. I am using 11.3, Windows 10. The error message I get is: Import::fmterr: Cannot import data as XLS format. $Failed

Posted 7 years ago
POSTED BY: Kyle Martin
Posted 7 years ago

Like Kyle mentioned there are some minor bugs with non-ASCII characters on filepaths and perhaps in the file in XLS in 11.3 (only on Windows) which are absolutely being addressed in the next version.

Remember that increasing Java won't help in 11.3 since XLS/XLSX import no longer uses Java!

POSTED BY: Sean Cheren
Posted 7 years ago
POSTED BY: Sean Cheren

Francisco,

I suggest saving the excel spreadsheet as a CSV file and import it into Mathematica from the CSV. Version 11.3 has some big CSV import improvements and there are new options that will handle any data format (ie strings with or without quotes, etc)

Regards

Neil

POSTED BY: Neil Singer
Posted 7 years ago

Hi Neil,

11.3 got some big excel updates as well (it no longer uses Java in 11.3), with even more improvements to come in the next version!

-S

POSTED BY: Sean Cheren

Many thanks Neil. Will try your suggestion and inform if it works.

Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard