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,FREEMAIL_FROM
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Sebastian Doht <seb_doht@lycos.com>
Newsgroups: comp.lang.ada
Subject: Re: Ada Spreadsheet output
Date: Sun, 17 Nov 2013 12:17:49 +0100
Organization: A noiseless patient Spider
Message-ID: <l6a8l0$u2h$1@dont-email.me>
References: <86e3a757-5cc2-4ea6-92f1-8b7ce369a5f2@googlegroups.com>
 <l69l3e$c8c$1@dont-email.me>
 <f8b6c2de-2489-4c7d-93ef-573324d2b7e3@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Sun, 17 Nov 2013 11:17:52 +0000 (UTC)
Injection-Info: mx05.eternal-september.org;
 posting-host="f6e6a0b139ea01a3cf464b437d92f319";
	logging-data="30801"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX19k4SLtn6gMz8szqqeGkW8y"
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:17.0) Gecko/20130509 Thunderbird/17.0.6
In-Reply-To: <f8b6c2de-2489-4c7d-93ef-573324d2b7e3@googlegroups.com>
Cancel-Lock: sha1:W3wtdNEw88Rc8disqFMBdpBataM=
Xref: news.eternal-september.org comp.lang.ada:17705
Date: 2013-11-17T12:17:49+01:00
List-Id: <comp.lang.ada>

Am 17.11.2013 07:43, schrieb Serge Mosin:
> On Sunday, November 17, 2013 12:44:14 PM UTC+7, Jeffrey Carter wrote:
>> On 11/16/2013 09:45 PM, Serge Mosin wrote:
>>
>>> Hello, guys.
>>
>>> I wish to know, if there are some Ada libraries for spreadsheet output, preferably OpenOffice. I mean the ability to create a spreadsheet file and write there/read it from the Ada program. The method should be fast enough, because big amount of data is supposed to be transferred, so launching OpenOffice and controlling output through it is not the solution.
>>
>>
>>
>> There's Excel Writer for output:
>>
>>
>>
>> http://excel-writer.sourceforge.net/
>>
>>
>>
>> I'm not aware of anything for OpenOffice, nor for reading Excel files. This
>>
>> thread from 2004
>>
>>
>>
>> http://coding.derkeiler.com/Archive/Ada/comp.lang.ada/2004-10/0299.html
>>
>>
>>
>> suggests using ODBC to read Excel files.
>>
>>
>>
>> --
>>
>> Jeff Carter
>>
>> "Death awaits you all, with nasty, big, pointy teeth!"
>>
>> Monty Python & the Holy Grail
>>
>> 20
>
> Thanks for the reply, Jeffrey. MS Excel is not preferred and ODBC usage is probably possible only with simple structured spreadsheet tables (key-value ones), but I have a very complex type of structure, so it seems that I need to find a solution by myself.
> Thanks anyways!
>


OpenOffice has an API which might be used for that. Unfortunately it is 
focused on Java and C++, there is no plain C interface which could be 
imported to Ada. If you use Windows the OLE interface might be an 
option. This is how I am creating OpenOffice documents from a Delphi 
application. Should be possible from Ada too but limits portability.

Greetz,

Sebastian