fzumstein
Package tracker not working
Please, I'm using your book "Python for Excel" and I have reached chapter 11, and the Excel package tracker file is not working as shown in the book.
Hi, can you be a little more specific of what's not working? Do you see an error?
Yes please
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 3:07 PM Felix Zumstein @.***> wrote:
fzumstein left a comment (fzumstein/python-for-excel#16) https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839275207
Hi, can you be a little more specific of what's not working? Do you see an error?
— Reply to this email directly, view it on GitHub https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839275207, or unsubscribe https://github.com/notifications/unsubscribe-auth/BBNDW65JEZMEKND64IZR7TL236IRFAVCNFSM6AAAAAB4DIN23GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMZZGI3TKMRQG4 . You are receiving this because you authored the thread.Message ID: @.***>
[image: image.png]
Please, this is what pops up when I add the xlwings to the database.
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 3:41 PM Charles kwame Appiah @.***> wrote:
Yes please
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 3:07 PM Felix Zumstein @.***> wrote:
fzumstein left a comment (fzumstein/python-for-excel#16) https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839275207
Hi, can you be a little more specific of what's not working? Do you see an error?
— Reply to this email directly, view it on GitHub https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839275207, or unsubscribe https://github.com/notifications/unsubscribe-auth/BBNDW65JEZMEKND64IZR7TL236IRFAVCNFSM6AAAAAB4DIN23GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMZZGI3TKMRQG4 . You are receiving this because you authored the thread.Message ID: @.***>
This is the error "Error: TypeError("Connection.execute() got an unexpected keyword argument 'package_name'")" it pops up on my laptop. Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 3:56 PM Felix Zumstein @.***> wrote:
fzumstein left a comment (fzumstein/python-for-excel#16) https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839429178
The image didn't make it...
— Reply to this email directly, view it on GitHub https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2839429178, or unsubscribe https://github.com/notifications/unsubscribe-auth/BBNDW62RX3J6L4J6RGHCOT3236OLJAVCNFSM6AAAAAB4DIN23GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMZZGQZDSMJXHA . You are receiving this because you authored the thread.Message ID: @.***>
That's because the packages have meanwhile changed. Although I was aware of the issue with package versioning, I underestimated it—so first of all, my apologies!
I would recommend following the instructions in Appendix A:
(base)> cd C:\Users\username\python-for-excel\conda
(base)> conda env create -f xl38.yml
(base)> conda activate xl38
(xl38)>
You would then always use the (xl38) environment instead of (base). This makes sure that you are using the same versions of the packages as I used when writing the book.
Thank you for the clarification.
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 8:59 PM Felix Zumstein @.***> wrote:
fzumstein left a comment (fzumstein/python-for-excel#16) https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2840230957
That's because the packages have meanwhile changed. Although I was aware of the issue with package versioning, I underestimated it—so first of all, my apologies!
I would recommend following the instructions in Appendix A:
(base)> cd C:\Users\username\python-for-excel\conda (base)> conda env create -f xl38.yml (base)> conda activate xl38 (xl38)>
You would then always use the (xl38) environment instead of (base). This makes sure that you are using the same versions of the packages as I used when writing the book.
— Reply to this email directly, view it on GitHub https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2840230957, or unsubscribe https://github.com/notifications/unsubscribe-auth/BBNDW62XRAWOAHTQO5RWMO3237R45AVCNFSM6AAAAAB4DIN23GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQNBQGIZTAOJVG4 . You are receiving this because you authored the thread.Message ID: @.***>
Please, I have tried, but it is still not working.
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Thu, May 1, 2025 at 3:22 AM Charles kwame Appiah @.***> wrote:
Thank you for the clarification.
Charles Kwame Appiah Graduate Research Assistant The Brew Hammond Energy Centre Research interest lies in wind and hydropower, energy storage, green hydrogen and geothermal energy. Kwame Nkrumah University of Science and Technology - Kumasi, Ghana. Never give up until you see congratulations. Ghana - West Africa. +233550250056 / +233209251129
On Tue, Apr 29, 2025 at 8:59 PM Felix Zumstein @.***> wrote:
fzumstein left a comment (fzumstein/python-for-excel#16) https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2840230957
That's because the packages have meanwhile changed. Although I was aware of the issue with package versioning, I underestimated it—so first of all, my apologies!
I would recommend following the instructions in Appendix A:
(base)> cd C:\Users\username\python-for-excel\conda (base)> conda env create -f xl38.yml (base)> conda activate xl38 (xl38)>
You would then always use the (xl38) environment instead of (base). This makes sure that you are using the same versions of the packages as I used when writing the book.
— Reply to this email directly, view it on GitHub https://github.com/fzumstein/python-for-excel/issues/16#issuecomment-2840230957, or unsubscribe https://github.com/notifications/unsubscribe-auth/BBNDW62XRAWOAHTQO5RWMO3237R45AVCNFSM6AAAAAB4DIN23GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQNBQGIZTAOJVG4 . You are receiving this because you authored the thread.Message ID: @.***>
Hi,
I have the same exact issue as [ckappiah1999] where I was not able to run the packagetracker.xlsm properly. I tried installing the same packages as xl38 in appendix A and updated the Conda Env to xl38 (as suggested above by fzumstein), it was still not working until I re-installed the xlwings addin (see page 210 in the book).
For my case, I believed it was due to a later xlwings addin version was previously installed thus there is a mismatch between the xlwings addin and python package (see attached picture for the error caused by this mismatch). When I was following through the book, I did not start with Appendix A creating environment and installing the packages used when the book was written, therefore experiencing problem with packagetracker.xlsm. My conclusion is starting with Appendix A is the key for the packagetracker.xlsm to work properly. Hope this helps someone.
