How to store the output of several mysql queries in two different excel sheets?

Question

I have 4 mysql queries executed by shell script like ./a.sh > b.xls. So all the data is stored as a single worksheet.

I need to slit this, so that the first 2 queries are stored in the sheet 1 and the other two in sheet 2. Also, in each sheet I would like to have the output of each query side by side, not one by one.

Is it possible to do such thing in shell scripting?

this is a bit broad. What have you tried so far? how do your queries look like? — fedorqui, Apr 09 '15 at 20:45

score 1 · Answer 1 · edited May 23 '17 at 10:24

1

Best you'd be able to do from Bash is CSV output, which means you can't have multiple worksheets. Alternatively, use Perl, Python or PHP, which do have supporting libraries for XLS output.

See also Writing to an excel sheet using Bash

edited May 23 '17 at 10:24

Community

1
1

answered Apr 08 '15 at 06:43

Paul Dixon

295,876
54
310
348

2

or php. or setup a data connection from excel to the mysql db – pala_ Apr 08 '15 at 06:52

How to store the output of several mysql queries in two different excel sheets?

1 Answers1