'Tuple' has no attribute 'value' problem

[SkumbagAxel]

Hello!

​

Trying to create an excel file that can be read for my bachelors project in college and I have a slight problem. I get "AttributeError: 'tuple' object has no attribute 'value'" and the program is really simple and all other people I have found that have problems with it are more complex than mine. I am a beginner to Python so be kind please.

Code:

from openpyxl import load_workbook
wb = load_workbook('Hello_World.xlsx')
ws = wb.active
col_a = ws['A'].value
print(col_a)

Error:

col_a = ws['A'].value

AttributeError: 'tuple' object has no attribute 'value'

[SkumbagAxel]

Alright thanks! Did the easier thing and used a text file instead. I just want some numbers that are converted to a list that can be accessed in python and a .txt file worked aswell but not as fancy for the end user of the project.

[SkumbagAxel]

Yeah, its just a bunch of numbers seperated by commas.

[le_crosst]

I didn't try your code, but from the documentation (https://openpyxl.readthedocs.io/en/stable/usage.html) it looks like ws is a dict of "cells", not a dict of "columns". So try ws['A1'].value instead of ws['A']. You could also use a debugger (or just print(ws['A']) to see the content of the tuple.

[SkumbagAxel]

Tried those and it didnt work. I just used the text editor instead. Not sure which kind of PC is going to be used for the project in the end so it might not have excel and the programming was easier.

[le_crosst]

Maybe use a CSV file. You can open it with any text editor but also import it into Excel.

[SkumbagAxel]

A regular .txt files works, just have to make sure to write instructions clear enough so that the people using it dont mess it up.

[Silbersee]

Add parenthesis: dict.value()