Re: Ada Spreadsheet output

[Sebastian Doht <seb_doht@lycos.com>]

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