* Reading Excel 2010 files with Ada on Linux
@ 2016-03-01 10:42 Jean François Martinez
2016-03-01 14:42 ` gautier_niouzes
` (3 more replies)
0 siblings, 4 replies; 6+ messages in thread
From: Jean François Martinez @ 2016-03-01 10:42 UTC (permalink / raw)
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
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Reading Excel 2010 files with Ada on Linux
2016-03-01 10:42 Reading Excel 2010 files with Ada on Linux Jean François Martinez
@ 2016-03-01 14:42 ` gautier_niouzes
2016-03-02 11:35 ` Anatoly Chernyshev
` (2 subsequent siblings)
3 siblings, 0 replies; 6+ messages in thread
From: gautier_niouzes @ 2016-03-01 14:42 UTC (permalink / raw)
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Reading Excel 2010 files with Ada on Linux
2016-03-01 10:42 Reading Excel 2010 files with Ada on Linux Jean François Martinez
2016-03-01 14:42 ` gautier_niouzes
@ 2016-03-02 11:35 ` Anatoly Chernyshev
2016-03-03 14:10 ` Jean François Martinez
2016-03-04 17:36 ` Jean François Martinez
3 siblings, 0 replies; 6+ messages in thread
From: Anatoly Chernyshev @ 2016-03-02 11:35 UTC (permalink / raw)
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
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Reading Excel 2010 files with Ada on Linux
2016-03-01 10:42 Reading Excel 2010 files with Ada on Linux Jean François Martinez
2016-03-01 14:42 ` gautier_niouzes
2016-03-02 11:35 ` Anatoly Chernyshev
@ 2016-03-03 14:10 ` Jean François Martinez
2016-03-03 16:17 ` gautier_niouzes
2016-03-04 17:36 ` Jean François Martinez
3 siblings, 1 reply; 6+ messages in thread
From: Jean François Martinez @ 2016-03-03 14:10 UTC (permalink / raw)
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
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Reading Excel 2010 files with Ada on Linux
2016-03-01 10:42 Reading Excel 2010 files with Ada on Linux Jean François Martinez
` (2 preceding siblings ...)
2016-03-03 14:10 ` Jean François Martinez
@ 2016-03-04 17:36 ` Jean François Martinez
3 siblings, 0 replies; 6+ messages in thread
From: Jean François Martinez @ 2016-03-04 17:36 UTC (permalink / raw)
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.
^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2016-03-04 17:36 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2016-03-01 10:42 Reading Excel 2010 files with Ada on Linux Jean François Martinez
2016-03-01 14:42 ` gautier_niouzes
2016-03-02 11:35 ` Anatoly Chernyshev
2016-03-03 14:10 ` Jean François Martinez
2016-03-03 16:17 ` gautier_niouzes
2016-03-04 17:36 ` Jean François Martinez
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox