Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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 (Monsignor) 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]
[choroba]: The documentation just says the second argument should be "characters"

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2018-02-22 17:05 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (295 votes). Check out past polls.