I am newer to python and am trying to automate some work activities. We use an excel spreadsheet and input a few numbers at the end of the month for tracking. What I am trying to do is use Selenium to grab my numbers (I have this working already) then use Openpyxl to read and assign that number to the excel sheet. I need python to read say row 5 in my excel sheet and check if it is blank, if it is not blank then move to the next cell until it finds a blank one. Once it has the position of the blank cell I need to assign my number I got from selenium. I have to write a while loop that checks if the cell is blank and then assign the position of the blank cell into a variable and then do a ws[cell] = seleniumnumber right? Continue reading...
