Update reading_specific_cells.py

[piperwarrior]

trafficstars

[piperwarrior]

Hmm. I’ll try to reproduce it. Could be because I’m on Python 3.7. The print format looks unfamiliar to me, but it could be because I am not familiar with changes on 3.8.

On Thu, Mar 30, 2023 at 8:05 PM Mike Driscoll @.***> wrote:

@.**** commented on this pull request.

In 02_reading_spreadsheets/reading_specific_cells.py https://github.com/driscollis/automating_excel_with_python/pull/17#discussion_r1153897022 :

@@ -8,10 +8,10 @@ def get_cell_info(path): sheet = workbook.active print(sheet) print(f'The title of the Worksheet is: {sheet.title}')

• print(f'The value of {sheet["A2"].value=}')
• print(f'The value of {sheet["A3"].value=}')

• print(f'The value of A2 is {sheet["A2"].value}')
• print(f'The value of A3 is {sheet["A3"].value}')

Did you have an error running the original code? This code should work in 3.8 and above:

https://docs.python.org/3/whatsnew/3.8.html#f-strings-support-for-self-documenting-expressions-and-debugging

— Reply to this email directly, view it on GitHub https://github.com/driscollis/automating_excel_with_python/pull/17#pullrequestreview-1366087231, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADFJNQKWBTU2ILG3D5YUUC3W6YNTNANCNFSM6AAAAAAWNZU56E . You are receiving this because you authored the thread.Message ID: @.*** com>

--

Rohit Sood President

Fintuitive 26 Park St., Suite 2025 | Montclair, NJ 07042 M: +1-917-502-7029 | E: @.*** www.fintuitive.com

LinkedIn Profile https://www.linkedin.com/in/rohit-sood/