summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorTimo Furrer <tuxtimo@gmail.com>2019-03-02 13:03:30 +0100
committerGitHub <noreply@github.com>2019-03-02 13:03:30 +0100
commitdc24fda41505d9961cd43939893a1cea3598ad18 (patch)
tree65722f2695bb273494b198815320aec15d57b40e /docs
parent3ba8d529fc814833108f351fd8191e22fd0fc9e8 (diff)
parentf812c29275c7f47b08f8f1b962625545ec4e22ad (diff)
downloadtablib-dc24fda41505d9961cd43939893a1cea3598ad18.tar.gz
Merge pull request #333 from hudgeon/master
Updated xlsx format to remove reference to openpyxl's deprecated get_active_worksheet
Diffstat (limited to 'docs')
-rw-r--r--docs/tutorial.rst8
1 files changed, 8 insertions, 0 deletions
diff --git a/docs/tutorial.rst b/docs/tutorial.rst
index 23d2773..1fe11ee 100644
--- a/docs/tutorial.rst
+++ b/docs/tutorial.rst
@@ -289,6 +289,14 @@ Now that we have extra meta-data on our rows, we can easily filter our :class:`D
It's that simple. The original :class:`Dataset` is untouched.
+Open an Excel Workbook and read first sheet
+--------------------------------
+
+To open an Excel 2007 and later workbook with a single sheet (or a workbook with multiple sheets but you just want the first sheet), use the following:
+
+data = tablib.Dataset()
+data.xlsx = open('my_excel_file.xlsx', 'rb').read()
+print(data)
Excel Workbook With Multiple Sheets
------------------------------------