xlsx2csv raw output

[aborruso]

Prerequisites

• make sure you're are using the latest version by csvtk version
• read the usage

Describe your issue

• describe the problem

I have this input file, in which I have a cell whose value is 03/09/2021, that is formatted as 3-set-2021.

If I run csvtk xlsx2csv Covid\ Report\ 03\ Settembre.xlsx | head I do not have the raw value (03/09/2021), but the formatted one (3-Sep-2021).

I think it's important to have the way to export raw data: how to do it in csvtk?

Thank you

[shenwei356]

I added a new command fmtdate recently.

csvtk xlsx2csv t.xlsx \
    | csvtk fmtdate -f 9 --format "DD/MM/YYYY" --keep-unparsed

[aborruso]

As usual, thank you for all.

It would be great to have an option to export the raw values, without specifying format or field number.
In example in csvkit, there a no inferencing option.

Could I add it as feature request?

[shenwei356]

It's already discussed, and I recheck the document and codes of excelize package again but did not find any options :(

[aborruso]

once again, thank you