Shell Programming and Scripting

Hi,

I have a code which gives me different values all in a same line. what do i change to make the output have each value in each cell.

code:
echo $user $firstname $lastname $address

done |
tee userinfo.xls

i want the $user value to be in first cell of excel, $firstname in the second cell etc.

Hello,

You are trying to write an xls file like a flat file. When you open up excel for this file, it picks the data and puts all in 1 cell.

1 (bad) way out is to save the file as csv. Excel would read it automatically as u want, using [space] or comma as delimiter.

It is advised that u use some program to write an excel sheet, using some language like java etc. I ve done this using java.

If it can be done in any other way, others maybe able to help you. I would like to know that too .

Regards,
HKansal

Yeah, you need to write out the file as a comma-delimited file and name it with a '.csv' extension:

Code:

echo $user, $firstname, $lastname, $address > name.csv

This will put the columns into each cell in csv/xls.

Thanks a bunch giannicello. It works perfectly fine.