Re^2: Waiting ...

You exactly got the point. I had this Excel spread sheet and had to do some clever data matching. Just reading excel is to slow so I wanted to get it into a scv format. Only 2Gig of memory are not sufficient to open a 66MByte Excel File in Spredsheet::ParseExcel, So i did this directly via Win32::OLE, which opens Excel to communicate directly. However, communicating and formatting 12MByte (Actual Text data) took 2 long hours to parse.
It somehow just strikes me that is quite slow and in CSV file data rates equals 13.6kbps. Why do I think Office is a big pile of s+$%^?

Cheers,
PerlingTheUK

Comment on Re^2: Waiting ...

Replies are listed 'Best First'.
Re^3: Waiting ... by rinceWind (Monsignor) on Jun 02, 2005 at 10:25 UTC
It somehow just strikes me that is quite slow and in CSV file data rates equals 13.6kbps. Why do I think Office is a big pile of s+$%^? I wonder if OpenOffice Calc would fare any better, as it can read and write .xls format. -- Oh Lord, won’t you burn me a Knoppix CD ? My friends all rate Windows, I must disagree. Your powers of persuasion will set them all free, So oh Lord, won’t you burn me a Knoppix CD ? (Missquoting Janis Joplin)	[reply]

Replies are listed 'Best First'.

Re^3: Waiting ...
by rinceWind (Monsignor) on Jun 02, 2005 at 10:25 UTC

It somehow just strikes me that is quite slow and in CSV file data rates equals 13.6kbps. Why do I think Office is a big pile of s+$%^?

I wonder if OpenOffice Calc would fare any better, as it can read and write .xls format.

--

Oh Lord, won’t you burn me a Knoppix CD ?
My friends all rate Windows, I must disagree.
Your powers of persuasion will set them all free,
So oh Lord, won’t you burn me a Knoppix CD ?
(Missquoting Janis Joplin)

[reply]