what is shortest way to export what's in a tree view to an excel file

Question

I have a treeView witch has a lot of data I want to export this data to excel file. I want the simplest way to do this.

I have an idea witch is to convert whats in tree view to data frame then save the data frame as excel file. but I don't know if it's good idea or not ?!

from tkinter import filedialog
import pandas as pd
from collections import defaultdict

file = filedialog.asksaveasfilename(title="Select file","nameOfFile.xlsx",filetypes=[("Excel file", "*.xlsx")])
if file:
    ids=tree.get_children()
    dict = defaultdict(list)
    for id in ids:
        date=dt.datetime.strptime(tree.set(id, "#13"), '%Y-%m-%d %H:%M:%S')
        dateChosed=dt.datetime.strptime(monthToExport.get(), "%B-%Y")
        if (date.year == dateChosed.year) and (date.month == dateChosed.month):
            dict["1"].append(tree.item(id)["text"])
            dict["2"].append(tree.item(id)["values"][0])

    dict = pd.DataFrame.from_dict(dict)
    try:
        dict.to_excel(file, engine='xlsxwriter',index= False)
    except:
        print("Close the file than retry")
else:
    print("You did not save the file")

What have you tried so far? There are plenty of ways to achieve what you want, and yes converting to dataframe and then save to excel is a valid approach. — Henry Yik, May 23 '19 at 08:37
@HenryYik here is what i tried its working, if its clear can that be improved. — Ali, May 23 '19 at 10:31
You can properly save a few lines by using `defaultdict`, but other than that it looks fine to me. — Henry Yik, May 23 '19 at 10:46

score 1 · Accepted Answer · answered May 29 '19 at 08:08

from tkinter import filedialog
import pandas as pd
from collections import defaultdict

file = filedialog.asksaveasfilename(title="Select file","nameOfFile.xlsx",filetypes[("Excel file", "*.xlsx")])
if file:
    ids=tree.get_children()
    dict = defaultdict(list)
    for id in ids:
        date=dt.datetime.strptime(tree.set(id, "#13"), '%Y-%m-%d %H:%M:%S')
        dateChosed=dt.datetime.strptime(monthToExport.get(), "%B-%Y")
        if (date.year == dateChosed.year) and (date.month == dateChosed.month):
            dict["1"].append(tree.item(id)["text"])
            dict["2"].append(tree.item(id)["values"][0])

    dict = pd.DataFrame.from_dict(dict)
    try:
       dict.to_excel(file, engine='xlsxwriter',index= False)
    except:
       print("Close the file than retry")
else:
print("You did not save the file")

score 0 · Answer 2 · edited Jun 14 '22 at 03:50

0

def save_csv():
    import csv
    with open("new.csv", "w", newline='') as myfile:
        csvwriter = csv.writer(myfile, delimiter=',')
        
        for row_id in st_trv.get_children():
            row = st_trv.item(row_id)['values']
            #print('save row:', row)
            csvwriter.writerow(row)

edited Jun 14 '22 at 03:50

Henry Ecker

34,399
18
41
57

answered Jun 14 '22 at 00:19

Ibrahem ElGammal

1

what is shortest way to export what's in a tree view to an excel file

2 Answers2