[Python] Opening an Excel File with Python [duplicate]

Discussão em 'Python' iniciado por Stack, Outubro 7, 2024.

  1. Stack

    Stack Membro Participativo

    I've been trying to figure this out for a couple of days now, and I cannot seem to get it. I simply need to open an existing Excel file, then I'll do some stuff with it, but I cannot seem to get the Excel file to open.

    Here's what I've tried most recently:

    import pyautogui
    import openpyxl
    from openpyxl import load_workbook
    import pathlib
    from pathlib import Path

    wb_folder = Path("C:/Users/reber/Gaming/Rise of Castles/Member_Details/")

    #md_wb = openpyxl.load_workbook('C:\Users\reber\Gaming\Rise of Castles\Member_Details\Member_Details.xlsx')
    #md_wb = openpyxl.load_workbook('C:\Users\reber\Gaming\Rise of Castles\Member_Details\Member_Details.xlsx')
    #md_wb = openpyxl.load_workbook(r'C:\Users\reber\Gaming\Rise of Castles\Member_Details\Member_Details.xlsx')
    #md_wb = openpyxl.load_workbook(r"C:\Users\reber\Gaming\Rise of Castles\Member_Details\Member_Details.xlsx")
    md_wb = wb_folder / "Member_Details.xlsx"

    f = open(md_wb)

    p = pathlib.Path(__file__)
    print (p)

    Continue reading...

Compartilhe esta Página