Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re^3: PERL csv files to Excel

by harangzsolt33 (Hermit)
on Mar 25, 2023 at 15:04 UTC ( #11151197=note: print w/replies, xml ) Need Help??

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

I don't know. The goal is to get an XLSX file. Is it not? This thing does the job right. In the next version, I may add an LZW compressor written in pure Perl to deliver smaller content. :-)

Replies are listed 'Best First'.
Re^4: PERL csv files to Excel
by cavac (Vicar) on Mar 30, 2023 at 14:55 UTC

    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

      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://11151197]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (8)
As of 2023-06-06 09:21 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (26 votes). Check out past polls.