Out of curiosity, since you're on Windows, do you happen to have Excel installed?

If so, you could always try using Win32::OLE to control Excel for your manipulation of the Excel file. Of course, I don't think that I personally have ever tried using Excel to open a 1 GB sized file before.