root@pi3plus:/var/www/html/upload/cgi-bin/files# pwd
/var/www/html/upload/cgi-bin/files

files

script_sendsms.sh  script_test.sh  sendsms.log  sms_message.txt  tmp.txt

first version

script_sendsms.sh

#!/bin/bash

re='[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
smsgw=root@10.11.12.253
inputfile=$(ls files/* | grep xlsx)

xlsx2csv $inputfile --all > files/all.csv ;

echo `date`----- >> files/tmp.txt

while IFS=, read -r col1 col2
do  number=$(echo $col1 | grep '^[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
  echo $number

if [ "$number" != '' ]; then
#   echo yes
    echo 0$number
    echo 0$number >> files/tmp.txt
#   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/id_rsa.pub $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
#   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
    ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'" < /dev/null
#    sleep 5
   echo Remote Command Return Code: $?
#    sshtest=$(ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'")
#    sshtest = $(ssh -o "StrictHostKeyChecking=no" $smsgw "asterisk -x 'dongle sms dongle0 i80$number testing'")
#    echo $sshtest
else
    echo no
fi
done < files/all.csv

rm files/*.xlsx
rm files/*.csv

New version passing the text field

#!/bin/bash

re='[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
smsgw=root@10.11.12.253
inputfile=$(ls files/* | grep xlsx)
logfile=files/sendsms.log
message=$(cat files/sms_message.txt)

xlsx2csv $inputfile --all > files/all.csv ;

echo `date`----- >> $logfile

while IFS=, read -r col1 col2
do  number=$(echo $col1 | grep '^[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
 echo $number

if [ "$number" != '' ]; then
#   echo yes
#    echo 0$number
    echo 0$number >> $logfile
#   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/id_rsa.pub $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
     ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle sms dongle0 0$number $message'"
#    ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'" < /dev/null
#    ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle show devices'" < /dev/null
    echo 0$number
    sleep 2
    echo Remote Command Return Code: $? >> $logfile
#   sshtest=$(ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'")
#   sshtest = $(ssh -o "StrictHostKeyChecking=no" $smsgw "asterisk -x 'dongle sms dongle0 i80$number testing'")
#   echo $sshtest
else
    echo no >> $logfile
fi
done < files/all.csv

rm files/*.xlsx
rm files/*.csv