Pathologically Eclectic Rubbish Lister | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I think my recent changes to csv2xlsx warrants an update. As this is on github but not yet released, feel free to comment on the new -S/--split feature, so I can update the docs or amend the code. To explain the new options: I was faced with a 50_000 line CSV file that had logical vertical sections. The section start was clearly marked. Say you have a CSV file with orders per customer, grouped by customer, and every such section starts with Customer,34526,"Foo Tool Factory",20220601,... followed by the orders. What I wanted was to convert this CSV to Excel (as required by the other end) where each customer had its own sheet. With the new options that would be:
Start a new sheet when column A is "Customer" and then use the value in column C for the matching record as label for the sheet. -S (or --split) also supports syntax for regex/empty/undef/compare and can be stacked. Here are the highlights of changes since my previous posts: 1.49 - 2022-06-21
1.48 - 2022-05-24
1.47 - 2021-12-21
1.46 - 2021-03-24
1.45 - 2020-12-24
Enjoy, Have FUN! H.Merijn In reply to Re: The future of Text::CSV_XS - TODO
by Tux
|
|