pyexcel_save_list_to_xlsx_and_read_as_records.py

1import pyexcel as p
2
3# Prepare the data
4data = [
5    ["ID", "Name", "Age"],
6    [1, "Adam", 28],
7    [2, "Beatrice", 29],
8    [3, "Ceri", 30]
9]
10
11# Save the data to an excel file
12p.save_as(array=data, dest_file_name="example.xlsx")
13
14# Get the data back from the file as a list of dictionaries
15records = p.get_records(file_name="example.xlsx")
16
17for record in records:
18    print(f"{record['Name']} is {record['Age']} years old")