Shell Programming and Scripting

# read two space-separated columns from stdin into two variables
while read ROW_NUMBER SKU_NAME
do
  echo "ROW_NUMBER=$ROW_NUMBER and SKU_NAME=$SKU_NAME"
done < arrayfile
# the stdin of the while-do-done block is from arrayfile

while read ROW_NUMBER SKU_NAME
do
    osascript <<EOD
    tell application "Microsoft Excel"
        activate    
        make new hyperlink of cell "B${ROW_NUMBER}" at active sheet with properties {address:"http://switchauto.tigroup.ca/SCL_Preflight_Report_Page/$SKUNAME_report.html"}
        set theLeft to left position of cell "A${ROW_NUMBER}"
        set theTop to top of cell "A${ROW_NUMBER}"
        set currentWorkbook to workbook 1
        tell currentWorkbook
            tell worksheet 1
                set pictureShape to make new shape at the beginning with properties {height:"72", width:"72", left position:0, top:theTop, placement:placement move}
                user picture pictureShape picture file "Macintosh HD:Library:WebServer:Documents:FilesForExcel:Jpeg:${SKU_NAME}_02.jpeg"
            end tell
EOD
# the EOD must be at the very left
done < arrayfile