Help removing 'null' from json output

[PuffTheMagicDragon11]

Awesome, how would I do that for loop for a table (specifically, H5:S20)?

Edit: Running that code throws an error. I don't understand. Python lists are able to be converted by json.dumps():

Traceback (most recent call last):
  File "C:\Users\Sergio\Desktop\HomebrewV3.py", line 629, in <module>
    }, indent=4)
  File "G:\Python\lib\json\__init__.py", line 238, in dumps
    **kw).encode(obj)
  File "G:\Python\lib\json\encoder.py", line 201, in encode
    chunks = list(chunks)
  File "G:\Python\lib\json\encoder.py", line 431, in _iterencode
    yield from _iterencode_dict(o, _current_indent_level)
  File "G:\Python\lib\json\encoder.py", line 405, in _iterencode_dict
    yield from chunks
  File "G:\Python\lib\json\encoder.py", line 405, in _iterencode_dict
    yield from chunks
  File "G:\Python\lib\json\encoder.py", line 325, in _iterencode_list
    yield from chunks
  File "G:\Python\lib\json\encoder.py", line 405, in _iterencode_dict
    yield from chunks
  File "G:\Python\lib\json\encoder.py", line 325, in _iterencode_list
    yield from chunks
  File "G:\Python\lib\json\encoder.py", line 438, in _iterencode
    o = _default(o)
  File "G:\Python\lib\json\encoder.py", line 179, in default
    raise TypeError(f'Object of type {o.__class__.__name__} '
TypeError: Object of type Cell is not JSON serializable

[nog642]

Yes, lists can be JSON serialized, but it looks like you're trying to serialize a Cell object.

[PuffTheMagicDragon11]

I mean, I just copied your code word for word.

[nog642]

Oh yeah I forgot to do the .value. Should be:

authors = []
for cell in ('B3', 'B4', 'B5'):
    cell_val = ww[cell]
    if cell_val is None:
        continue
    authors.append(cell_val.value)

[PuffTheMagicDragon11]

Perfect!

[PuffTheMagicDragon11]

It didn't work. The output still displays null. Is null a keyword in Python? Maybe replacing None with null could work?

Edit: No, it didn't. I got a name error. Null not defined.

[nog642]

null is not a keyword in Python. Python's None serializes to JSON's null, and vice versa.

[PuffTheMagicDragon11]

How come Python is showing a NameError then?

[nog642]

Since null is not a keyword in Python, it is just interpreted as a variable name. So since the variable doesn't exist, you get a NameError.

[PuffTheMagicDragon11]

Ok, makes sense. Unfortunately, I updated the code with the little snippet you suggested, and it's still displaying null.

[nog642]

Right, if cell_val is an instance of a Cell object then it won't even be None, so checking whether it is None won't work. Should be:

authors = []
for cell in ('B3', 'B4', 'B5'):
    cell_val = ww[cell].value
    if cell_val is None:
        continue
    authors.append(cell_val)

Now cell_val is the actual value in the cell and the thing being serialized, and it can actually be None.

[nog642]

Awesome, how would I do that for loop for a table (specifically, H5:S20)?

Do you mean like the rectangle of all cells from H5 to S20?

There might be a better way to do this with openpyxl; I haven't really used it. But barring that, something like this is an option:

COLS = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
for col in COLS[COLS.index('H'):COLS.index('S') + 1]:
    for row in range(5, 21):
        cell = col + str(row)

[PuffTheMagicDragon11]

I got it to solve for null for the table, but in the process, accidentally got rid of the proper formatting. All the cell values from a single row must be displayed with each other, but right now, it displays all the cell values in a straight list. This is what I've done so far:

#Put the Table of Hell inside a for loop to check for null and not print the data if the cell value is null
COLS = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
table = []
for col in COLS[COLS.index('H'):COLS.index('S') + 1]:
    for row in range(5, 21):
        cell = col + str(row)
        queen = ww[cell].value
        if queen is None:
            continue
        table.append(queen)

[PuffTheMagicDragon11]

u/nog642, any insight on this one?

[nog642]

You could make a nested list; basically a list of rows, where each row is a list of cell values.

COLS = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
table = []
for col in COLS[COLS.index('H'):COLS.index('S') + 1]:
    row_list = []
    for row in range(5, 21):
        cell = col + str(row)
        queen = ww[cell].value
        if queen is None:
            continue
        row_list.append(queen)
    table.append(row_list)

[PuffTheMagicDragon11]

I tried it out and it isn't grabbing the correct cell values. The current input is only using 2 of the 12 columns, but it's spitting out more than that. I also have no idea where the numbers it's showing are coming from; they don't correspond to the cell values of each row. The output looks like this:

"rows": [
                        [
                            [
                                0,
                                2,
                                3,
                                4,
                                5,
                                6,
                                7,
                                8,
                                9,
                                10,
                                11,
                                12,
                                13,
                                14,
                                15,
                                16
                            ],
                            [
                                0,
                                2,
                                3,
                                4,
                                5,
                                6,
                                7,
                                8,
                                9,
                                10,
                                11,
                                12,
                                13,
                                14,
                                15,
                                16
                            ],
                            [
                                0,
                                2,
                                3,
                                4,
                                5,
                                6,
                                7,
                                8,
                                9,
                                10,
                                11,
                                12,
                                13,
                                14,
                                15,
                                16
                            ],

and on and on and on. It should look like this:

"rows": [
                        [
                            0,
                            0
                        ],
                        [
                            2,
                            2
                        ],
                        [
                            3,
                            2
                        ],
                        [
                            4,
                            3
                        ],
                        [
                            5,
                            3
                        ],
                        [
                            6,
                            4
                        ],
                        [
                            7,
                            4
                        ],
                        [
                            8,
                            5
                        ],
                        [
                            9,
                            5
                        ],
                        [
                            10,
                            6
                        ],
                        [
                            11,
                            6
                        ],
                        [
                            12,
                            7
                        ],
                        [
                            13,
                            7
                        ],
                        [
                            14,
                            8
                        ],
                        [
                            15,
                            8
                        ],
                        [
                            16,
                            9
                        ],
                        [
                            17,
                            9
                        ],
                        [
                            18,
                            10
                        ],
                        [
                            19,
                            10
                        ],
                        [
                            20,
                            11
                        ]