Need hep to loop through excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aboka
    New Member
    • Jan 2023
    • 1

    Need hep to loop through excel

    hi, im new to python and would like to learn howto loop through the excel(A2, B2, A3, B3....) and read its field value so i could send it to a function. the code below works fine, but it only reads the first row. thanks in advance.

    Code:
    wb = openpyxl.load_workbook(r'C:\Users\user\Desktop\blaster\sms.xlsx')
    sheet = wb.active
    
    x1 = sheet['A1'].value #phone number
    x2 = sheet['B1'].value #text message
    
    object.sendmsg(x1, x2)
Working...