driscollis/automating_excel_with_python

Code from the book, Automating Excel with Python by Michael Driscoll

Hi, I'm Mike!

I am the author of the popular Python blog, The Mouse vs the Python. You can follow me on Twitter or check out my YouTube Channel where you can learn Python.

automating_excel_with_python's Issues

Border doesn't apply when only the top left cell is used in a merged cell

On pages 52-54 (Chap 4), Styling Merged Cells, the border styling is being set on a merged cell range, "A2:G4". The selected cell in the example is the top left cell; 'A2'.

The file "style_merged_cell.py" is the example, when executed, it only applies to the border on cell 'A2'. (this is the same code as provided in the book.)

Here is what is present in the newly created spreadsheet. It's close to the image that is shown in the book, the only difference is A1 is selected in the book so the border is not visible.

Instead I, looped over the range applying the border styling to each cell in the merged range and the border was as expected.

    cell_range = "A2:G4"
    for column in sheet[cell_range]:
        for cell in column:
            cell.border = Border(top=double, left=thin, right=thin, bottom=double)

How to read cell value if formula is applied on the column?

Hi Mike,
Had a question on reading_specific_cell.py. I have applied formula on custom sales excel data where sales value to copies sold * value of the book.

reading_specific_cells.py has the below output

<Worksheet "sales">
The title of this worksheet is: sales
Value of A5 is: 5
Value of E14 is: A Short History of Nearly Everything
=(C14*D14)

Please suggest if there's a way to read the actual value instead or should cells for the formula be read and multiplied, something like

    print(f'Value of E14 is { sheet["C14"].value * sheet["D14"].value}')

if that's the way, can we identify such columns ahead of starting any operations on them?