I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors.
I received a 35MB spreadsheet. It opened in Gnumeric after 5 minutes with errors, and it hasn't opened in Open Office (killed after 20 min.) even after I gave the "soffice" process top priority (niceness = -20).
What is the best way to deal with such a file? Is it possible to extract a subset of the first few hundred lines so that I can work out the script that I will need to use to parse the entire file?
The command line function
ssconvert BigFile.xlsx BigFile.csv produced the same errors as Gnumeric (unsurprising because Gnumeric uses