This package enables high-performance Excel writing by integrating with the streaming API from the golang package excelize. Users can leverage this functionality without the need to write any Go code, as the entire process can be accomplished through Python.
-
Python and Golang Integration: Seamlessly call Golang built shared libraries from Python.
-
No Golang Code Required: Users can solely rely on Python for Excel file generation, eliminating the need for Golang expertise.
You can easily install the package via pip
pip install pyfastexcel
If you prefer to build the package manually, follow these steps:
-
Clone the repository:
git clone https://github.com/Zncl2222/pyfastexcel.git
-
Go to the project root directory:
cd pyfastexcel
-
Install the required golang packages:
go mod download
-
Build the Golang shared library using the Makefile:
make
-
Install the required python packages:
pip install -r requirements.txt
or
pipenv install
-
Import the project and start using it!
The index assignment is now avaliable in Workbook
and the FastWriter
.
Here is the example usage:
from pyfastexcel import Workbook
from pyfastexcel.utils import set_custom_style
# CustomStyle will be integrate to the pyfatexcel in next version
# Beside, CustomStyle will be re-implement in future to make it no-longer
# depend on openpyxl_style writer and openpyxl
from openpyxl_style_writer import CustomStyle
if __name__ == '__main__':
# Workbook
wb = Workbook()
# Set and register CustomStyle
bold_style = CustomStyle(font_size=15, font_bold=True)
set_custom_style('bold_style', bold_style)
ws = wb['Sheet1']
# Write value with default style
ws['A1'] = 'A1 value'
# Write value with custom style
ws['B1'] = ('B1 value', 'bold_style')
# Write value in slice with default style
ws['A2': 'C2'] = [1, 2, 3]
# Write value in slice with custom style
ws['A3': 'C3'] = [(1, 'bold_style'), (2, 'bold_style'), (3, 'bold_style')]
# Write value by row with default style (python index 0 is the index 1 in excel)
ws[3] = [9, 8, 'go']
# Write value by row with custom style
ws[4] = [(9, 'bold_style'), (8, 'bold_style'), ('go', 'bold_style')]
# Send request to golang lib and create excel
wb.read_lib_and_create_excel()
# File path to save
file_path = 'pyexample_workbook.xlsx'
wb.save(file_path)
You can also using the FastWriter
or NormalWriter
which was the
subclass of Workbook
to write excel row by row, see the more in documentations quickstart.
The documentation is hosted on Read the Docs.
The core functionality revolves around encoding Excel cell data and styles, or any other Excel properties, into a JSON string within Python. This JSON payload is then passed through ctypes to a Golang shared library. In Golang, the JSON is parsed, and using the streaming writer of excelize to wrtie excel in high performance.
Limitations:
This project currently depends on the CustomStyle
object of
the openpyxl_style_writer
package, which is built for openpyxl to write styles in write-only
mode more efficiently without duplicating code.
Future Plans:
This project plans to create its own Style
object, making it no longer
dependent on the mentioned package.