Reading Excel 2010 files with Ada on Linux

Reading Excel 2010 files with Ada on Linux

[Jean François Martinez]

Hello

Anyone knows if there is an Ada package for reading xlsx files?   Program will run on Linux so package must not base on Microsoft libraries

I have googled around but all what I have found is a package for writing Excel files not for reading them.

Regards

Jean-François Martinez

Re: Reading Excel 2010 files with Ada on Linux

[gautier_niouzes]

Hi,
An xlsx file is actually a Zip file containing XML files.
The first step would be to open the file or stream with Zip-Ada [1], then parse the appropriate XML entry with XML/Ada [2].
HTH
_________________________
Gautier's Ada programming
http://gautiersblog.blogspot.com/search/label/Ada
NB: follow the above link for a valid e-mail address 
____
[1] http://unzip-ada.sf.net
[2] http://libre.adacore.com/tools/xmlada/

Re: Reading Excel 2010 files with Ada on Linux

[Anatoly Chernyshev]

Doing this kind of thing quite often myself, I would suggest to convert xlsx to csv first, then it will be a breeze to work with plain csv's in Ada.

If there are too many of xlsx to handle, I would write a VBA or VBS script, which will export the needed data into csv.

Hope this helps.

On Tuesday, March 1, 2016 at 11:42:40 PM UTC+13, Jean François Martinez wrote:
> Hello
> 
> Anyone knows if there is an Ada package for reading xlsx files?   Program will run on Linux so package must not base on Microsoft libraries
> 
> I have googled around but all what I have found is a package for writing Excel files not for reading them.
> 
> Regards
> 
> Jean-François Martinez

Re: Reading Excel 2010 files with Ada on Linux

[Jean François Martinez]

Unfortunately I have a lot of files each one with a dozen sheets.  I also have a Python library allowing me to do what I need without parsing XML files or without VBA.  It is just I would have liked to do in Ada.

Regards

Jean-François Martinez

Re: Reading Excel 2010 files with Ada on Linux

[gautier_niouzes]

Le jeudi 3 mars 2016 15:10:31 UTC+1, Jean François Martinez a écrit :
> Unfortunately I have a lot of files each one with a dozen sheets.  I also have a Python library allowing me to do what I need without parsing XML files or without VBA.  It is just I would have liked to do in Ada.

Well, the Python library does the XML parsing. If you look into the code, it is perhaps an option to reproduce the parsing with XML/Ada.
_________________________ 
Gautier's Ada programming 
http://www.openhub.net/accounts/gautier_bd

Re: Reading Excel 2010 files with Ada on Linux

[Jean François Martinez]

On Tuesday, March 1, 2016 at 11:42:40 AM UTC+1, Jean François Martinez wrote:
> Hello
> 
> Anyone knows if there is an Ada package for reading xlsx files?   Program will run on Linux so package must not base on Microsoft libraries
> 
> I have googled around but all what I have found is a package for writing Excel files not for reading them.
> 
> Regards
> 
> Jean-François Martinez

Yes but the problem is I don't have the resources ie (that is a small part of a larger project) nor the talent :-( to do it.  At least not now.