Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
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'

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1009554]
help
Chatterbox?
[marto]: Hey Corion, how are things?
[Corion]: Fine! It's amazing how productive I can be with a 3hour daily workload removed :)
[Corion]: My to-do emails level is at a 12-months-low of 21 , from 36 last week ;)
[marto]: I'm recovering from a bad day yesterday, on most counts :P
[Corion]: Also , I made great progress in actually writing the automation script that will run large parts of the 3hour workload now, largely by discussing what error conditions need to be handled by manual intervention and reducing these :)
[Corion]: marto: Ow! What was so bad about yesterday?

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2018-05-24 07:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?