pyexcel_xlsx_save_and_read_excel_file_quickstart.py

1import pyexcel_xlsx
2
3# Prepare data as a list of lists (for a single sheet) 
4# or a dictionary of lists of lists (for multiple sheets)
5data = {
6    "Sheet 1": [
7        [1, 2, 3],
8        [4, 5, 6]
9    ],
10    "Sheet 2": [
11        ["row 1", "row 2", "row 3"],
12        [7, 8, 9]
13    ]
14}
15
16# Save the data to an xlsx file
17pyexcel_xlsx.save_data("example.xlsx", data)
18
19# Read the data back from the file
20data_from_file = pyexcel_xlsx.get_data("example.xlsx")
21
22# Print the content
23import json
24print(json.dumps(data_from_file))