Skip to content
The Chat Archive
vicuna-13b 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

    오류가 발생한 인터페이스이 아니면 다음과 같이 수정하시면 됩니다.

    self.end_col_entry = tk.Entry(self)
    self.end_col_entry.pack(pady=5)
    
    label_end_col = tk.Label(self, text="끝 열을 선택하세요:")
    label_end_col.pack(pady=5)
    
    self.end_col_entry.insert(tk.END, ':')
    
    select_button = tk.Button(self, text="선택", command=self.select_sheet_range)
    select_button.pack(pady=10)
    

    하지만 이 코드를 실행하면 볼 때 end_col_entry.insert(tk.END, ':') 부분이 오류를 발생시킨 것 같아서 해당 부분을 제거하셔서 수정해야 합니다.

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