excel - json

[buran]

Sorry, but I really don't understand what you are doing and not having your file or the code you actually run does not help. And frankly I am tired of guessing...

[jmabrito]

I've already arranged .j just prints the lines where they exist. Iteration case

[jmabrito]

Sorry, but I really don't understand what you are doing and not having your file or the code you actually run does not help. And frankly I am tired of guessing...

[quote]
I've already arranged .I just prints the lines where they exist. Iteration case.
Guessing is not: In an excel with hundreds of lines, not all cells in the lines are filled. I want to know which row has 12 cells filled and what the value of column T of that row is. And this is it. the file has 20 columns which is the T column
Thanks

[jmabrito]

Thank you Mr Buran.
I finished the program !!!
I know that it is not at all well structured, with linear variables and little connected with the tables. what I lacked was:
for value in sheet.iter_rows(min_row=2,
max_row=19,
values_only=True):
# print(value)
print (len (value))
x = value.count(None)
print (x)

So I got to know who came in first!
With the recording in excel, and ending with shutil of the bsaid and bcart tables, the program was concluded. Thank you very much for your time. I know it is difficult to answer without having the complete program. Thanks again jmabrito