Shell Command for executing query

[MuraliDharan V]

Dear Experts,

Is that anyway i can write my query resultset to excel file with field alignments.

I came across the command,
mysql -u <username> -h <hostname> -p -e " SELECT FIELD1,FIELD2 FROM TABLE" > /var/www/test.xls

I got the result in excel but the field values are aligned automatically, is that any way i can assign field values alignment like 'Left' ,' Right' or 'Justify'.

Help me in this..

Thanks,
Murali.V