========
xml2xlsx
========
.. image:: https://travis-ci.org/pkaczynski/xml2xlsx.svg?branch=master
:target: https://travis-ci.org/pkaczynski/xml2xlsx
.. image:: https://coveralls.io/repos/github/pkaczynski/xml2xlsx/badge.svg?branch=master
:target: https://coveralls.io/github/pkaczynski/xml2xlsx?branch=master
.. image:: https://img.shields.io/pypi/v/xml2xlsx.svg
:target: https://pypi.python.org/pypi/xml2xlsx
.. image:: https://img.shields.io/pypi/pyversions/xml2xlsx.svg
:target: https://pypi.python.org/pypi/xml2xlsx/
.. image:: https://img.shields.io/pypi/dd/xml2xlsx.svg
:target: https://pypi.python.org/pypi/xml2xlsx/
Creating ``xlsx`` files from ``xml`` template using openpyxl_.
Target
======
This project is intended to create ``xlsx`` files from ``xml`` api to
``openpyxl``, supposedly generated by other tamplate engines (i.e. django,
jinja).
This is a merely an xml parser translating mostly linearly to worksheet, rows
and finally cells of the Excel workbook.
Example
-------
An xml file like this one
.. code-block:: xml
<workbook>
<worksheet title="test">
<row><cell>This</cell><cell>is</cell><cell>a TEST</cell></row>
<row><cell>Nice, isn't it?</cell></row>
</worksheet>
</workbook>
can be parsed to create a neat Excel workbook with two rows of data in one
worksheet. Parsing can be done using command line (provided that you have your
system paths set correctly:
.. code-block:: bash
xml2xlsx < input.xml > output.xml
or as a library call
.. code-block:: python
from xml2xlsx import xml2xlsx
template = '<sheet title="test"></sheet>'
f = open('test.xlsx', 'wb')
f.write(xml2xlsx(template))
f.close()
This is mainly intended (and was developed for this purpose) to parse files
generated by other templating engines, like django template system. One can
generate an excel workbook from template like this:
.. code-block:: xml
{% for e in list %}
<row><cell>{{ e.name }}</cell></row>
{% endfor %}
Features
========
Basic features of the library include creating multiple, named sheets within one
workbook and creating rows of cells in these sheets. However, there are more
possibiliteis to create complex excel based reports.
Cell type
---------
Each cell can be specified to use one of the types:
* string (default)
* number
* date
Type is defined in ``type`` cell attribute. The cell value is converted
appropriately to the type specified. If you insert a number in the cell value
and do not specify ``type="number"`` attribute, you will find Excel complaining
about storing nubers as text.
Since there are more date formats than countries, you have to be aware of
current locale. The simplest way to be i18n compatible is to specify date format
in ``date-fmt`` attribute and pass compatible (possibily non localized) date
in the cell value, as in the following example
.. code-block:: xml
...
<row><cell type="date" date-fmt="%Y-%m-%d">2016-10-01</cell></row>
<row><cell type="date" date-fmt="%d.%m.%Y">01.10.2016</cell></row>
...
Generated excel file will have two rows with the same date (1st of October 2016)
with date formatted according to Excel defaults (and current locale).
.. warning::
Excel tries to be very smart and converts date-like text to date format.
Please use ``type="date"`` and ``date-fmt`` attribute always if you pass
dates to cells.
Columns
-------
Columns can be tackled only in a limited way, i.e. only column widths can be
changed. Column properties are defined in ``columns`` tag as one or more child
of the ``sheet`` tag. It is possible to specify a range of columns using
``start`` and ``end`` atrributes. For example:
.. code-block:: xml
...
<sheet title="test">
<columns start="A" end="D" width="123"/>
<row><cell>Test</cell></row>
</sheet>
...
Formulas
--------
``xml2xls`` can effectively create cells with formulas in them. The only
limitation (as with ``openpyxl``) is using English names of the functions.
For example:
.. code-block:: xml
...
<row><cell>=SUM(A1:A5)</cell></row>
...
Cell referencing
----------------
The parser can store positions of the cell in a dictionary-like structure. It
then can be referenced to create complex formulas. Each value of the cell is
preprocessed using string format with stored values. This means that these
values can be referenced using ``{`` and ``}`` brackets.
Current row and column
~~~~~~~~~~~~~~~~~~~~~~
There are two basic values that can always be used, i.e. ``row`` and ``col``
which return current row number and column name.
.. code-block:: xml
<workbook>
<sheet>
<row><cell>{col}{row}</cell></row>
</sheet>
</workbook>
...
would create a workbook with a text "A1" included in the ``A1`` cell of the
worksheet. Using template languages, you can create more complicated
constructs, like (using django template system):
.. code-block:: xml
...
{% for e in list %}
<row>
<cell type="date" date-fmt="%Y-%m-%d">{{ e|date:"Y-m-d" }}</cell>
<cell>=TEXT(A{row}, "ddd")</cell>
</row>
{% endfor %}
...
would create a list of rows with a date in the first column and weekday names
for these dates in the second column (provided ``list`` context variable
contains a list of dates).
Specified cell
~~~~~~~~~~~~~~
It is also possible to store cell possible to store names of specified cells in
a pseudo-variable (as in a dictionary). One has to use ``ref-id`` attribute of
the ``cell`` tag and then reuse the value of this attribute in the remainder of
the xml input. This is very useful in formulas. A simple example would be
referencing another cell in a formula like this:
.. code-block:: xml
...
<row><cell ref-id="mycell">This is just a test</cell></row>
...
<row><cell>={mycell}</cell></row>
...
which would create an excel formula referencing a cell with "this is just a
test" text, whatever this cell address was.
.. warning::
Using the same identifier in ``ref-id`` attribute for two different cells
**overwrites** the cell reference, i.e. the last cell in the xml template
would be referenced.
A more complex example using django template engine to create summaries can
look like this:
.. code-block:: xml
...
{% for e in list %}
<row>
<cell ref-id="{% if forloop.first %}start{% elsif forloop.last %}end{% endif %}">
{{ e }}
</cell>
</row>
{% endfor %}
<row>
<cell>Summary</cell>
<cell>=SUM({start}:{end})</cell>
</row>
...
List of cells
~~~~~~~~~~~~~
Referencing a single cell can be harsh when dealing with complex reports.
Especially when creating summaries of irregularly sheet-distributed data.
``xml2xlsx`` can append a cell to a variable-like list, as in ``ref-id``
attribute, to reuse it as a comma concatenated value. Instead of ``ref-id``, one
has to use ``ref-append`` attribute.
This is a simple example to demonstrate the feature:
.. code-block::
...
<sheet>
<row>
<cell ref-append="mylist">1</cell>
<cell ref-append="mylist">2</cell>
</row>
<row><cell ref-append="mylist">3</cell></row>
<row><cell>=SUM({mylist})</cell></row>
</sheet>
This will generate an Excel sheet with ``A3`` cell containing formula to sum
``A1``, ``B1`` and ``A2`` cells (``=SUM(A1, B1, A2)``).
Referencing limitations
~~~~~~~~~~~~~~~~~~~~~~~
It is perfectly possible to reference a cell in another sheet with both
``ref-id`` and ``ref-append``. However, there is a limitation to that. Since
``xml2xslx`` is a linear parser, you are only allowed to reference already
parsed elements. This means, you have to create sheets in a proper order (sheets
referencing other sheets must be created **after** referenced cells are parsed).
The following example **will not work**:
.. code-block:: xml
...
<sheet title="one">
<row><cell>{mycell}</cell></row>
</sheet>
<sheet title="two">
<row><cell ref-id="mycell">XYZ</cell></row>
</sheet>
...
However, it is possible to make this exmaple work **and** retain the same
worksheet ordering using ``index`` attribute:
.. code-block:: xml
...
<sheet title="two">
<row><cell ref-id="mycell">XYZ</cell></row>
</sheet>
<sheet title="one" index="0">
<row><cell>{mycell}</cell></row>
</sheet>
...
Cell formatting
---------------
The cell format can be specified using various attributes of the cell tag. Only
font formatting can be specifed for now.
Font format
~~~~~~~~~~~
A font format is specified in in ``font`` attribute. It is a semicolon separated
dict like list of font formats as specified in
`font <http://openpyxl.readthedocs.io/en/default/api/openpyxl.styles.fonts.html#openpyxl.styles.fonts.Font>`_ class of
openpyxl_ library.
An example to create a cell with bold 10px font:
.. code-block::
...
<cell font="bold: True; size: 10px;">Cell formatted</cell>
...
Planned features
----------------
Here is the (probably incomplete) wishlist for the project
* Global font and cell styles
* Row widths and column heights
* Horizontal and vertical cell merging
* XML validation with XSD to quickly raise an error if parsing wrong xml
XML Schema Reference
====================
Parsed xml should be enclosed in a ``workbook`` tag. Each ``workbook`` tag can
have multiple ``sheet``. The hierarchy continues to ``row`` and ``cell`` tags.
Here is a complete list of available attributes of these tags.
``workbook``
------------
No attributes for now.
``sheet``
---------
:Attribute:
``title``
:Usage:
Specifies the worksheet title
:Attribute:
``index``
:Usage:
Specifies the worksheet index. This is relative to already created indexes.
An index of 0 creates sheet at the beginning of the sheets collection.
``row``
-------
No attributes for now
``columns``
-----------
:Attribute:
``start``
:Usage:
Specifies the starting column for the column range (in a letter format).
:Attribute:
``end``
:Usage:
Specifies the ending column for the column range (in a letter format).
:Default:
Same as ``start`` attribute
:Attribute:
``width``
:Usage:
Specifies the width for all columns in the range. It is in px format.
.. _cell:
``cell``
--------
:Attribute:
``type``
:Usage:
Specifies the resulting type of the excel cell.
:Type:
One of ``unicode``, ``date``, ``number``
:Default:
``unicode``
:Attribute:
``date-fmt``
:Usage:
Specifies the format of the date parsed as in `strftime and strptime <https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior>`_
functions of ``datetime`` standard python library.
:Remarks:
Parsed only if ``type="date"``.
:Attribute:
``font``
:Usage:
Sepcifies font formatting for a single cell.
:Type:
List of semicolon separated dict-like values in form of
``key: value; key: value;``
:Remarks:
Key and values are arguments of ``Font`` clas in ``openpyxl``.
Release History
---------------
0.2
~~~
* Added documentation
* Added cell referencing with inter-sheet possibility
* Changed ``sheet`` title attribute from ``name`` to ``title``
* Added possibility to set index for a sheet
.. _openpyxl: https://bitbucket.org/openpyxl/openpyxl
Raw data
{
"_id": null,
"home_page": "https://github.com/marrog/xml2xlsx",
"name": "xml2xlsx",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "xml lxml xlsx development",
"author": "Piotr Kaczy\u0144ski",
"author_email": "pkaczyns@gmail.com",
"download_url": null,
"platform": null,
"description": "========\r\nxml2xlsx\r\n========\r\n\r\n.. image:: https://travis-ci.org/pkaczynski/xml2xlsx.svg?branch=master\r\n :target: https://travis-ci.org/pkaczynski/xml2xlsx\r\n\r\n\r\n.. image:: https://coveralls.io/repos/github/pkaczynski/xml2xlsx/badge.svg?branch=master\r\n :target: https://coveralls.io/github/pkaczynski/xml2xlsx?branch=master\r\n\r\n\r\n.. image:: https://img.shields.io/pypi/v/xml2xlsx.svg\r\n :target: https://pypi.python.org/pypi/xml2xlsx\r\n\r\n.. image:: https://img.shields.io/pypi/pyversions/xml2xlsx.svg\r\n :target: https://pypi.python.org/pypi/xml2xlsx/\r\n\r\n.. image:: https://img.shields.io/pypi/dd/xml2xlsx.svg\r\n :target: https://pypi.python.org/pypi/xml2xlsx/\r\n\r\n\r\nCreating ``xlsx`` files from ``xml`` template using openpyxl_.\r\n\r\nTarget\r\n======\r\nThis project is intended to create ``xlsx`` files from ``xml`` api to\r\n``openpyxl``, supposedly generated by other tamplate engines (i.e. django,\r\njinja).\r\n\r\nThis is a merely an xml parser translating mostly linearly to worksheet, rows\r\nand finally cells of the Excel workbook.\r\n\r\nExample\r\n-------\r\nAn xml file like this one\r\n\r\n.. code-block:: xml\r\n\r\n <workbook>\r\n <worksheet title=\"test\">\r\n <row><cell>This</cell><cell>is</cell><cell>a TEST</cell></row>\r\n <row><cell>Nice, isn't it?</cell></row>\r\n </worksheet>\r\n </workbook>\r\n\r\ncan be parsed to create a neat Excel workbook with two rows of data in one\r\nworksheet. Parsing can be done using command line (provided that you have your\r\nsystem paths set correctly:\r\n\r\n.. code-block:: bash\r\n\r\n xml2xlsx < input.xml > output.xml\r\n\r\nor as a library call\r\n\r\n.. code-block:: python\r\n\r\n from xml2xlsx import xml2xlsx\r\n template = '<sheet title=\"test\"></sheet>'\r\n f = open('test.xlsx', 'wb')\r\n f.write(xml2xlsx(template))\r\n f.close()\r\n\r\nThis is mainly intended (and was developed for this purpose) to parse files\r\ngenerated by other templating engines, like django template system. One can\r\ngenerate an excel workbook from template like this:\r\n\r\n.. code-block:: xml\r\n\r\n {% for e in list %}\r\n <row><cell>{{ e.name }}</cell></row>\r\n {% endfor %}\r\n\r\n\r\nFeatures\r\n========\r\nBasic features of the library include creating multiple, named sheets within one\r\nworkbook and creating rows of cells in these sheets. However, there are more\r\npossibiliteis to create complex excel based reports.\r\n\r\nCell type\r\n---------\r\nEach cell can be specified to use one of the types:\r\n\r\n* string (default)\r\n* number\r\n* date\r\n\r\nType is defined in ``type`` cell attribute. The cell value is converted\r\nappropriately to the type specified. If you insert a number in the cell value\r\nand do not specify ``type=\"number\"`` attribute, you will find Excel complaining\r\nabout storing nubers as text.\r\n\r\nSince there are more date formats than countries, you have to be aware of\r\ncurrent locale. The simplest way to be i18n compatible is to specify date format\r\nin ``date-fmt`` attribute and pass compatible (possibily non localized) date\r\nin the cell value, as in the following example\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <row><cell type=\"date\" date-fmt=\"%Y-%m-%d\">2016-10-01</cell></row>\r\n <row><cell type=\"date\" date-fmt=\"%d.%m.%Y\">01.10.2016</cell></row>\r\n ...\r\n\r\nGenerated excel file will have two rows with the same date (1st of October 2016)\r\nwith date formatted according to Excel defaults (and current locale).\r\n\r\n.. warning::\r\n\r\n Excel tries to be very smart and converts date-like text to date format.\r\n Please use ``type=\"date\"`` and ``date-fmt`` attribute always if you pass\r\n dates to cells.\r\n\r\nColumns\r\n-------\r\nColumns can be tackled only in a limited way, i.e. only column widths can be\r\nchanged. Column properties are defined in ``columns`` tag as one or more child\r\nof the ``sheet`` tag. It is possible to specify a range of columns using\r\n``start`` and ``end`` atrributes. For example:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <sheet title=\"test\">\r\n <columns start=\"A\" end=\"D\" width=\"123\"/>\r\n <row><cell>Test</cell></row>\r\n </sheet>\r\n ...\r\n\r\n\r\nFormulas\r\n--------\r\n``xml2xls`` can effectively create cells with formulas in them. The only\r\nlimitation (as with ``openpyxl``) is using English names of the functions.\r\n\r\nFor example:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <row><cell>=SUM(A1:A5)</cell></row>\r\n ...\r\n\r\nCell referencing\r\n----------------\r\nThe parser can store positions of the cell in a dictionary-like structure. It\r\nthen can be referenced to create complex formulas. Each value of the cell is\r\npreprocessed using string format with stored values. This means that these\r\nvalues can be referenced using ``{`` and ``}`` brackets.\r\n\r\nCurrent row and column\r\n~~~~~~~~~~~~~~~~~~~~~~\r\nThere are two basic values that can always be used, i.e. ``row`` and ``col``\r\nwhich return current row number and column name.\r\n\r\n.. code-block:: xml\r\n\r\n <workbook>\r\n <sheet>\r\n <row><cell>{col}{row}</cell></row>\r\n </sheet>\r\n </workbook>\r\n ...\r\n\r\nwould create a workbook with a text \"A1\" included in the ``A1`` cell of the\r\nworksheet. Using template languages, you can create more complicated\r\nconstructs, like (using django template system):\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n {% for e in list %}\r\n <row>\r\n <cell type=\"date\" date-fmt=\"%Y-%m-%d\">{{ e|date:\"Y-m-d\" }}</cell>\r\n <cell>=TEXT(A{row}, \"ddd\")</cell>\r\n </row>\r\n {% endfor %}\r\n ...\r\n\r\nwould create a list of rows with a date in the first column and weekday names\r\nfor these dates in the second column (provided ``list`` context variable\r\ncontains a list of dates).\r\n\r\nSpecified cell\r\n~~~~~~~~~~~~~~\r\nIt is also possible to store cell possible to store names of specified cells in\r\na pseudo-variable (as in a dictionary). One has to use ``ref-id`` attribute of\r\nthe ``cell`` tag and then reuse the value of this attribute in the remainder of\r\nthe xml input. This is very useful in formulas. A simple example would be\r\nreferencing another cell in a formula like this:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <row><cell ref-id=\"mycell\">This is just a test</cell></row>\r\n ...\r\n <row><cell>={mycell}</cell></row>\r\n ...\r\n\r\nwhich would create an excel formula referencing a cell with \"this is just a\r\ntest\" text, whatever this cell address was.\r\n\r\n.. warning::\r\n\r\n Using the same identifier in ``ref-id`` attribute for two different cells\r\n **overwrites** the cell reference, i.e. the last cell in the xml template\r\n would be referenced.\r\n\r\nA more complex example using django template engine to create summaries can\r\nlook like this:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n {% for e in list %}\r\n <row>\r\n <cell ref-id=\"{% if forloop.first %}start{% elsif forloop.last %}end{% endif %}\">\r\n {{ e }}\r\n </cell>\r\n </row>\r\n {% endfor %}\r\n <row>\r\n <cell>Summary</cell>\r\n <cell>=SUM({start}:{end})</cell>\r\n </row>\r\n ...\r\n\r\nList of cells\r\n~~~~~~~~~~~~~\r\nReferencing a single cell can be harsh when dealing with complex reports.\r\nEspecially when creating summaries of irregularly sheet-distributed data.\r\n``xml2xlsx`` can append a cell to a variable-like list, as in ``ref-id``\r\nattribute, to reuse it as a comma concatenated value. Instead of ``ref-id``, one\r\nhas to use ``ref-append`` attribute.\r\n\r\nThis is a simple example to demonstrate the feature:\r\n\r\n.. code-block::\r\n\r\n ...\r\n <sheet>\r\n <row>\r\n <cell ref-append=\"mylist\">1</cell>\r\n <cell ref-append=\"mylist\">2</cell>\r\n </row>\r\n <row><cell ref-append=\"mylist\">3</cell></row>\r\n <row><cell>=SUM({mylist})</cell></row>\r\n </sheet>\r\n\r\nThis will generate an Excel sheet with ``A3`` cell containing formula to sum\r\n``A1``, ``B1`` and ``A2`` cells (``=SUM(A1, B1, A2)``).\r\n\r\nReferencing limitations\r\n~~~~~~~~~~~~~~~~~~~~~~~\r\nIt is perfectly possible to reference a cell in another sheet with both\r\n``ref-id`` and ``ref-append``. However, there is a limitation to that. Since\r\n``xml2xslx`` is a linear parser, you are only allowed to reference already\r\nparsed elements. This means, you have to create sheets in a proper order (sheets\r\nreferencing other sheets must be created **after** referenced cells are parsed).\r\n\r\nThe following example **will not work**:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <sheet title=\"one\">\r\n <row><cell>{mycell}</cell></row>\r\n </sheet>\r\n <sheet title=\"two\">\r\n <row><cell ref-id=\"mycell\">XYZ</cell></row>\r\n </sheet>\r\n ...\r\n\r\nHowever, it is possible to make this exmaple work **and** retain the same\r\nworksheet ordering using ``index`` attribute:\r\n\r\n.. code-block:: xml\r\n\r\n ...\r\n <sheet title=\"two\">\r\n <row><cell ref-id=\"mycell\">XYZ</cell></row>\r\n </sheet>\r\n <sheet title=\"one\" index=\"0\">\r\n <row><cell>{mycell}</cell></row>\r\n </sheet>\r\n ...\r\n\r\n\r\nCell formatting\r\n---------------\r\nThe cell format can be specified using various attributes of the cell tag. Only\r\nfont formatting can be specifed for now.\r\n\r\nFont format\r\n~~~~~~~~~~~\r\nA font format is specified in in ``font`` attribute. It is a semicolon separated\r\ndict like list of font formats as specified in\r\n`font <http://openpyxl.readthedocs.io/en/default/api/openpyxl.styles.fonts.html#openpyxl.styles.fonts.Font>`_ class of\r\nopenpyxl_ library.\r\n\r\nAn example to create a cell with bold 10px font:\r\n\r\n.. code-block::\r\n\r\n ...\r\n <cell font=\"bold: True; size: 10px;\">Cell formatted</cell>\r\n ...\r\n\r\n\r\nPlanned features\r\n----------------\r\nHere is the (probably incomplete) wishlist for the project\r\n\r\n* Global font and cell styles\r\n* Row widths and column heights\r\n* Horizontal and vertical cell merging\r\n* XML validation with XSD to quickly raise an error if parsing wrong xml\r\n\r\nXML Schema Reference\r\n====================\r\nParsed xml should be enclosed in a ``workbook`` tag. Each ``workbook`` tag can\r\nhave multiple ``sheet``. The hierarchy continues to ``row`` and ``cell`` tags.\r\n\r\nHere is a complete list of available attributes of these tags.\r\n\r\n``workbook``\r\n------------\r\nNo attributes for now.\r\n\r\n``sheet``\r\n---------\r\n\r\n:Attribute:\r\n ``title``\r\n:Usage:\r\n Specifies the worksheet title\r\n\r\n\r\n:Attribute:\r\n ``index``\r\n:Usage:\r\n Specifies the worksheet index. This is relative to already created indexes.\r\n An index of 0 creates sheet at the beginning of the sheets collection.\r\n\r\n``row``\r\n-------\r\nNo attributes for now\r\n\r\n\r\n``columns``\r\n-----------\r\n\r\n:Attribute:\r\n ``start``\r\n:Usage:\r\n Specifies the starting column for the column range (in a letter format).\r\n\r\n:Attribute:\r\n ``end``\r\n:Usage:\r\n Specifies the ending column for the column range (in a letter format).\r\n:Default:\r\n Same as ``start`` attribute\r\n\r\n:Attribute:\r\n ``width``\r\n:Usage:\r\n Specifies the width for all columns in the range. It is in px format.\r\n\r\n\r\n.. _cell:\r\n\r\n``cell``\r\n--------\r\n\r\n:Attribute:\r\n ``type``\r\n:Usage:\r\n Specifies the resulting type of the excel cell.\r\n:Type:\r\n One of ``unicode``, ``date``, ``number``\r\n:Default:\r\n ``unicode``\r\n\r\n\r\n:Attribute:\r\n ``date-fmt``\r\n:Usage:\r\n Specifies the format of the date parsed as in `strftime and strptime <https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior>`_\r\n functions of ``datetime`` standard python library.\r\n:Remarks:\r\n Parsed only if ``type=\"date\"``.\r\n\r\n\r\n:Attribute:\r\n ``font``\r\n:Usage:\r\n Sepcifies font formatting for a single cell.\r\n:Type:\r\n List of semicolon separated dict-like values in form of\r\n ``key: value; key: value;``\r\n:Remarks:\r\n Key and values are arguments of ``Font`` clas in ``openpyxl``.\r\n\r\nRelease History\r\n---------------\r\n\r\n0.2\r\n~~~\r\n\r\n* Added documentation\r\n* Added cell referencing with inter-sheet possibility\r\n* Changed ``sheet`` title attribute from ``name`` to ``title``\r\n* Added possibility to set index for a sheet\r\n\r\n\r\n.. _openpyxl: https://bitbucket.org/openpyxl/openpyxl\r\n\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "XML to XLSX converter",
"version": "1.0.2",
"project_urls": {
"Homepage": "https://github.com/marrog/xml2xlsx"
},
"split_keywords": [
"xml",
"lxml",
"xlsx",
"development"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "20b78f866020c3580569fee7164dfbc24e9c561895844af62ddebb406a2084ee",
"md5": "3fda8a6674e7acf0c7b3e633a7b59afa",
"sha256": "52c53f4cb77aa2ef93cdf0a4e7cb8e921b30c8639c220a7d91b6acf883e0e7fc"
},
"downloads": -1,
"filename": "xml2xlsx-1.0.2-py2-none-any.whl",
"has_sig": false,
"md5_digest": "3fda8a6674e7acf0c7b3e633a7b59afa",
"packagetype": "bdist_wheel",
"python_version": "py2",
"requires_python": null,
"size": 8459,
"upload_time": "2024-09-16T10:29:42",
"upload_time_iso_8601": "2024-09-16T10:29:42.721370Z",
"url": "https://files.pythonhosted.org/packages/20/b7/8f866020c3580569fee7164dfbc24e9c561895844af62ddebb406a2084ee/xml2xlsx-1.0.2-py2-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-16 10:29:42",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "marrog",
"github_project": "xml2xlsx",
"travis_ci": true,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "xml2xlsx"
}
JSON
