Hello,

I saw it somewhere, but my computer froze before I was able to
bookmark it.

There was an example of using FORTRAN to produce some data and.. then
(still from Fortran!) write this data in an EXCEL sheet and generating
a scattering chart. As I remember the code was pretty cryptic but it
did the job.
If anybody knows anything pleases advice.

Thanks

Tuli

tuli wrote:
> Hello,
>
> I saw it somewhere, but my computer froze before I was able to
> bookmark it.
>
> There was an example of using FORTRAN to produce some data and.. then
> (still from Fortran!) write this data in an EXCEL sheet and generating
> a scattering chart. As I remember the code was pretty cryptic but it
> did the job.
> If anybody knows anything pleases advice.

If you have CVF (and possibly IVF, haven't used ifort on Windows
personally), there's a tool for creating interface specifications for
calling COM code, and I think you can use that for Excel automation.

(I've used it in the past to do database work with DAO.)

It's probably possible to do something similar with any other Windows
Fortran compiler, but there may not be the tools for automating the
interface generation for you.

On Mar 2, 3:13 pm, "tuli" <tuliherscov> wrote:
> Hello,
>
> I saw it somewhere, but my computer froze before I was able to
> bookmark it.
>
> There was an example of using FORTRAN to produce some data and.. then
> (still from Fortran!) write this data in an EXCEL sheet and generating
> a scattering chart. As I remember the code was pretty cryptic but it
> did the job.
> If anybody knows anything pleases advice.

There is no standard way to do that in Fortran, but you can call the
non-standard "system" or similarly named command to open an Excel
spreadsheet. Using VBA, it is possible to structure an Excel
spreadsheet so that it takes certain actions when it opened.

I think it is much easier and also more portable to write a Fortran
subroutine that
(1) creates a Gnuplot script to graph data
(2) writes data to a file
(3) calls Gnuplot to graph the data in the file using the system
subroutine.

I have done this, and it works fine. Skip Knoble demonstrated this --
you can search "knoble gnuplot" in this newsgroup.

tuli wrote:

> Hello,
>
> I saw it somewhere, but my computer froze before I was able to
> bookmark it.
>
> There was an example of using FORTRAN to produce some data and.. then
> (still from Fortran!) write this data in an EXCEL sheet and generating
> a scattering chart. As I remember the code was pretty cryptic but it
> did the job.
> If anybody knows anything pleases advice.

This might do what you are looking for:

qtXLS by Jorge Kuthe

http://www.qtsoftware.de

It's supposed to be a replacement for f90SQL, which is no longer available.
If you don't want to buy the newer version, depending on your compiler you
might be able to use f90SQL-Lite, which I think you can still download
(www.canaimasoft.com). I think someone here told me about qtXLS and I
bookmarked it but never did anything more about it (I was finally able to
beat f90SQL into submission and it grudgingly did what I wanted it to (or
maybe vice-versa)).

The example Beliavsky referes to here is at:

http://ftp.cac.psu.edu/pub/ger/fortr...gnuExample.f90

Skip

On 2 Mar 2007 12:33:26 -0800, "Beliavsky" <beliavsky> wrote:

-|On Mar 2, 3:13 pm, "tuli" <tuliherscov> wrote:
-|> Hello,
-|>
-|> I saw it somewhere, but my computer froze before I was able to
-|> bookmark it.
-|>
-|> There was an example of using FORTRAN to produce some data and.. then
-|> (still from Fortran!) write this data in an EXCEL sheet and generating
-|> a scattering chart. As I remember the code was pretty cryptic but it
-|> did the job.
-|> If anybody knows anything pleases advice.
-|
-|There is no standard way to do that in Fortran, but you can call the
-|non-standard "system" or similarly named command to open an Excel
-|spreadsheet. Using VBA, it is possible to structure an Excel
-|spreadsheet so that it takes certain actions when it opened.
-|
-|I think it is much easier and also more portable to write a Fortran
-|subroutine that
-|(1) creates a Gnuplot script to graph data
-|(2) writes data to a file
-|(3) calls Gnuplot to graph the data in the file using the system
-|subroutine.
-|
-|I have done this, and it works fine. Skip Knoble demonstrated this --
-|you can search "knoble gnuplot" in this newsgroup.