pyexcel_xls_read_write_excel_file_to_dict.py

1import pyexcel as p
2from collections import OrderedMultiDict
3
4# Writing data to an xls file
5data = [
6    [1, 2, 3],
7    [4, 5, 6]
8]
9p.save_as(dest_file_name="example.xls", array=data)
10
11# Reading an xls file
12sheet_content = p.get_book_dict(file_name="example.xls")
13
14# Display the content
15for sheet_name in sheet_content:
16    print(f"Sheet: {sheet_name}")
17    for row in sheet_content[sheet_name]:
18        print(row)