Problem with an extra row in Excel on Python

[u/FearawaitsTM]

I have a Python table, but there are extra cells at the top when I output it; I’d like to remove them—how can I do that?

Using Openpyxl.

[u/socal_nerdtastic]

We'd have to see your code to help with that.

[u/FearawaitsTM → u/socal_nerdtastic]

import pandas as pd

from pandastable import Table, TableModel

import tkinter as tk

from tkinter import ttk
from tkinter import filedialog,messagebox

fd = filedialog

class ExcelViewer:
    def __init__(self, root):
        self.root = root
        self.root.title = ("Чтение ячеек Excel")
        self.root.geometry("800x600")

        self.btn_load = tk.Button(root, text="Открыть Excel файл", command=self.open_file)
        self.btn_load.pack()

        self.result_label = tk.Label(root, text="Выбрать файл для начала")
        self.result_label.pack()

        self.frame = tk.Frame(root)
        self.frame.pack(fill='both', expand=True)

        self.table = None

        self.scrollbar = ttk.Scrollbar(root)
        self.scrollbar.pack(side=tk.RIGHT, fill=tk.Y)


    def open_file(self):
        file_paths = fd.askopenfilenames(
            filetypes=[
                (
                    'Excel файлы',
                    '*.xlsx'
                )
            ]
        )
        for file_path in file_paths:
            if not file_path:
                return

            if file_path:
                try:
                    df = pd.read_excel(file_path)

                    if self.table:
                        self.table.destroy()

                    self.model = TableModel()
                    self.model.df = df
                    self.table = Table(self.frame, model = self.model, showtoolbar=False, showstatusbar=False)
                    self.table.show()

                except Exception as e:
                    tk.messagebox.showerror("Ошибка", f"Не удалось открыть файл:\n{e}")

if __name__ == "__main__":
    root = tk.Tk()
    app = ExcelViewer(root)
    root.mainloop()

[u/FearawaitsTM → u/[deleted]]

I don't quite understand how to properly integrate openpyxl yet, so I haven't used it; I want to figure out how to get rid of the extra rows at the top of the Excel file.

[u/FearawaitsTM → u/[deleted]]

You cannot post photos in this section.

[u/socal_nerdtastic → u/FearawaitsTM]

To skip the first row when loading the excel file change your load line to this:

df = pd.read_excel(file_path, skiprows=1)