Skip to main content
Solved

Excel file too large to read (error)

  • February 22, 2024
  • 1 reply
  • 44 views

vxn43
Supporter
Forum|alt.badge.img+18

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?

View original
Did this help you find an answer to your question?

1 reply

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • Best Answer
  • February 22, 2024

Hi @vxn43 

 

I found this question.

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

 

Could you share your data?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings