Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

update:

The command line function ssconvert BigFile.xlsx BigFile.csv produced the same errors as Gnumeric (unsurprising because Gnumeric uses ssconvert)

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Probably but you'll need some manual work.

xslx files are in fact ZIP files with XML data in them. SO just unpack the file and have a look inside. The format isn't something a sane mind will easily understand but it should be possible to open the sheet files, look for the Row elements and strip everything after the first few hundred.

Alternatively, you can try to open the file with Apache POI; just give Java 1GB of RAM and it might work.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.