ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I create a graph & execute Excel from a non- MS environme (https://www.excelbanter.com/excel-discussion-misc-queries/40143-how-can-i-create-graph-execute-excel-non-ms-environme.html)

CJ Dev

How can I create a graph & execute Excel from a non- MS environme
 
I would like to set up an application that can be run from Unix or another
operating system that can be used to display a graph in Excel.(maybe a perl
script, or something?) I can create a csv file from the data coming from a
non-microsoft environment. I would like to be able to then run a unix system
command, or a command that can be executed from the "run" line from MS Start
menu that would use this data to open Excel and display the data as a chart.

BizMark

Quote:

Originally Posted by CJ Dev
I would like to set up an application that can be run from Unix or another
operating system that can be used to display a graph in Excel.(maybe a perl
script, or something?) I can create a csv file from the data coming from a
non-microsoft environment. I would like to be able to then run a unix system
command, or a command that can be executed from the "run" line from MS Start
menu that would use this data to open Excel and display the data as a chart.

This may not help much, but I vaguely remember seeing an article about an Excel clone written for Linux, which looked identical in almost every respect (as far as I could tell from the screenshots).

It WASN'T called Excel though (obviously) but it could open .xls files and I'm sure displaying charts is one of the things it would be able to do easily.

If you can find it in a search (maybe try "Linux Excel clone"?, it might be the best thing you can get. I don't think it would be possible to replicate a large chunk of Excel functionality in a single command line, though.

Dodo

?B?Q0ogRGV2?= <CJ wrote in
:

I would like to set up an application that can be run from Unix or
another operating system that can be used to display a graph in
Excel.(maybe a perl script, or something?) I can create a csv file
from the data coming from a non-microsoft environment. I would like
to be able to then run a unix system command, or a command that can be
executed from the "run" line from MS Start menu that would use this
data to open Excel and display the data as a chart.


Maybe save it as a web page? Can be used in many programs in different
environments.

See "Excel data on the web" in your help.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com