Python get_excel_file示例

示例#1

文件： daily_deal_report_email.py 项目： daasara/riba

filename = ROOT_FOLDER + '/daily_deal_report_' + str(from_date) + '.doc'
filename2 = ROOT_FOLDER + '/daily_deal_report_' + str(from_date) + '.xls'

data_dict = daily_deal_report_data(from_date, to_date, 'booked')
data = data_dict['list']
headings = data_dict['headings']
excel_data = [headings]
for data_entry in data:
    list_entry_one = [data_entry['day'], data_entry['date']]
    list_entry_two = [
        data_entry['total_sales']['count'], data_entry['total_sales']['value']
    ]
    for line_entry in data_entry['entries']:
        excel_entry = list_entry_one + line_entry + list_entry_two
        excel_data.append(excel_entry)
workBookDocument = get_excel_file(excel_data[0], excel_data[1:])
workBookDocument.save(filename)
workBookDocument.save(filename2)

subject = 'Daily Deal Report - Booked orders'
message = 'Please find attached the daily deal report for yesterday. For more details, please access http://analytics.futurebazaar.com/category/deal_reports.'
msg_from = "Future Bazaar reports<*****@*****.**>"
msg_to = [
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "Ricia.D'*****@*****.**",
    "*****@*****.**", "*****@*****.**",
    "*****@*****.**", "*****@*****.**",

示例#2

from_date = (datetime.now()+timedelta(days=-1)).date()
to_date = (datetime.now()+timedelta(days=-1)).date()
order_state = 'booked'
filename = ROOT_FOLDER + '/sales_report_' + str(from_date) + '.doc'

category_data, data_list = category_report_data(from_date, to_date, order_state)
category_list = [['Category-wise Product Performance']]
for cat_data in category_data:
    category = cat_data['category']
    if category == None:
        category = 'None'
    category_list.append([category] + [])
    category_list.append(['Top ' + str(category) + ' Products by Volume'])
    category_list += cat_data['volume'] + [[]]
    category_list.append(['Top ' + category + ' Products by Value'])
    category_list += cat_data['value'] + [[]]
excel_list = data_list + [[]] + category_list

workBookDocument = get_excel_file(excel_list[0], excel_list[1:])
workBookDocument.save(filename)

subject = 'Daily Sales Report - Booked (as per new Category tree)'
message = 'Please find attached the Daily Sales Report for yesterday. For more details, please access http://analytics.futurebazaar.com/category/category_report.'
msg_from = "Future Bazaar reports<*****@*****.**>"
msg_to = ["*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "Ricia.D'*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**"]

em = EmailMessage(subject, message, msg_from, msg_to, [], None)
em.attach_file(filename)
em.send()
os.remove(filename)

示例#3

from_date = (datetime.now()+timedelta(days=-1)).date()
to_date = (datetime.now()+timedelta(days=-1)).date()
filename = ROOT_FOLDER + '/daily_deal_report_' + str(from_date) + '.doc'
filename2 = ROOT_FOLDER + '/daily_deal_report_' + str(from_date) + '.xls'

data_dict = daily_deal_report_data(from_date, to_date, 'booked')
data = data_dict['list']
headings = data_dict['headings']
excel_data = [headings]
for data_entry in data:
    list_entry_one = [data_entry['day'], data_entry['date']]
    list_entry_two = [data_entry['total_sales']['count'], data_entry['total_sales']['value']]
    for line_entry in data_entry['entries']:
        excel_entry = list_entry_one + line_entry + list_entry_two
        excel_data.append(excel_entry)
workBookDocument = get_excel_file(excel_data[0], excel_data[1:])
workBookDocument.save(filename)
workBookDocument.save(filename2)

subject = 'Daily Deal Report - Booked orders'
message = 'Please find attached the daily deal report for yesterday. For more details, please access http://analytics.futurebazaar.com/category/deal_reports.'
msg_from = "Future Bazaar reports<*****@*****.**>"
msg_to = ["*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "Ricia.D'*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**"]
em = EmailMessage(subject, message, msg_from, msg_to, [], None)
em.attach_file(filename)
em.attach_file(filename2)
em.send()
os.remove(filename)
os.remove(filename2)