I recently moved over to Intel Fortran Development environment. I would like to add the capability in my FORTRAN program to write the results to MS Excel files and draw some charts. Right now I print the results to text files and use VBA macro to read data from text files, and plot excel charts. The VBA debugging is painful (maybe because I am not good in VBA) and I feel home in FORTRAN environment.
So the objective is to make FORTRAN to write to Excel files. I can not decide on what is the best way to do this. I would like to stay with native FORTRAN environment, because I don't know much in VB.NET.
I came across f90VB, which is mean entirely for this purpose. But it is not being sold anymore (and I don't think it works with Visual Studio 2005).
Are there any other standard libraries or codes that will support creating Excel files from FORTRAN?
The examples in ifort ver 9 or 10, have mixed language programming calls from VB to FORTRAN (meaning the main function is in VB, and FORTRAN calls are through DLLs). I would prefer something from FORTRAN to VB (where FORTRAN remains in control). Because right now my program is tuned for that, otherwise I will have to redesign the code. In future, I am also thinking about generating a GUI environment for the FORTRAN program.
Considering the things said above, and based on your experience, could somebody suggest me what the best way to approach this problem is? I don't mind spending time to learn VB.NET or some other technique or library or language, but it should be worthwhile.
Your input is much appreciated and will save me time in doing things the right way.
Thanks in advance.