diff options
| author | DougHudgeon <doug@mybusinessautomated.com> | 2018-06-25 14:25:50 +1000 |
|---|---|---|
| committer | DougHudgeon <doug@mybusinessautomated.com> | 2018-06-25 14:25:50 +1000 |
| commit | 4c5d0b1a457b55c943fbff888459ad224c8a5bcd (patch) | |
| tree | e9bb4c54db52c26ae43114f219c8e0410c708deb | |
| parent | 61063e2b09a5cd26926311a34826fd33be0b1757 (diff) | |
| download | tablib-4c5d0b1a457b55c943fbff888459ad224c8a5bcd.tar.gz | |
Instructions for opening Excel workbook and reading the first sheet
| -rw-r--r-- | docs/tutorial.rst | 8 |
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 ------------------------------------ |
