how to export data to Excel

matthewkmk · ‎12-04-2002

I have written a fortran program to manipulated some data which are stored in allocated array, and I want to put those values into Excel in a formatted table. However, this is a long program including many subroutine and function, anyone can help me how to solve this problem?

Thx very much.

Jugoslav_Dujic · ‎12-05-2002

AUTODICE sample illustrates how to invoke Excel Automation from Fortran. However, a more common approach is to reverse the command and convert Fortran code to a dll called from Excel. I think the issue has been discussed here and in the Old forum. -- search for "Excel" and "dll".

Message Edited by intel.software.network.support on 12-09-2005 10:54 AM

matthewkmk · ‎12-05-2002

but i have used the allocated array ,could u tell me how to change the code? thx!

REAL,ALLOCATABLE,DIMENSION(:,:) :: DATA2
ALLOCATE(DATA2(size,8))

and is it necessary to change other things except the variables?