Python Forum
Openpxl - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Openpxl (/thread-19008.html)



Openpxl - shernel - Jun-10-2019

The column I want perform the addition is in "V" The excel sheet layout would be similar but the row length would always change therefore I want the formula to be applied from V2 (as V1 would be the header) to the last row of the column V

How can I achieve that in openpyxl.

In other words, Il be loading excel file in the GUI that I created on loading it should automatically detect the the last row and add all the values in column V and give me an answer in another sheet.

Thanks in advance