Topic: reading excel files

Has anyone read excel files from SF ?

Or, is there a way to convert the .xls file to .txt within the fortran code.

Thanks, Imre

Re: reading excel files

Yes you can use. Save the excel file to csv file that can be accessed for the other required processing within the program.

Re: reading excel files

Unformatted read works very well for csv files (Read(LUN,*)) but there doesn't seem to be a way to write files with comma as the default field separator (ie. a csv file) instead of blank ....or is there?

Re: reading excel files

While writing comma delimited output is not available as a "built-in" function, it is easy enough to write out a csv style file using a formatted write statement.