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-Thread: 103376,b424ec4b490c1d84 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-02!sn-post-01!supernews.com!news.supernews.com!not-for-mail From: Chris Humphries Newsgroups: comp.lang.ada Subject: Re: excel files Date: Wed, 06 Oct 2004 13:17:37 -0400 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <416428B1.4030607@unixfu.net> User-Agent: Mozilla Thunderbird 0.8 (X11/20040926) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <20041005193515.6C38A4C409F@lovelace.ada-france.org> <4163DDD2.6030706@unixfu.net> <%%U8d.12364$HO1.865538@news20.bellglobal.com> In-Reply-To: <%%U8d.12364$HO1.865538@news20.bellglobal.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Xref: g2news1.google.com comp.lang.ada:4811 Date: 2004-10-06T13:17:37-04:00 List-Id: Warren W. Gay VE3WWG wrote: > Chris Humphries wrote: > >> stephane richard wrote: >> >>> "Andrew" wrote in message >>> news:mailman.208.1097055129.390.comp.lang.ada@ada-france.org... >>> >>>>> From: Alexandre Devaure >>>>> Subject: Re: excel files >>>>> tmoran@acm.org wrote: > > ... > >> Does anyone have any portable Ada code to offer for parsing excel files? >> I am a newbie to COM and MFC (well knew it about 6 years ago), and >> do not understand how to go about using ODBC or GNATCOM to do the >> suggested solutions to this problem. Can someone post some code showing >> how to do this, please :) >> >>>> Andrew Carroll >>>> Carroll-Tech >>>> 720-273-6814 >>>> andrew@carroll-tech.net > > > I don't know if this works for you, but the easiest way to do > this is to have Excel produce *.CSV file (comma delimited). > while paying attention to any quoted fields (which may have > commas as part of the data). > > Warren. yeah i am well aware of exporting to csv files, the discussion is about doing it on the excel files themselves which is what i was talking about. earlier in this thread i also recommended that, as well as using perl with perl modules that can read excel files and get data from it :)