Hi, I am brand new to Anaconda. I am just getting started with Python (3.9.12) and I am need some help getting past the first step of the install. I have downloaded Anaconda, and VisualStudio for Windows. I am using the openpxyl library. I am trying to access an Excel file as a simple example.
I keep getting an error:
FileNotFoundError: [Errno 2] No such file or directory: ‘C:\Users\My Name\Documents\Me Personal Documents\Excel Files\Python File\file.xlsx’
I cannot figure out what I am doing wrong as the file path is correct.
I am using the cmd Prompt as well
Is there a chance that Visual Studio is using a different Python extension? Its unclear to me how Visual Studio and Anaconda interact with one another.
import openpyxl
book = openpyxl.load_workbook(r’C:\Users\My Name\Documents\Me Personal Documents\Excel Files\Python File\file.xlsx’)
Get the worksheet
sheet = book[“Results”]
Print the value at A10 on sheet Results
print(sheet[“A10”].value)
Thank-you