From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on ip-172-31-65-14.ec2.internal X-Spam-Level: X-Spam-Status: No, score=-3.2 required=3.0 tests=BAYES_00,NICE_REPLY_A, T_SCC_BODY_TEXT_LINE autolearn=ham autolearn_force=no version=3.4.6 Path: eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: "Dmitry A. Kazakov" Newsgroups: comp.lang.ada Subject: Re: Ada interface to Excel file Date: Thu, 20 Apr 2023 11:18:53 +0200 Organization: A noiseless patient Spider Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Injection-Date: Thu, 20 Apr 2023 09:18:52 -0000 (UTC) Injection-Info: dont-email.me; posting-host="45ff78a558fd0d4bbad5d8d6785e8426"; logging-data="564317"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX193gl6Ryr85DKWQgDDuP3Lhlss6J2c37wk=" User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Cancel-Lock: sha1:WgWuYco10rDswuUPO6NCTq5SYe8= Content-Language: en-US In-Reply-To: Xref: news.eternal-september.org comp.lang.ada:65119 List-Id: On 2023-04-19 19:36, AdaMagica wrote: > I create Ada code from an Excel file. For this, I first manually export the file to csv format. The code generator works on the csv file. > I'd like to automate this first step by including the export into the code generator. > > I guess there is a C interface for Excel. I only just need the export functionality, not a full interface. > However, being illiterate in C, I'd further welcome help on the way to define an Ada interface to this C code. > > Can anyone help, please? Thanx a lot. AFAIK, Excel has an ODBC driver. So you can simply read/write an Excel table directly from Ada using ODBC SQL statements. -- Regards, Dmitry A. Kazakov http://www.dmitry-kazakov.de