"reading" Excel 2002 file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry - 31 Aug 2003 17:19 GMT

I am trying to read in a Excel file to a parse
application. I do not know the structure of an Excel file.
Is it a text file that is "tab" delimited? Does each line
end with a carriage return? Does each line begin with a
line feed byte such as a CSV file? In other words what is
the general form for "reading" a 2002 .XLS file?

Reply to this Message

Kim Mitchell - 31 Aug 2003 19:53 GMT

Excel files are much more complicated than that. Open one with notepad and
you will see. In addition to the data, the file also contains formatting,
equations and VBA macros. If you want an Excel files data available to
import into another application, save it as a csv file.

Kim

> I am trying to read in a Excel file to a parse
> application. I do not know the structure of an Excel file.
> Is it a text file that is "tab" delimited? Does each line
> end with a carriage return? Does each line begin with a
> line feed byte such as a CSV file? In other words what is
> the general form for "reading" a 2002 .XLS file?

Reply to this Message