Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: *log to *.xls

by tobyink (Abbot)
on Dec 19, 2012 at 12:33 UTC ( #1009554=note: print w/replies, xml ) Need Help??

in reply to *log to *.xls

Up until Excel 2007, Excel had a limit of 65,536 rows (and 256 columns) for a spreadsheet. Excel 2007 raised this limit to 1,048,576 rows (and 16,384 columns).

The column limit is unlikely to be problematic, but log files can easily contain millions of lines.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'

Replies are listed 'Best First'.
Re^2: *log to *.xls
by karlgoethebier (Prior) on Dec 19, 2012 at 18:41 UTC
    "Excel 2007 raised this limit to 1,048,576 rows (and 16,384 columns)"

    Yes, shure. But who likes to have a spreadsheet with 1,048,576 rows ;-)

    I'm just wondering about how i would do something like this.

    Even splitting such a large log by timestamp into different worksheets is no fun.

    But what else? Perhaps putting the whole stuff into a database and write some stored procedures that do the dirty mangle job(s) a.s.o...?

    Best regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1009554]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (12)
As of 2017-07-25 14:20 GMT
Find Nodes?
    Voting Booth?
    I came, I saw, I ...

    Results (373 votes). Check out past polls.