You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Michiel Kalkman <m....@euronext.nl> on 2003/12/18 09:53:38 UTC
xls2xml task
Just so you know.
I created an ant task called xls2xml. It is available from
http://www.geocities.com/xls2xml.
Its intention is to be able read excel sheets and convert the data it
contains into one or more xml file(s). Which might be useful if your client
only knows MS Excel and you don't want to manually extract data from these
files.
It is a very simple and crude task at the moment - it works only with simple
data. E.g. dates are currently not correctly converted. The sources could
also use a cleanup.
However, it might still be useful to some of us.
Unless somebody tells me how I can better convert excel sheets into xml
through Ant, I intend to remain working on it (lots of to-do's on my list
...).
However, as I have other interests as well, I also intend to work on and
lobby for this task to become part of the optional tasks of ant, so others
can have a go at this as well. The other main reason for this to happen, is
that the xls2xml task is based on POI, another apache project, and I guess
apache projects should make some PR for each other, shouldn't they ?.
Regards,
Michiel Kalkman
=== E U R O N E X T - D I S C L A I M E R =============================
This e-mail and its attachments are only intended for the individual(s) or
entity(entities) named above to whom they are addressed and may contain
personal and/or confidential information. Please notify us immediately if
you are not the intended recipient. Any dissemination, duplication,
publication to third parties or other use of the contents of this e-mail or
its attachments is forbidden. Although this information has been compiled
with great care, neither Euronext N.V. nor its subsidiaries shall accept any
responsibility for any errors, omissions or other inaccuracies in this
information or for the consequences thereof, nor shall it be bound in any
way by the contents of this e-mail or its attachments. In the event of
incomplete or incorrect transmission please return the e-mail to the sender.
Cet e-mail et ses annexes sont uniquement destin�s � la (aux) personne(s),
ou � l' (aux) entit�(s) � laquelle (auxquelle(s)) il est adress�, vis�e (s)
en t�te du pr�sent message. Il peut contenir des informations personnelles
ou confidentielles. Merci de nous notifier imm�diatement si cet e-mail vous
a �t� adress� par erreur. Toute diffusion, copie, publication � des tiers ou
toute autre utilisation de son contenu est interdite. Bien que cette
information ait �t� rassembl�e avec une grande attention, ni Euronext N.V.
ni aucune de ses filiales, ne peut �tre tenue responsable des erreurs,
omissions ou inexactitudes contenues dans cette information, ni ne peut �tre
li�e d'aucune mani�re par le contenu de cet e-mail ou ses annexes. En cas de
transmission incorrecte ou incompl�te, nous vous prions de retourner cet
e-mail � son �metteur.
Deze e-mail en zijn bijlagen zijn uitsluitend bestemd voor de
geadresseerde(n) als op dit e-mailblad vermeld. Het is mogelijk dat deze
e-mail persoonlijke en/of vertrouwelijke informatie bevat. Wanneer u niet de
geadresseerde bent, verzoeken wij u dringend ons daarvan te berichten. Elke
verspreiding, vermenigvuldiging, gebruik of openbaarmaking aan derden van de
inhoud van deze e-mail en zijn bijlagen, is verboden. Hoewel deze informatie
met de meeste zorg is samengesteld is Euronext N.V., en de tot Euronext N.V.
behorende werkmaatschappijen, op geen enkele wijze aansprakelijk voor
eventuele fouten, omissies of andere onjuistheden in deze informatie of de
gevolgen daarvan noch op enigerlei wijze gebonden aan de inhoud van de
e-mail of zijn bijlagen. Gelieve, in geval van onjuiste of onvolledige
ontvangst, deze e-mail terug te sturen naar de afzender.
================================
Re: xls2xml task
Posted by "Andrew C. Oliver" <ac...@apache.org>.
It would be welcome here as well.
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership. In fact they probably most definitively disagree with
everything espoused in the above email.
From: Michiel Kalkman <m....@euronext.nl>
Reply-To: "POI Users List" <po...@jakarta.apache.org>
Date: Thu, 18 Dec 2003 09:53:38 +0100
To: user@ant.apache.org, POI Users List <po...@jakarta.apache.org>
Subject: xls2xml task
Just so you know.
I created an ant task called xls2xml. It is available from
http://www.geocities.com/xls2xml.
Its intention is to be able read excel sheets and convert the data it
contains into one or more xml file(s). Which might be useful if your client
only knows MS Excel and you don't want to manually extract data from these
files.
It is a very simple and crude task at the moment - it works only with simple
data. E.g. dates are currently not correctly converted. The sources could
also use a cleanup.
However, it might still be useful to some of us.
Unless somebody tells me how I can better convert excel sheets into xml
through Ant, I intend to remain working on it (lots of to-do's on my list
...).
However, as I have other interests as well, I also intend to work on and
lobby for this task to become part of the optional tasks of ant, so others
can have a go at this as well. The other main reason for this to happen, is
that the xls2xml task is based on POI, another apache project, and I guess
apache projects should make some PR for each other, shouldn't they ?.
Regards,
Michiel Kalkman
=== E U R O N E X T - D I S C L A I M E R =============================
This e-mail and its attachments are only intended for the individual(s) or
entity(entities) named above to whom they are addressed and may contain
personal and/or confidential information. Please notify us immediately if
you are not the intended recipient. Any dissemination, duplication,
publication to third parties or other use of the contents of this e-mail or
its attachments is forbidden. Although this information has been compiled
with great care, neither Euronext N.V. nor its subsidiaries shall accept any
responsibility for any errors, omissions or other inaccuracies in this
information or for the consequences thereof, nor shall it be bound in any
way by the contents of this e-mail or its attachments. In the event of
incomplete or incorrect transmission please return the e-mail to the sender.
Cet e-mail et ses annexes sont uniquement destinés à la (aux) personne(s),
ou à l' (aux) entité(s) à laquelle (auxquelle(s)) il est adressé, visée (s)
en tête du présent message. Il peut contenir des informations personnelles
ou confidentielles. Merci de nous notifier immédiatement si cet e-mail vous
a été adressé par erreur. Toute diffusion, copie, publication à des tiers ou
toute autre utilisation de son contenu est interdite. Bien que cette
information ait été rassemblée avec une grande attention, ni Euronext N.V.
ni aucune de ses filiales, ne peut être tenue responsable des erreurs,
omissions ou inexactitudes contenues dans cette information, ni ne peut être
liée d'aucune manière par le contenu de cet e-mail ou ses annexes. En cas de
transmission incorrecte ou incomplète, nous vous prions de retourner cet
e-mail à son émetteur.
Deze e-mail en zijn bijlagen zijn uitsluitend bestemd voor de
geadresseerde(n) als op dit e-mailblad vermeld. Het is mogelijk dat deze
e-mail persoonlijke en/of vertrouwelijke informatie bevat. Wanneer u niet de
geadresseerde bent, verzoeken wij u dringend ons daarvan te berichten. Elke
verspreiding, vermenigvuldiging, gebruik of openbaarmaking aan derden van de
inhoud van deze e-mail en zijn bijlagen, is verboden. Hoewel deze informatie
met de meeste zorg is samengesteld is Euronext N.V., en de tot Euronext N.V.
behorende werkmaatschappijen, op geen enkele wijze aansprakelijk voor
eventuele fouten, omissies of andere onjuistheden in deze informatie of de
gevolgen daarvan noch op enigerlei wijze gebonden aan de inhoud van de
e-mail of zijn bijlagen. Gelieve, in geval van onjuiste of onvolledige
ontvangst, deze e-mail terug te sturen naar de afzender.
================================
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: xls2xml task
Posted by "Andrew C. Oliver" <ac...@apache.org>.
It would be welcome here as well.
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership. In fact they probably most definitively disagree with
everything espoused in the above email.
From: Michiel Kalkman <m....@euronext.nl>
Reply-To: "POI Users List" <po...@jakarta.apache.org>
Date: Thu, 18 Dec 2003 09:53:38 +0100
To: user@ant.apache.org, POI Users List <po...@jakarta.apache.org>
Subject: xls2xml task
Just so you know.
I created an ant task called xls2xml. It is available from
http://www.geocities.com/xls2xml.
Its intention is to be able read excel sheets and convert the data it
contains into one or more xml file(s). Which might be useful if your client
only knows MS Excel and you don't want to manually extract data from these
files.
It is a very simple and crude task at the moment - it works only with simple
data. E.g. dates are currently not correctly converted. The sources could
also use a cleanup.
However, it might still be useful to some of us.
Unless somebody tells me how I can better convert excel sheets into xml
through Ant, I intend to remain working on it (lots of to-do's on my list
...).
However, as I have other interests as well, I also intend to work on and
lobby for this task to become part of the optional tasks of ant, so others
can have a go at this as well. The other main reason for this to happen, is
that the xls2xml task is based on POI, another apache project, and I guess
apache projects should make some PR for each other, shouldn't they ?.
Regards,
Michiel Kalkman
=== E U R O N E X T - D I S C L A I M E R =============================
This e-mail and its attachments are only intended for the individual(s) or
entity(entities) named above to whom they are addressed and may contain
personal and/or confidential information. Please notify us immediately if
you are not the intended recipient. Any dissemination, duplication,
publication to third parties or other use of the contents of this e-mail or
its attachments is forbidden. Although this information has been compiled
with great care, neither Euronext N.V. nor its subsidiaries shall accept any
responsibility for any errors, omissions or other inaccuracies in this
information or for the consequences thereof, nor shall it be bound in any
way by the contents of this e-mail or its attachments. In the event of
incomplete or incorrect transmission please return the e-mail to the sender.
Cet e-mail et ses annexes sont uniquement destinés à la (aux) personne(s),
ou à l' (aux) entité(s) à laquelle (auxquelle(s)) il est adressé, visée (s)
en tête du présent message. Il peut contenir des informations personnelles
ou confidentielles. Merci de nous notifier immédiatement si cet e-mail vous
a été adressé par erreur. Toute diffusion, copie, publication à des tiers ou
toute autre utilisation de son contenu est interdite. Bien que cette
information ait été rassemblée avec une grande attention, ni Euronext N.V.
ni aucune de ses filiales, ne peut être tenue responsable des erreurs,
omissions ou inexactitudes contenues dans cette information, ni ne peut être
liée d'aucune manière par le contenu de cet e-mail ou ses annexes. En cas de
transmission incorrecte ou incomplète, nous vous prions de retourner cet
e-mail à son émetteur.
Deze e-mail en zijn bijlagen zijn uitsluitend bestemd voor de
geadresseerde(n) als op dit e-mailblad vermeld. Het is mogelijk dat deze
e-mail persoonlijke en/of vertrouwelijke informatie bevat. Wanneer u niet de
geadresseerde bent, verzoeken wij u dringend ons daarvan te berichten. Elke
verspreiding, vermenigvuldiging, gebruik of openbaarmaking aan derden van de
inhoud van deze e-mail en zijn bijlagen, is verboden. Hoewel deze informatie
met de meeste zorg is samengesteld is Euronext N.V., en de tot Euronext N.V.
behorende werkmaatschappijen, op geen enkele wijze aansprakelijk voor
eventuele fouten, omissies of andere onjuistheden in deze informatie of de
gevolgen daarvan noch op enigerlei wijze gebonden aan de inhoud van de
e-mail of zijn bijlagen. Gelieve, in geval van onjuiste of onvolledige
ontvangst, deze e-mail terug te sturen naar de afzender.
================================
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org