Skip to main content
Question

Problem opening large MS Excel file in FME

  • May 21, 2019
  • 2 replies
  • 49 views
S

I have a fairly large *.xlsx Excel file (27 MB), when I attempt to open this in an FME Desktop reader, upon selecting the "parameters" button or pressing "OK" the application crashes.

If I re save the file as a *.xls file, this removes data and re-saving as an xlsx file doesn't achieve anything either.

Any Ideas?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

A quick fix might be to export it as a CSV from Excel and read that in to FME.

.xls has the negative side-effect of being limited to a max of 65536 rows so that's probably not enough.

I do think it would be a good idea to send the file in to Safe's support, maybe they can figure out why it's crashing FME.

FME rocks! \m/
fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • May 24, 2019

Hi @saqibamin Please file a case via https://www.safe.com/support/report-a-problem/ and upload your problem Excel file to ftp://ftp.safe.com/incoming (no user name / password required) https://knowledge.safe.com/articles/91858/upload-a-file-to-the-safe-software-support-ftp.html

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.