Solved

Excel file too large to read (error)

Forum|Forum|1 year ago
February 22, 2024
1 reply
66 views

+18

vxn43
Supporter

I have an Excel 365 .xlsx spreadsheet that I am trying to read into a FME 2021 workspace. When I try to read it, it gives me an error message:

|ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to CSV, formulas and formatting will be lost...

T

I cannot change the spreadsheet to a .xls, it has to remain a .xlsx.

Any ideas on how to solve this?

The spreadsheet I need to read is 22mb with approximately 93,000 records.

Best answer by danilo_fme

Hi @vxn43

I found this question.

Excel reader: Could not open file, file is too large... | Community (safe.com)

Could you share your data?

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.