Approximatrix Forums — reading excel files

Re: reading excel files

null@example.com (baf1) — Tue, 21 May 2019 18:06:00 +0000

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.

Re: reading excel files

null@example.com (robinB) — Tue, 21 May 2019 10:58:48 +0000

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

null@example.com (kapil.iitk) — Thu, 16 May 2019 04:10:10 +0000

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

reading excel files

null@example.com (imre_varga) — Tue, 14 May 2019 06:04:49 +0000

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