Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

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
Replies are listed 'Best First'.
Re^2: *log to *.xls
by karlgoethebier (Parson) 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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2016-02-09 07:54 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (309 votes), past polls