From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,3e6c98a1a7cab60a X-Google-Attributes: gid103376,public Path: g2news1.google.com!news1.google.com!news.glorb.com!cyclone1.gnilink.net!gnilink.net!wn14feed!worldnet.att.net!attbi_s03.POSTED!53ab2750!not-for-mail From: tmoran@acm.org Newsgroups: comp.lang.ada Subject: Re: import Excel file References: X-Newsreader: Tom's custom newsreader Message-ID: NNTP-Posting-Host: 24.6.132.82 X-Complaints-To: abuse@comcast.net X-Trace: attbi_s03 1087237085 24.6.132.82 (Mon, 14 Jun 2004 18:18:05 GMT) NNTP-Posting-Date: Mon, 14 Jun 2004 18:18:05 GMT Organization: Comcast Online Date: Mon, 14 Jun 2004 18:18:05 GMT Xref: g2news1.google.com comp.lang.ada:1480 Date: 2004-06-14T18:18:05+00:00 List-Id: >it is not a text file. The structure of the binary data isn't >usually known. However, you could try exporting sheets to CSVs, >and read these with less effort. Just run Excel and look at all the different choices for exporting data. With simple numbers, Comma Separated Values is simple, but it gets a little nastier with text, especially text with commas and quotes. Or you can read the data by using an Ada database binding and using the Excel data as a database source. There's also SYLK files, which are text and contain the formulas and formats as well as the data.