Skip to content
The Chat Archive
mpt-7b-chat Arena Human Preference 55K

import os import tkinter as tk from tkinter import filedialog, messagebox import…

  1. User

    import os import tkinter as tk from tkinter import filedialog, messagebox import openpyxl

    class SheetSelectionDialog(tk.Toplevel): def init(self, master, sheet_names): super().init(master) self.title("시트 및 범위 선택") self.geometry("300x510")

        self.selected_sheet = tk.StringVar(value=sheet_names[0])
        self.selection_info = {
            'sheet_name': None,
            'start_row': None,
            'end_row': None,
            'start_col': None,
            'end_col': None
        }
    
        label_sheet = tk.Label(self, text="시트를 선택하세요:")
        label_sheet.pack(pady=10)
    
        sheet_listbox = tk.Listbox(self, listvariable=self.selected_sheet)
        sheet_listbox.pack(pady=5)
    
        for sheet_name in sheet_names:
            sheet_listbox.insert(tk.END, sheet_name)
    
        label_start_row = tk.Label(self, text="시작 행을 선택하세요:")
        label_start_row.pack(pady=5)
    
        self.start_row_spinbox = tk.Spinbox(self, from_=1, to=100, increment=1)
        self.start_row_spinbox.pack(pady=5)
    
        label_end_row = tk.Label(self, text="끝 행을 선택하세요:")
        label_end_row.pack(pady=5)
    
        self.end_row_spinbox = tk.Spinbox(self, from_=1, to=100, increment=1)
        self.end_row_spinbox.pack(pady=5)
    
        label_start_col = tk.Label(self, text="시작 열을 선택하세요:")
        label_start_col.pack(pady=5)
    
        self.start_col_entry = tk.Entry(self)
        self.start_col_entry.pack(pady=5)
    
        label_end_col = tk.Label(self, text="끝 열을 선택하세요:")
        label_end_col.pack(pady=5)
    
        self.end_col_entry = tk.Entry(self)
        self.end_col_entry.pack(pady=5)
    
        select_button = tk.Button(self, text="선택", command=self.select_sheet_range)
        select_button.pack(pady=10)
    
    def select_sheet_range(self):
        selected_sheet_name = self.selected_sheet.get()
        start_row = int(self.start_row_spinbox.get())
        end_row = int(self.end_row_spinbox.get())
        start_col = str(self.start_col_entry.get())  # Convert to string
        end_col = str(self.end_col_entry.get())  # Convert to string
    
        if start_row <= end_row and start_col <= end_col:
            self.selection_info['sheet_name'] = selected_sheet_name
            self.selection_info['start_row'] = start_row
            self.selection_info['end_row'] = end_row
            self.selection_info['start_col'] = start_col
            self.selection_info['end_col'] = end_col
            self.destroy()
        else:
            print("시작 행 및 열은 끝 행 및 열보다 작거나 같아야 합니다.")
            messageb
    
  2. Assistant

    ox.showerror("오류", "시작 행 및 열은 끝 행 및 열보다 작거나 같아야 합니다.") self.selection_info = {} self.selected_sheet.set("") self.start_row_spinbox.set(1) self.end_row_spinbox.set(100) self.start_col_entry.delete(0, tk.END) self.end_col_entry.delete(0, tk.END) self.label_start_row.grid_remove() self.label_end_row.grid_remove() self.start_row_spinbox.grid(row=0, column=0) self.end_row_spinbox.grid(row=0, column=1) self.start_col_entry.grid(row=0, column=0) self.end_col_entry.grid(row=0, column=1) self.label_start_col.grid(row=0, column=0) self.label_end_col.grid(row=0, column=1) self.select_button.grid(row=0, column=2) self.label_sheet.grid_remove() self.sheet_listbox.grid_remove() self.label_start_row.grid(row=0, column=0) self.label_end_row.grid(row=0, column=1) self.start_row_spinbox.grid(row=0, column=0) self.end_row_spinbox.grid(row=0, column=1) self.start_col_entry.grid(row=0, column=0) self.end_col_entry.grid(row=0, column=1) self.label_start_col.grid(row=0, column=0) self.label_end_col.grid(row=0, column=1) self.select_button.grid(row=0, column=2) self.label_sheet.grid(row=0, column=0) self.sheet_listbox.grid(row=0, column=0) self.label_start_row.grid(row=0, column=0) self.label_end_row.grid(row=0, column=1) self.start_row_spinbox.grid(row=0, column=0) self.end_row_spinbox.grid(row=0, column=1) self.start_col_entry.grid(row=0, column=0) self.end_col_entry.grid(row=0, column=1) self.label_start_col.grid(row=0, column=0) self.label_end_col.grid(row=0, column=1) self.select_button.grid(row=0, column=2)

        self.
    

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.