Can't open an xlsx file
- Thomas Timbul
Problem
After you open a particular xlsx file (doesn’t apply to other formats), Price Checker gets stuck on “Your file is being read and analysed”, takes a long time, or never finishes.
You may see an error message about “Java Heap Error”.
Solution
It is likely that the Excel file contains more rows than you think, and therefore opening and analysing it ends up consuming more memory than is available in your system.
The best way to address this is to fix the input file:
Open the file in Excel or other suitable spreadsheet software.
Select your data (and only your data, not any surrounding cells) and copy them.
Paste the data into a new sheet/tab or into a brand new file.
Use the new file as input.
The xlsx format saves cell formatting and can contain millions of empty rows. Delete them to resolve this issue.
If you save to a new tab/sheet within the same file, make sure you leave this as the active tab, i.e. it should be the one that’s selected and open before saving.
If the problem persists
Split your file into smaller parts and run them one after the other. Just save half the rows including headers and try again. Repeat to create an even smaller slice if the problem persists. If you are unable to resolve the problem in this way, please create a support request.