# fastexcel-rw




This is a fork of [ToucanToco/fastexcel](https://github.com/ToucanToco/fastexcel) with **Excel writing functionality** added.
## 🚀 What's New
This fork extends the original fastexcel library with:
- **Excel Writing Support**: Write data to Excel files with high performance
- **Multiple Data Types**: Support for strings, numbers, booleans, and more
- **Multi-worksheet**: Create and manage multiple worksheets
- **Pandas Integration**: Direct DataFrame writing support
- **Rust 1.88.0 Support**: Updated to latest Rust version
## 📈 Performance
- **3.8x faster** than Python xlsxwriter
- **9.4x faster** than openpyxl
- **Memory efficient** with Rust's zero-copy design
## 🔧 Installation
### Quick Install from GitHub
```bash
pip install git+https://github.com/bryanhan1001/fastexcel-rw.git
```
### Install from Source
```bash
# Clone the repository
git clone https://github.com/bryanhan1001/fastexcel-rw.git
cd fastexcel-rw
# Install with writer feature
maturin develop --features writer
# Or build wheel
maturin build --features writer
```
## 💻 Usage
### Writing Excel Files
```python
import fastexcel
# Create writer
writer = fastexcel.create_excel_writer("output.xlsx")
# Write data with headers
data = [
["Alice", 25, "New York"],
["Bob", 30, "Los Angeles"],
["Charlie", 35, "Chicago"]
]
headers = ["Name", "Age", "City"]
writer.write_sheet_data(data, "Sheet1", headers)
# Save file
writer.save()
```
### Writing DataFrames
```python
import pandas as pd
import fastexcel
# Create DataFrame
df = pd.DataFrame({
'Name': ['Alice', 'Bob', 'Charlie'],
'Age': [25, 30, 35],
'City': ['New York', 'Los Angeles', 'Chicago']
})
# Write to Excel
writer = fastexcel.create_excel_writer("dataframe.xlsx")
writer.write_dataframe(df, "Sheet1")
writer.save()
```
## 🔄 Reading Excel Files
The original reading functionality remains unchanged:
```python
import fastexcel
# Read Excel file
excel_file = fastexcel.read_excel("data.xlsx")
sheet = excel_file.load_sheet_by_name("Sheet1")
data = sheet.to_arrow()
```
## 📝 License
This project maintains the same **MIT License** as the original:
```
MIT License
Copyright (c) 2024 ToucanToco
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
```
## 🤝 Contributing
This is a community fork. Contributions are welcome!
1. Fork the repository
2. Create your feature branch (`git checkout -b feature/amazing-feature`)
3. Commit your changes (`git commit -m 'Add some amazing feature'`)
4. Push to the branch (`git push origin feature/amazing-feature`)
5. Open a Pull Request
## 🙏 Acknowledgments
- Original [fastexcel](https://github.com/ToucanToco/fastexcel) by ToucanToco
- [rust_xlsxwriter](https://github.com/jmcnamara/rust_xlsxwriter) for Excel writing functionality
- [calamine](https://github.com/tafia/calamine) for Excel reading functionality
## 📊 Benchmarks
| Operation | fastexcel-rw | xlsxwriter | openpyxl |
|-----------|---------------|------------|----------|
| Write 10K rows | 0.5s | 1.9s | 4.7s |
| Write 100K rows | 2.1s | 8.0s | 19.8s |
| Memory usage | 45MB | 120MB | 180MB |
---
**Note**: This is an independent fork and is not officially associated with ToucanToco or the original fastexcel project.
Raw data
{
"_id": null,
"home_page": "https://github.com/ToucanToco/fastexcel",
"name": "fastexcel-rw",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": "excel, xlsx, arrow, python, rust",
"author": "ToucanToco, bryanhan <bryanhan1001@gmail.com>",
"author_email": "ToucanToco, bryanhan <bryanhan1001@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/63/2f/a58cfa0d13ad3078e2740c78d2d73d1c35e9df4c5975c218c6f532f97fa8/fastexcel_rw-0.15.0.tar.gz",
"platform": null,
"description": "# fastexcel-rw\n\n\n\n\n\n\nThis is a fork of [ToucanToco/fastexcel](https://github.com/ToucanToco/fastexcel) with **Excel writing functionality** added.\n\n## \ud83d\ude80 What's New\n\nThis fork extends the original fastexcel library with:\n\n- **Excel Writing Support**: Write data to Excel files with high performance\n- **Multiple Data Types**: Support for strings, numbers, booleans, and more\n- **Multi-worksheet**: Create and manage multiple worksheets\n- **Pandas Integration**: Direct DataFrame writing support\n- **Rust 1.88.0 Support**: Updated to latest Rust version\n\n## \ud83d\udcc8 Performance\n\n- **3.8x faster** than Python xlsxwriter\n- **9.4x faster** than openpyxl\n- **Memory efficient** with Rust's zero-copy design\n\n## \ud83d\udd27 Installation\n\n### Quick Install from GitHub\n\n```bash\npip install git+https://github.com/bryanhan1001/fastexcel-rw.git\n```\n\n### Install from Source\n\n```bash\n# Clone the repository\ngit clone https://github.com/bryanhan1001/fastexcel-rw.git\ncd fastexcel-rw\n\n# Install with writer feature\nmaturin develop --features writer\n\n# Or build wheel\nmaturin build --features writer\n```\n\n## \ud83d\udcbb Usage\n\n### Writing Excel Files\n\n```python\nimport fastexcel\n\n# Create writer\nwriter = fastexcel.create_excel_writer(\"output.xlsx\")\n\n# Write data with headers\ndata = [\n [\"Alice\", 25, \"New York\"],\n [\"Bob\", 30, \"Los Angeles\"],\n [\"Charlie\", 35, \"Chicago\"]\n]\nheaders = [\"Name\", \"Age\", \"City\"]\nwriter.write_sheet_data(data, \"Sheet1\", headers)\n\n# Save file\nwriter.save()\n```\n\n### Writing DataFrames\n\n```python\nimport pandas as pd\nimport fastexcel\n\n# Create DataFrame\ndf = pd.DataFrame({\n 'Name': ['Alice', 'Bob', 'Charlie'],\n 'Age': [25, 30, 35],\n 'City': ['New York', 'Los Angeles', 'Chicago']\n})\n\n# Write to Excel\nwriter = fastexcel.create_excel_writer(\"dataframe.xlsx\")\nwriter.write_dataframe(df, \"Sheet1\")\nwriter.save()\n```\n\n## \ud83d\udd04 Reading Excel Files\n\nThe original reading functionality remains unchanged:\n\n```python\nimport fastexcel\n\n# Read Excel file\nexcel_file = fastexcel.read_excel(\"data.xlsx\")\nsheet = excel_file.load_sheet_by_name(\"Sheet1\")\ndata = sheet.to_arrow()\n```\n\n## \ud83d\udcdd License\n\nThis project maintains the same **MIT License** as the original:\n\n```\nMIT License\n\nCopyright (c) 2024 ToucanToco\n\nPermission is hereby granted, free of charge, to any person obtaining a copy\nof this software and associated documentation files (the \"Software\"), to deal\nin the Software without restriction, including without limitation the rights\nto use, copy, modify, merge, publish, distribute, sublicense, and/or sell\ncopies of the Software, and to permit persons to whom the Software is\nfurnished to do so, subject to the following conditions:\n\nThe above copyright notice and this permission notice shall be included in all\ncopies or substantial portions of the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR\nIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,\nFITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE\nAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER\nLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,\nOUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE\nSOFTWARE.\n```\n\n## \ud83e\udd1d Contributing\n\nThis is a community fork. Contributions are welcome!\n\n1. Fork the repository\n2. Create your feature branch (`git checkout -b feature/amazing-feature`)\n3. Commit your changes (`git commit -m 'Add some amazing feature'`)\n4. Push to the branch (`git push origin feature/amazing-feature`)\n5. Open a Pull Request\n\n## \ud83d\ude4f Acknowledgments\n\n- Original [fastexcel](https://github.com/ToucanToco/fastexcel) by ToucanToco\n- [rust_xlsxwriter](https://github.com/jmcnamara/rust_xlsxwriter) for Excel writing functionality\n- [calamine](https://github.com/tafia/calamine) for Excel reading functionality\n\n## \ud83d\udcca Benchmarks\n\n| Operation | fastexcel-rw | xlsxwriter | openpyxl |\n|-----------|---------------|------------|----------|\n| Write 10K rows | 0.5s | 1.9s | 4.7s |\n| Write 100K rows | 2.1s | 8.0s | 19.8s |\n| Memory usage | 45MB | 120MB | 180MB |\n\n---\n\n**Note**: This is an independent fork and is not officially associated with ToucanToco or the original fastexcel project. \n",
"bugtrack_url": null,
"license": "MIT",
"summary": "A fast excel file reader and writer for Python, written in Rust",
"version": "0.15.0",
"project_urls": {
"Homepage": "https://github.com/ToucanToco/fastexcel",
"Issues": "https://github.com/bryanhan1001/fastexcel-rw",
"Source Code": "https://github.com/bryanhan1001/fastexcel-rw"
},
"split_keywords": [
"excel",
" xlsx",
" arrow",
" python",
" rust"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "13c58a8f92af8f1581875fdd039f8e284757a8413f04497a499ca0d39f2ee125",
"md5": "579d719ce716d4c5f8e8ef4a1f32b20a",
"sha256": "d7e861b0b2d522715cfffda749c2419f62a26f7b86954e66472e5dc2b66479d2"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0-cp39-abi3-macosx_10_12_x86_64.whl",
"has_sig": false,
"md5_digest": "579d719ce716d4c5f8e8ef4a1f32b20a",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9",
"size": 1896664,
"upload_time": "2025-07-09T06:45:27",
"upload_time_iso_8601": "2025-07-09T06:45:27.040485Z",
"url": "https://files.pythonhosted.org/packages/13/c5/8a8f92af8f1581875fdd039f8e284757a8413f04497a499ca0d39f2ee125/fastexcel_rw-0.15.0-cp39-abi3-macosx_10_12_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "21b9296c8c7cdd0087a9f7ffa6ab01eb85f62ff0224046cbf43669931ca08840",
"md5": "4165d5793165d69c54ee09e28efd62f5",
"sha256": "f573e32bf35dc0da63e90cf711579282a48d93a5bc0b5c274176d49fad58c7cf"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0-cp39-abi3-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "4165d5793165d69c54ee09e28efd62f5",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9",
"size": 1806226,
"upload_time": "2025-07-09T06:45:28",
"upload_time_iso_8601": "2025-07-09T06:45:28.457251Z",
"url": "https://files.pythonhosted.org/packages/21/b9/296c8c7cdd0087a9f7ffa6ab01eb85f62ff0224046cbf43669931ca08840/fastexcel_rw-0.15.0-cp39-abi3-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "5dc43b0b148abad4e05b0865ff83fd94530493a544cd3dee9a8bed107314e683",
"md5": "dd642943d41fdd292b9f0d05ed553198",
"sha256": "73163e0eda676256f8018a20eb7418c2155bce8eeb3b994488495edfd7c5d1b4"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl",
"has_sig": false,
"md5_digest": "dd642943d41fdd292b9f0d05ed553198",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9",
"size": 1961170,
"upload_time": "2025-07-09T06:45:29",
"upload_time_iso_8601": "2025-07-09T06:45:29.590096Z",
"url": "https://files.pythonhosted.org/packages/5d/c4/3b0b148abad4e05b0865ff83fd94530493a544cd3dee9a8bed107314e683/fastexcel_rw-0.15.0-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "a6725554b183486c9b656ce691cd01e02875c58c67657be4f592a009def8a166",
"md5": "9815254a29109cd70d09e6672cd05eff",
"sha256": "1740a55178f7c76fdc21486d41a1a8a832713a9a51f3dcdbd8016ea0cdd6ff05"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "9815254a29109cd70d09e6672cd05eff",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9",
"size": 2036749,
"upload_time": "2025-07-09T06:45:31",
"upload_time_iso_8601": "2025-07-09T06:45:31.070986Z",
"url": "https://files.pythonhosted.org/packages/a6/72/5554b183486c9b656ce691cd01e02875c58c67657be4f592a009def8a166/fastexcel_rw-0.15.0-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "47b03be99232c5264bea3f64470e0472def9f4cc896144f9727c2722994eda39",
"md5": "3f4c68b34cd3da3a34990d0c98779241",
"sha256": "cc62bf3da20536955c3509ef97db2c1ad76787e824d6ffe707d5ed434e219d90"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0-cp39-abi3-win_amd64.whl",
"has_sig": false,
"md5_digest": "3f4c68b34cd3da3a34990d0c98779241",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9",
"size": 1672337,
"upload_time": "2025-07-09T06:45:32",
"upload_time_iso_8601": "2025-07-09T06:45:32.102964Z",
"url": "https://files.pythonhosted.org/packages/47/b0/3be99232c5264bea3f64470e0472def9f4cc896144f9727c2722994eda39/fastexcel_rw-0.15.0-cp39-abi3-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "632fa58cfa0d13ad3078e2740c78d2d73d1c35e9df4c5975c218c6f532f97fa8",
"md5": "e886364e961ddacca140dff80af0dc6d",
"sha256": "558444226ae9fe1cb5bf7b380ebf6119fa7560ea3ae87ebba07651929747a4d0"
},
"downloads": -1,
"filename": "fastexcel_rw-0.15.0.tar.gz",
"has_sig": false,
"md5_digest": "e886364e961ddacca140dff80af0dc6d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 45959,
"upload_time": "2025-07-09T06:45:33",
"upload_time_iso_8601": "2025-07-09T06:45:33.508191Z",
"url": "https://files.pythonhosted.org/packages/63/2f/a58cfa0d13ad3078e2740c78d2d73d1c35e9df4c5975c218c6f532f97fa8/fastexcel_rw-0.15.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-07-09 06:45:33",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "ToucanToco",
"github_project": "fastexcel",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "fastexcel-rw"
}