aioxlsxstream


Nameaioxlsxstream JSON
Version 1.0.3 PyPI version JSON
download
home_pagehttps://github.com/lososkin/aioxlsxstream
SummaryAsynchronous xlsx files generator
upload_time2023-10-05 22:31:37
maintainer
docs_urlNone
authorlososkin
requires_python
license
keywords async xlsx streaming
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            
# aioxlsxstream

Generate the xlsx file on fly without storing entire file in memory.
Generated excel workbook contain only one sheet. All data writes as strings.

## Installation

```
pip install aioxlsxstream
```

## Requirements

  * Python 3.8+

### Simple exapmle

```python
import aioxlsxstream
import asyncio

async def main():
    async def rows_generaor():
        async def row_cells_generator(row):
            for col in range(5):
                yield row*5 + col
        for row in range(10):
            yield row_cells_generator(row)

    xlsx_file = aioxlsxstream.XlsxFile()
    xlsx_file.write_sheet(rows_generaor())

    with open("example.xlsx", "wb") as f:
        async for data in xlsx_file:
            f.write(data)

asyncio.run(main())
```

### aiohttp Example

```python
from aiohttp import web, hdrs
import aioxlsxstream

async def rows_generaor():
    async def row_cells_generator(row):
        for col in range(5):
            yield row*5 + col
    for row in range(10):
        yield row_cells_generator(row)

async def handle(request):
    filename = "example.xlsx"
    response = web.StreamResponse(
        status=200,
        headers={
            hdrs.CONTENT_TYPE: "application/octet-stream",
            hdrs.CONTENT_DISPOSITION: (f"attachment; " f'filename="{filename}"; '),
        },
    )
    await response.prepare(request)

    xlsx_file = aioxlsxstream.XlsxFile() # or CsvFile("csv") or CsvFile("tsv")
    xlsx_file.write_sheet(rows_generaor())

    async for data in xlsx_file:
        await response.write(data)
    return response

app = web.Application()
app.add_routes([web.get('/', handle)])

if __name__ == '__main__':
    web.run_app(app)
```



            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/lososkin/aioxlsxstream",
    "name": "aioxlsxstream",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "async xlsx streaming",
    "author": "lososkin",
    "author_email": "yalososka@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/67/54/089741cc7a39f37f07ef4251667a89bf5d3edfd88a658978ee2d79381d81/aioxlsxstream-1.0.3.tar.gz",
    "platform": null,
    "description": "\n# aioxlsxstream\n\nGenerate the xlsx file on fly without storing entire file in memory.\nGenerated excel workbook contain only one sheet. All data writes as strings.\n\n## Installation\n\n```\npip install aioxlsxstream\n```\n\n## Requirements\n\n  * Python 3.8+\n\n### Simple exapmle\n\n```python\nimport aioxlsxstream\nimport asyncio\n\nasync def main():\n    async def rows_generaor():\n        async def row_cells_generator(row):\n            for col in range(5):\n                yield row*5 + col\n        for row in range(10):\n            yield row_cells_generator(row)\n\n    xlsx_file = aioxlsxstream.XlsxFile()\n    xlsx_file.write_sheet(rows_generaor())\n\n    with open(\"example.xlsx\", \"wb\") as f:\n        async for data in xlsx_file:\n            f.write(data)\n\nasyncio.run(main())\n```\n\n### aiohttp Example\n\n```python\nfrom aiohttp import web, hdrs\nimport aioxlsxstream\n\nasync def rows_generaor():\n    async def row_cells_generator(row):\n        for col in range(5):\n            yield row*5 + col\n    for row in range(10):\n        yield row_cells_generator(row)\n\nasync def handle(request):\n    filename = \"example.xlsx\"\n    response = web.StreamResponse(\n        status=200,\n        headers={\n            hdrs.CONTENT_TYPE: \"application/octet-stream\",\n            hdrs.CONTENT_DISPOSITION: (f\"attachment; \" f'filename=\"{filename}\"; '),\n        },\n    )\n    await response.prepare(request)\n\n    xlsx_file = aioxlsxstream.XlsxFile() # or CsvFile(\"csv\") or CsvFile(\"tsv\")\n    xlsx_file.write_sheet(rows_generaor())\n\n    async for data in xlsx_file:\n        await response.write(data)\n    return response\n\napp = web.Application()\napp.add_routes([web.get('/', handle)])\n\nif __name__ == '__main__':\n    web.run_app(app)\n```\n\n\n",
    "bugtrack_url": null,
    "license": "",
    "summary": "Asynchronous xlsx files generator",
    "version": "1.0.3",
    "project_urls": {
        "Homepage": "https://github.com/lososkin/aioxlsxstream"
    },
    "split_keywords": [
        "async",
        "xlsx",
        "streaming"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "82ffc65b560b66ca77e59dd42ecaa327f6f8e34c454976d01f656ba8fe301d17",
                "md5": "b1566cbd3cfff9933938effefc88734c",
                "sha256": "fd65ae92ebfb3d793b57f874fb6f5c6272e2bcbe11d5013280a56136acd7c1a9"
            },
            "downloads": -1,
            "filename": "aioxlsxstream-1.0.3-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "b1566cbd3cfff9933938effefc88734c",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 22822,
            "upload_time": "2023-10-05T22:31:35",
            "upload_time_iso_8601": "2023-10-05T22:31:35.667402Z",
            "url": "https://files.pythonhosted.org/packages/82/ff/c65b560b66ca77e59dd42ecaa327f6f8e34c454976d01f656ba8fe301d17/aioxlsxstream-1.0.3-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "6754089741cc7a39f37f07ef4251667a89bf5d3edfd88a658978ee2d79381d81",
                "md5": "0727666e6099b3f99a899fc7bc9823cc",
                "sha256": "913fc3987a72739e233216c771a6efadecaddca86f18b59fd02230c09bef3e0f"
            },
            "downloads": -1,
            "filename": "aioxlsxstream-1.0.3.tar.gz",
            "has_sig": false,
            "md5_digest": "0727666e6099b3f99a899fc7bc9823cc",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 20602,
            "upload_time": "2023-10-05T22:31:37",
            "upload_time_iso_8601": "2023-10-05T22:31:37.647459Z",
            "url": "https://files.pythonhosted.org/packages/67/54/089741cc7a39f37f07ef4251667a89bf5d3edfd88a658978ee2d79381d81/aioxlsxstream-1.0.3.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-10-05 22:31:37",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "lososkin",
    "github_project": "aioxlsxstream",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "lcname": "aioxlsxstream"
}
        
Elapsed time: 0.12152s