If your source file is a comma delimited file and has the extension CSV, it
can be opened directly in Excel.

"Ian Diddams" wrote:

i have a daily requirement to

1) collate data on a solaris (unix) system to a datafile
2) import the datafile (ascii) to a excel spreadsheet
3) create a graph in the s/s of the data

1) is automated
3) is built on the fly in the s/s already (ie the necesaary stuff is
in place to convert the data to a graph)

The bugbear is the importing manually of the data to the s/s. Not a
huge task (I have omitted some tedious steps above but they can
eventually be automated too...) but I would like to automate the
entire proces such that w/out human intervention - by a script that
runs automatically at a set time - the data file is imported to the
s/s and so the s/s complete with data and graph is available for
whoever might need to view it later.

So - is there some interface/command process that can be issued
(scripted) to import the data to a s/s without the s/s having to be opened
first?

Long shot I know but if I don't ask....

ian