import os import tkinter as tk from tkinter import filedialog, messagebox import…
- 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 - 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.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.