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 >>> text.TABLEFMT = "grid" >>> 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 = "mediawiki" >>> book.save_as("myfile.mediawiki") >>> myfile = open("myfile.mediawiki") >>> print(myfile.read()) Sheet Name: Sheet 1 {| class="wikitable" style="text-align: left;" |+ <!-- caption --> |- | align="right"| 1 || align="right"| 2 || align="right"| 3 |- | align="right"| 4 || align="right"| 5 || align="right"| 6 |- | align="right"| 7 || align="right"| 8 || align="right"| 9 |} Sheet Name: Sheet 2 {| class="wikitable" style="text-align: left;" |+ <!-- caption --> |- | X || Y || Z |- | 1.0 || 2.0 || 3.0 |- | 4.0 || 5.0 || 6.0 |} Sheet Name: Sheet 3 {| class="wikitable" style="text-align: left;" |+ <!-- caption --> |- | O || P || Q |- | 3.0 || 2.0 || 1.0 |- | 4.0 || 3.0 || 2.0 |} <BLANKLINE>
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.3.zip
(7.9 kB
view hashes)