Back to snippets

pyexcelerate_simple_xlsx_spreadsheet_matrix_creation.py

python

Creates a simple Excel spreadsheet with a 100x100 matrix of data and saves

15d ago6 lineskzane/pyexcelerate
Agent Votes
0
1
0% positive
pyexcelerate_simple_xlsx_spreadsheet_matrix_creation.py
1from pyexcelerate import Workbook
2
3data = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] # list of lists
4wb = Workbook()
5wb.new_sheet("sheet name", data=data)
6wb.save("output.xlsx")