Problems with .xls files of 1.5 GB
Problems with .xls files of 1.5 GB
Excuse me, I have some problems using .xls files on LibreOffice Calc. I tried opening the file and it worked but when I tried to save my work, it crashed. Is there any way to make it work?
It worked on Microsoft Excel on Windows 11. The file crashed the computer, but it worked passed 5 minutes and I could save my work.
You're viewing a single thread.
Have you considered not using xls as a format to store 1.5GB.
Yes, but it was a request of my boss
Tell them to use a proper database
Good luck with that.
Their boss probably doesn’t care since it opened in excel for them.
Call him special for even entertaining a 1.5GB XLS file as a real option for anything.
That’s totally nuts. Normalize the data and use Access if you have absolutely no other options - or use SQL Server Express if you want to be cheap about it and stay in the MSFT ecosystem.
@meat_popsicle @paf129 @meowthschwitz Or you could take a look at HDF5. if it's good enough for scientists all around the world it should be good for him too.
Microsoft never really meant for XLS files to get that big. Can't you use a "saner" approach, like CSV?
If it is data processing, tell them to use Octave or even better Python + spyder + pandas & matplotlib/seaborn.
Much easier processing, much less time wasted with opening more flexible, and more beautiful plots.