Python + Excel

He is useless on top of the ground; he ought to be under

it, inspiring the cabbages.

— Pudd'nhead Wilson's Calendar

Python + Excel → PyExcelerate

PyExcelerate is a Python 2/3 library for writing Excel-compatible XLSX spreadsheet files, with an emphasis on speed.

https://github.com/kz26/PyExcelerate

Библиотека кода, заточенная на быструю запись (создание) таблиц типа XLSX. Другими словами, если вам надо сформировать табличку/документ Ёкселя (Excel), то вы можете воспользоваться этой интересной библиотекой.

Примеры:

from pyexcelerate import Workbook
data = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] # data is a 2D array
wb = Workbook()
wb.new_sheet("sheet name", data=data)
wb.save("output.xlsx")

ws = wb.new_sheet("test")
ws.range("B2", "C3").value = [[1, 2], [3, 4]]
wb.save("output.xlsx")

ws = wb.new_sheet("sheet name")
ws[1][1].value = 15 # a number
ws[1][2].value = 20
ws[1][3].value = "=SUM(A1,B1)" # a formula
ws[1][4].value = datetime.now() # a date
wb.save("output.xlsx")

ws = wb.new_sheet("sheet name")
ws.cell("A1").value = 12
wb.save("output.xlsx")

ws = wb.new_sheet("sheet name")
ws[1][1].value = 15
ws.range("A1", "B1").merge()
wb.save("output.xlsx")

https://github.com/kz26/PyExcelerate

original post http://vasnake.blogspot.com/2013/09/python-excel.html