It is a plugin to pyexcel and provides the capbility to present and write data in text fromats
Project description
It is a plugin to pyexcel and extends its capbility to present and write data in text fromats mainly through tabulate:
“plain”
“simple”
“grid”
“pipe”
“orgtbl”
“rst”
“mediawiki”
“latex”
“latex_booktabs”
“json”
Usage
>>> import pyexcel as pe >>> import pyexcel.ext.text as text >>> content = [ ... ["Column 1", "Column 2", "Column 3"], ... [1, 2, 3], ... [4, 5, 6], ... [7, 8, 9] ... ] >>> sheet = pe.Sheet(content) >>> sheet Sheet Name: pyexcel -------- -------- -------- Column 1 Column 2 Column 3 1 2 3 4 5 6 7 8 9 -------- -------- -------- >>> sheet.name_columns_by_row(0) >>> sheet Sheet Name: pyexcel Column 1 Column 2 Column 3 ---------- ---------- ---------- 1 2 3 4 5 6 7 8 9 >>> multiple_sheets = { ... 'Sheet 1': ... [ ... [1.0, 2.0, 3.0], ... [4.0, 5.0, 6.0], ... [7.0, 8.0, 9.0] ... ], ... 'Sheet 2': ... [ ... ['X', 'Y', 'Z'], ... [1.0, 2.0, 3.0], ... [4.0, 5.0, 6.0] ... ], ... 'Sheet 3': ... [ ... ['O', 'P', 'Q'], ... [3.0, 2.0, 1.0], ... [4.0, 3.0, 2.0] ... ] ... } >>> book = pe.Book(multiple_sheets) >>> text.TABLEFMT = "rst" >>> text.save_as(book, "myfile.rst") >>> myfile = open("myfile.rst") >>> print(myfile.read()) Sheet Name: Sheet 1 = = = 1 2 3 4 5 6 7 8 9 = = = Sheet Name: Sheet 2 === === === X Y Z 1.0 2.0 3.0 4.0 5.0 6.0 === === === Sheet Name: Sheet 3 === === === O P Q 3.0 2.0 1.0 4.0 3.0 2.0 === === ===
Dependencies
tabulate
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pyexcel-text-0.0.1.tar.gz
(3.2 kB
view hashes)