Boulder-Bash/Main.py at master · ghuinker/Boulder-Bash · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
from tkinter import *
import xlsxwriter
from Dash import Dash
import xlrd
from os import walk
import os


class Main(Frame):

    def __init__(self, master):
        Frame.__init__(self, master)
        self.grid()
        self.initexcelfolder()
        self.initfileviewer()
        self.create_widgets()


    def create_widgets(self):
        self.excelnamelbl = Label(self, text="Name of xcel file")
        self.excelname = Entry(self, width=30)
        self.create = Button(self,text="Create", command=self.create)
        self.runbtn = Button(self,text="Run File", command=self.runexcel)
        self.openexcelbtn = Button(self, text='Open Excel', command=self.openexcel )
        self.deletebtn = Button(self, text = 'Delete Excel', command=self.deletefile)

        self.lb = Listbox(self)

        for excelfile in self.excelfiles:
            self.lb.insert(END, excelfile)

        self.lb.bind('<<ListboxSelect>>', self.excelclicked)

        self.excelnamelbl.grid(row=0, column = 0)
        self.excelname.grid(row=0, column=1, columnspan=3)
        self.create.grid(row=1, column=0)
        self.runbtn.grid(row=1, column=1)
        self.openexcelbtn.grid(row=1, column=2)
        self.deletebtn.grid(row=1, column=3)


        self.lb.grid(row=2, column=0, columnspan=3)

    def create(self):
        name = self.excelname.get().strip()
        if name in self.excelfiles:
            self.runexcel()

        else:
            if name == '':
                return
            name = self.mypath + "\\\\" + name
            workbook = xlsxwriter.Workbook(name+ '.xlsx')
            setup = workbook.add_worksheet("Setup")
            scores = workbook.add_worksheet("Scores")
            sends = workbook.add_worksheet("Sends")

            '''Setup Write'''
            setup.write('A1', 'First Name')
            setup.write('B1', 'Last Name')
            setup.write('C1', 'Sex')
            setup.write('D1', 'Level')

            setup.write('F1', 'Heats')
            setup.write('G1', 'Route')
            setup.write('H1', 'Scores')

            workbook.close()
            self.openexcel()
            self.updatefileviewer()

    def initfileviewer(self):
        files = []

        for (dirpath, dirnames, filenames) in walk(self.mypath):
            files.extend(filenames)
            break

        self.excelfiles = []
        for filename in files:
            split = filename.split('.')
            if split[1] == 'xlsx':
                self.excelfiles.append(split[0])
        self.curfile = None

    def updatefileviewer(self):
        files = []
        for (dirpath, dirnames, filenames) in walk(self.mypath):
            files.extend(filenames)
            break

        self.excelfiles = []
        for id, filename in enumerate(files):
            split = filename.split('.')
            if split[1] == 'xlsx':
                self.excelfiles.append(split[0])

        self.lb.delete(0, END)
        for excelfile in self.excelfiles:
            self.lb.insert(END, excelfile)

    def initexcelfolder(self):
        self.mypath = os.getcwd()
        splitpath = self.mypath.split('\\')
        splitpath = splitpath[:-1]
        up = ""
        for str in splitpath:
            up = up + str + '\\\\'


        up = up + "Excel Files"
        if not os.path.exists(up):
            os.makedirs(up)
        self.mypath = up

    def excelclicked(self, e):
        try:
            self.curfile = self.lb.curselection()[0]
        except:
            None
        self.excelname.delete(0,END)
        self.excelname.insert(0,self.excelfiles[self.curfile])

    def deletefile(self):
        name = self.excelname.get()
        name = self.mypath + "\\\\" + name
        os.remove(name + '.xlsx')
        self.updatefileviewer()

    def openexcel(self):
        name = self.excelname.get()
        name = self.mypath + "\\\\" + name
        os.startfile(name + '.xlsx')

    def runexcel(self):
        window = Toplevel(self)
        name = self.excelname.get()
        name = self.mypath + "\\\\" + name
        name = name.replace("\\\\", "\\")
        app = Dash(window, name + '.xlsx')

    def quit(self):
        self.master.destroy()


root = Tk()
root.title("Boulder Bash")
app = Main(root)
root.mainloop()