Format Excel sheet

Shell Programming and Scripting
1

Hi,

I want to format Excel sheet through Unix script.
Format would mean bolding the data in the cell, adding clor to it etc.

Please help me if it is possible through Unix scripting?

Thanks,
Durga

2

Not possible with shell scripts. But there are Perl modules available that can help you with writing or formatting Excel binary file.

Refer CPAN for further details.

3

Not sure about a plain shell script, but you could use Perl to format Excel spreadsheets.

Search for the Perl module Spreadsheet::WriteExcel at cpan.org for the details.
Search for Spreadsheet::WriteExcel::Examples in the same website for example programs.