#!/usr/bin/env python # -*- coding: us-ascii -*- # Taken from a Stack-Overflow question. import openpyxl, pprint print('Opening Workbook...') wb = openpyxl.load_workbook('C:/Users/Bijan/Desktop/Forest Baker #1-1H/Forest Baker #1-1H Email Cheat Sheet.xlsm' , data_only = True) sheet = wb.get_sheet_by_name('Lateral_FlashLight') sheet.title print(sheet.title) sheet['e10'] print(sheet['e10'].value) degree_sign= u'\N{DEGREE SIGN}' import openpyxl, pprint print('Opening Workbook...') print("") wb = openpyxl.load_workbook('C:/Users/Bijan/Desktop/Forest Baker #1-1H/Forest Baker #1-1H Email Cheat Sheet.xlsm' , data_only = True) sheet = wb.get_sheet_by_name('Lateral_FlashLight') sheet.title print(sheet.title) print("") sheet['e10'] well_name = sheet['e12'].value well_value = sheet['f12'].value rig_name = sheet['e13'].value rig_value = sheet['f13'].value plan_name = sheet['e14'].value plan_value = sheet['f14'].value md_name = sheet['e17'].value md_value = str(sheet['f17'].value) inc_name = sheet['e18'].value inc_value = str(round(sheet['f18'].value, 2)) azm_name = sheet['e19'].value azm_value = str(round(sheet['f19'].value, 2)) tvd_name = sheet['e20'].value tvd_value = str(round(sheet['f20'].value, 2)) vs_name = sheet['e21'].value vs_value = str(round(sheet['f21'].value, 2)) dls_name = sheet['e22'].value dls_value = str(round(sheet['f22'].value, 2)) gamma_name = sheet['e23'].value gamma_value = str(round(sheet['f23'].value, 2)) temp_name = sheet['e24'].value temp_value = str(round(sheet['f24'].value, 2)) slide_name = sheet['e27'].value slide_value = str(sheet['f27'].value) tf_name = sheet['e28'].value tf_value = str(sheet['f28'].value) build_name = sheet['e29'].value build_value = str(round(sheet['f29'].value, 2)) motor_name = sheet['e30'].value motor_value = str(sheet['f30'].value) up_name = sheet['e33'].value up_value = str(sheet['f33'].value) left_name = sheet['e34'].value left_value = str(sheet['f34'].value) pslide_name = sheet['e35'].value pslide_value = str(sheet['f35'].value) ptf_name = sheet['e36'].value ptf_value = str(sheet['f36'].value) fmd_name = sheet['e39'].value fmd_value = str(sheet['f39'].value) finc_name = sheet['e40'].value finc_value = str(round(sheet['f40'].value, 2)) fazm_name = sheet['e41'].value fazm_value = str(round(sheet['f41'].value, 2)) ftvd_name = sheet['e42'].value ftvd_value = str(round(sheet['f42'].value, 2)) fvs_name = sheet['e43'].value fvs_value = str(round(sheet['f43'].value, 2)) fgam_name = sheet['e44'].value fgam_value = str(round(sheet['f44'].value, 2)) Subject = (sheet['e10'].value) Comp = ( print(well_name , well_value ,), print(rig_name , rig_value ,), print(plan_name , plan_value ,), print (""), print(sheet['e16'].value ,), print(md_name , md_value + u'\x27' ,), print(inc_name , inc_value + u'\xb0' ,), print(azm_name , azm_value + u'\xb0' ,), print(tvd_name , tvd_value + u'\x27' ,), print(vs_name , vs_value + u'\x27' ,), print(dls_name , dls_value + u'\xb0' ,), print(gamma_name , gamma_value +' API' ,), print(temp_name , temp_value + u'\xb0' ,), print(""), print(sheet['e26'].value), print(slide_name , slide_value + u'\x27'), print(tf_name , tf_value + u'\xb0'), print(build_name , build_value + u'\xb0'), print(motor_name , motor_value + u'\xb0'), print(""), print(sheet['e32'].value), print(up_name , up_value + u'\x27'), print(left_name , left_value + u'\x27'), print(ptf_name , ptf_value + u'\xb0'), print(""), print(sheet['e38'].value), print(fmd_name , fmd_value + u'\x27'), print(finc_name , finc_value + u'\xb0'), print(fazm_name , fazm_value + u'\xb0'), print(ftvd_name , ftvd_value + u'\x27'), print(fvs_name , fvs_value + u'\x27'), print(fgam_name , fgam_value +' API')) import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.mime.base import MIMEBase from email import encoders fromaddr = "[email protected]" toaddr = "[email protected]" msg = MIMEMultipart() msg['From'] = fromaddr msg['To'] = toaddr msg['Subject'] = Subject body = Comp msg.attach(MIMEText(body, 'plain')) filename = "Capture.png" attachment = open("c:\\users\\Bijan\\Desktop\\Capture.PNG", "rb") part = MIMEBase('application', 'octet-stream') part.set_payload((attachment).read()) encoders.encode_base64(part) part.add_header('Content-Disposition', "attachment; filename= %s" % filename) msg.attach(part) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(fromaddr, "ragincajuns") text = msg.as_string() server.sendmail(fromaddr, toaddr, text) server.quit()