Convert csv to xls

Shell Programming and Scripting
1

Hi
I want convert report.csv file to report.xls with bash script.
csv file have pip delimiters.

FYI: I read about ssconvert but seems does not support delimiter option, mess up xls file.
Is there any other idea?

Thanks

2

this man ssconvert seem to have option:

       separator
              The string used to separate fields. Defaults to space.

with example:

ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls statfuns.txt

btw, what's pip delimiters?

1 Like
3

each csv file have separator like tab, semicolon,..,
This file use pip “|” as separate each columns.

4

ok, it's probably pipe (not pip).
Does the previous reply help?

5

Give me this error
Unable to guess exporter to use for 'file:///tmp/report.csv'.
Try --list-exporters to see a list of possibilities.

6

I'm no expert in ssconvert - you'll need to go over the quoted man pages and figure out what's missing,

7

This work for me

tr '|' '\t' <report.csv | ssconvert fd://0 report.xls
8

why do you need tr if you can specify optional delimiter?
hopefully you don't have pipes embedded into the quoted fields...
But whatever makes you happy :wink:

9

Not work as expected then i try tr.

10

I see - that makes lots of sense.
Good luck!

1 Like
11

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.