csv2xlsx stores any number (ints and floats) as text in xlsx. Afterwards, it is not possible to calculate with it except if all affected cells are converted. It would be created if numbers are stored as numbers.
How to reproduce: echo 89.173 | csvtk -H csv2xlsx -o numberAsText.xlsx
shenwei356
commented
2 years ago
csv2xlsx stores any number (ints and floats) as text in xlsx. Afterwards, it is not possible to calculate with it except if all affected cells are converted. It would be created if numbers are stored as numbers.
How to reproduce:
echo 89.173 | csvtk -H csv2xlsx -o numberAsText.xlsx