SendSMS.py

from openpyxl import load_workbook
from openpyxl.worksheet.worksheet import Worksheet
from requests import get

xlsxFileAddress = "/home/saeb/PycharmProjects/SendSMS/xlsx/139804.xlsx" #xlsx file


def sendToSMSCenter(phone="09133917225", text="سلام دنیا"):
    params = {
        "from": "+98100020400",
        "to": phone,
        "msg": text,
        "uname": "uname",  #change uname and password
        "pass": "password"  #change password
    }
    url = "http://37.130.202.188/class/sms/webservice/send_url.php"
    return get(
        url=url,
        params=params
    ).content


def SendSMS(xlsxFileAddress,
            print_only=True,
            start_message="باسلام و احترام",
            endt_message="روابط‌عمومی مجتمع مس‌ شهربابک"
            ):
    xlsx = load_workbook(
        filename=xlsxFileAddress,
    )
    sheet: Worksheet = xlsx[xlsx.sheetnames[0]]
    maxColumn = sheet.max_column

    head = []
    for i in range(2, maxColumn + 1):
        cell = sheet.cell(row=1, column=i).value
        if cell == None:
            break
        head.append(cell)
    for _row in range(2, sheet.max_row + 1):
        phoneNumber = sheet.cell(row=_row, column=1).value
        textMessage = "{}\n".format(start_message)
        for _column in range(len(head)):
            textMessage = "{}\n{}:\n{}".format(textMessage, head[_column],
                                               sheet.cell(row=_row, column=(2 + _column)).value)
        print("\n====================\n phoneis:\n{}\ntextis:\n{}\n==============".format(phoneNumber, textMessage))
        if (not print_only):
            sendToSMSCenter(phoneNumber, textMessage)


SendSMS(xlsxFileAddress=xlsxFileAddress, print_only=False)