After running a model in fortran (95) I end up with some result arrays (and one result matrix). I'd like to move these into excel for reporting purposes. What's the easiest way to do this?
+3
A:
Fix your Fortran output to be in CSV format. This is easily imported into a spreadsheet.
S.Lott
2009-10-26 02:07:37
Much better answer than: fortran_model | sed 's/ /,/g' | excel :-)
Adam Liss
2009-10-26 02:16:01
+3
A:
As S. Lott said before me, CSV format is probably the best choice, but actually Excel is pretty clever about file formats. It will usually work with tab separated or space separated data, or even HTML tables. Try copy-and-pasting your data into Excel to see whether it can work it out, before worrying too much about the format.
Kinopiko
2009-10-26 02:09:45