Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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'


Comment on Re: *log to *.xls
Re^2: *log to *.xls
by karlgoethebier (Curate) 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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1009554]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2014-08-23 02:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (171 votes), past polls