Q: Pulling data from Excel file within Fortran I have an Excel sheet with 8000 data points (Column A). Every row from 0 to 8000 have different corresponding values in column B, C etc.  
I need to write a Fortran code that should sense the input, compare it with Column A and should give an output from Column B of the same row.
I have exported the Excel file into PRN format and Just to get an idea, I'm testing the following code example and get en error: 
Error 52, invalid character in field at line 10_

(See the Attached photo, Error Message). Any suggestion which character is invalid? I'm writing in Plato IDE  
!FTN95 application...

program FreeFormat

real*4, dimension(5) :: Open, High, Low, Close, DayAverage
real*4 :: average

open(unit=1, file='C:\Users\MUHAMMADARSLAN\Desktop\Fortran Test\Table.prn',   status='old')
do i=1,5
read(1,*)Open(i), High(i), Low(i), Close(i), DayAverage(i)
enddo
average = sum(DayAverage)/5
write(*,'("Average is",f5.2)')average

end program FreeFormat

Text inside the Table.prn file: 
Open    70
High    50
Low     10
Close   5
DayAverage  100
All values are separated by a Tab, from their variable names. 

A: Your file is completely incompatible with how you are reading it.
The command
do i=1,5
  read(1,*)Open(i), High(i), Low(i), Close(i), DayAverage(i)
enddo

expects 5 lines and 5 numbers on each line. There should be no text strings there. The numbers can be on more lines, but definitely there should be 25 numbers in total and no text in between.
Depending on what is the primary thing you have to change the code or the input file.
