Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^4: PERL csv files to Excel

by cavac (Vicar)
on Mar 30, 2023 at 14:55 UTC ( #11151350=note: print w/replies, xml ) Need Help??

in reply to Re^3: PERL csv files to Excel
in thread PERL csv files to Excel

As is often the case in such cases, i'm the person with the strange opinion here. I like what you have done here.

No, that the code itself. There are better ways, like using tested and more feature-complete modules instead of your messy spaghetti code.

What i like is that you took the initiative, looked into how the file format actually works and in the process learned something!

And what's more: I learned something: I could stuff the generation of Excel files into some Template Toolkit file(*), damn the incompatibilities and full speed ahead. If someone uses Excel, they are used to pain and suffering and random error messages popping up anyway.

(*) Which would come in quite handy if i could pull that off. That would mean i get relatively "free" XLSX generation in one of my web tools without having to implement a second data handling module.

PerlMonks XP is useless? Not anymore: XPD - Do more with your PerlMonks XP

Replies are listed 'Best First'.
Re^5: PERL csv files to Excel
by Fletch (Bishop) on Mar 30, 2023 at 17:03 UTC

    WRT using TT I've done something similar aeons ago using it to interpolate values from a CSV into an OpenOffice SXC (similarly structured zip'd XML files; the workflow allowed for a special template SXC file with embedded TT markup in the desired cells) in order to be able to call OO's automation routines to evaluate embedded functions before exporting the resulting file as an xls(x? been a while). It worked fairly well for quite some time.

    The cake is a lie.
    The cake is a lie.
    The cake is a lie.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (4)
As of 2023-05-30 17:41 GMT
Find Nodes?
    Voting Booth?

    No recent polls found