Shell Programming and Scripting

Hi,

1st post...

Done a quick search for this so apologies if I've missed it.

Basically I want to output and and append several values generated by a csh script direct to an xls openoffice file, rather than send to txt file and then physically copy and paste to xls file.

Already I send to txt file and open txt file & xls file using:

echo "BLUE" >> $resfile
te $resfile &
soffice -calc file_name &

where resfile is the path to text file.

The csh script is designed to run daily/weekly, and the xls file will chart the changes in these values over time.

Any thoughts? Only using csh, as I'm a unix beginner!!

thanks

not fer total sure.... but i don't believe it can be done that way...
don't know the soffice xls format...

however, some ideas spring to mind, so...

perl has a module called Spreadsheet::MakeExcel

I've used that to create spreadsheets for Microsoft Excel.
Perhaps there's a similar module.
You'll have to research that one yourself.
here's the link for that one though:

Spreadsheet::WriteExcel - Write to a cross-platform Excel binary file. - search.cpan.org

another idea that makes a little more sense....

Excel can import data from a .CSV ( command-delimited flat file )
Why not use something like that?

Then the append is straightforward.

thanks,

but was hoping for an 'all-in-one' solution to my techs could run the script and it would auto-input to openoffice calc (.xls) without them needing to type it.

would the csh > csv > xls solution be do-able in the script?

cheers

i suppose:

csh >> csv

would work.

someone would still have to load it into soffice.

but generally, no, you can't append flat files onto application files without
a converter.

there might be something "out there" that does this....