"reading" Excel 2002 file

L

Larry

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?
 
K

Kim Mitchell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Openig CSV file format with Excel in Office 2007 1
Create a flat file in Excel 4
CSV File Opening Conversion Issue 1
Excel CSV Files; Creating Of 3
Open file as a CSV 3
Tab delimited text file import on double click 2
.CSV Files 2
Import from TXT file with "No record delimiter" 2

Top