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-06!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: Mon, 04 Oct 2004 16:02:04 -0400 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <4161AC3C.90707@unixfu.net> User-Agent: Mozilla Thunderbird 0.8 (X11/20040926) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <4161a1b5$0$22589$636a15ce@news.free.fr> <0Jh8d.803$ea6.171@trndny06> In-Reply-To: <0Jh8d.803$ea6.171@trndny06> 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:4674 Date: 2004-10-04T16:02:04-04:00 List-Id: Hello stephane richard wrote: > "Alexandre Devaure" wrote in message > news:4161a1b5$0$22589$636a15ce@news.free.fr... > >>Hello, >>Does a library exist in Ada to read MS Excel files ? >>I find nothing with google. >> How often do the excel files get changed where you will need to process them? Could use a perl module to parse the file and output the data into some delimited format. Then you can use Ada to do it. An example may be some web cgi to allow users to post excel files, then the perl can parse it and store it later to be processed by Ada. Seems better to use Perl if able to do it to something Ada can understand and work with, as excel files generally do not change that much. If they do, then whoever is using the excel for a database should just use a database :) People's lives are not on the line, so using perl or some other preparser for excel files doesn't seem all that bad in my opinion. :) Perl module options: http://search.cpan.org/search?query=Parse+Spreadsheet&mode=all Good luck! >>TIA >>Alex > > > I haven't found anything either. I'd be curious to see if anyone else might > possibly have that answer. What I did find is a VB Class (no flaming please > ;-) that writes it in a binary/native format as in without using any office > references...Perhaps I could convert that to Ada. As far as structures go I > think it's pretty straight forward. > > Which brings me to my quest of the day. What can I use in the Ada > hierarchy that will open a file in binary mode and not in sequential text > mode? seems there's a difference at least in VB ..if there's such an open > mode in Ada then the translation from vb to Ada should be pretty > straightforward I think > >