Jun-10-2019, 08:23 AM
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
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