summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDougHudgeon <doug@mybusinessautomated.com>2018-06-25 14:25:50 +1000
committerDougHudgeon <doug@mybusinessautomated.com>2018-06-25 14:25:50 +1000
commit4c5d0b1a457b55c943fbff888459ad224c8a5bcd (patch)
treee9bb4c54db52c26ae43114f219c8e0410c708deb
parent61063e2b09a5cd26926311a34826fd33be0b1757 (diff)
downloadtablib-4c5d0b1a457b55c943fbff888459ad224c8a5bcd.tar.gz
Instructions for opening Excel workbook and reading the first sheet
-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
------------------------------------