Breaking News: Grepper is joining You.com. Read the official announcement!

spreadsheet as above

Sujan Ram answered on September 14, 2023 Popularity 1/10 Helpfulness 1/10

answer spreadsheet as above

spreadsheet as above

Comment

import tkinter as tk
from tkinter import ttk
from tkinter import filedialog

# Function to toggle full window mode
def toggle_fullscreen():
    root.attributes("-fullscreen", not root.attributes("-fullscreen"))

# Function to merge selected cells (not applicable in a basic spreadsheet)
def merge_cells():
    pass

# Function to add a new row
def add_row():
    tree.insert('', 'end', values=[''] * len(tree['columns']))

# Function to add a new column
def add_column():
    column_name = entry_column_name.get()
    if column_name:
        tree['columns'] += (column_name,)
        tree.heading('#' + str(len(tree['columns'])), text=column_name)

# Function to insert data from file
def insert_data_from_file():
    file_path = filedialog.askopenfilename(filetypes=[("Text Files", "*.txt")])
    if file_path:
        with open(file_path, 'r') as file:
            lines = file.readlines()
            for line in lines:
                data = line.strip().split('\t')
                tree.insert('', 'end', values=tuple(data))

# Function to edit a cell's content
def edit_cell(event):
    item = tree.selection()
    if item:
        column = tree.identify_column(event.x)
        col_id = column.split('#')[-1]
        col_name = tree.heading(column)['text']
        cell_value = tree.item(item, 'values')[int(col_id) - 1]

        # Create an Entry widget to edit the cell
        edit_entry = ttk.Entry(tree, justify='center')
        edit_entry.insert(0, cell_value)

        def save_edit():
            edited_value = edit_entry.get()
            tree.item(item, values=(edited_value if edited_value else ''))
            edit_entry.destroy()

        edit_entry.bind('<Return>', lambda e: save_edit())
        tree.update_idletasks()
        tree.place(x=event.x, y=event.y, anchor='nw', width=tree.column(col_name, 'width'), height=tree.rowheight(item))
        edit_entry.place(x=event.x, y=event.y, anchor='nw', width=tree.column(col_name, 'width'))
        edit_entry.focus_set()
        edit_entry.select_range(0, 'end')

# Create the main window
root = tk.Tk()
root.title("Goosey's Spreadsheet")

# Create a menu bar
menu_bar = tk.Menu(root)
root.config(menu=menu_bar)

# Create a "View" menu
view_menu = tk.Menu(menu_bar, tearoff=0)
menu_bar.add_cascade(label="View", menu=view_menu)
view_menu.add_command(label="Toggle Fullscreen", command=toggle_fullscreen)

# Create a "Table" menu
table_menu = tk.Menu(menu_bar, tearoff=0)
menu_bar.add_cascade(label="Table", menu=table_menu)
table_menu.add_command(label="Add Row", command=add_row)
table_menu.add_command(label="Add Column", command=add_column)
table_menu.add_command(label="Insert Data from File", command=insert_data_from_file)

# Create a Treeview widget for the spreadsheet
tree = ttk.Treeview(root, show='headings')
tree['columns'] = ('Column 1', 'Column 2', 'Column 3')
tree.heading('#1', text='Column 1')
tree.heading('#2', text='Column 2')
tree.heading('#3', text='Column 3')

# Insert some sample data
for _ in range(5):
    tree.insert('', 'end', values=[''] * len(tree['columns']))

# Bind a double-click event to edit cells
tree.bind('<Double-1>', edit_cell)

# Pack the Treeview widget
tree.pack(pady=20)

# Entry widget for adding columns
entry_column_name = tk.Entry(root)
entry_column_name.pack()
entry_column_name.insert(0, "New Column Name")

# Run the Tkinter main loop
root.mainloop()

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: python spreadsheet

Link to this answer
Share Copy Link

Contributed on Sep 14 2023

Sujan Ram

0 Answers Avg Quality 2/10

spreadsheet as above

Contents

More Related Answers

spreadsheet as above

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.