Unix script Excel report generation

Question

I am creating an Excel file through shell script. The data should be in 4 columns, but the output data came in one column.

Post some code. you should mention in your script which column in excel sheet will hold what data — Rahul
– Rahul, Commented Jul 19, 2011 at 14:05

glenn jackman · Accepted Answer · 2011-07-19 15:37:24Z

1

Create a comma-separated values file. Perhaps, depending on your delimiters:

some process creates colon-separated data | while IFS=: read v1 v2 v3 v4; do
    printf "\"%s\",\"%s\",\"%s\",\"%s\"\n" \
        "$(sed 's/"/""/g' <<< "$v1")" \
        "$(sed 's/"/""/g' <<< "$v2")" \
        "$(sed 's/"/""/g' <<< "$v3")" \
        "$(sed 's/"/""/g' <<< "$v4")" \
    >> my_data.csv
done

answered Jul 19, 2011 at 15:37

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vivek · Accepted Answer · 2013-01-15 15:58:06Z

0

Try adding new line at the end of each statement.

answered Jan 15, 2013 at 15:58

Vivek

9102 gold badges10 silver badges27 bronze badges

Collectives™ on Stack Overflow

Unix script Excel report generation

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related