Python 3: pretty_html_table returning HTML text rather than table

Question

I'm writing a script to email a pandas dataframe as a table to several people. I have my dataframe frame:

     SITE  ...   VISITS
438     1  ...      104
439     2  ...      104
440     3  ...      104
504     4  ...      215

I'm trying to create a pretty_html_table that I can email using:

from pretty_html_table import build_table

html_table = build_table(frame, 'blue_light')

However, instead of emailing a table, the script emails a bunch of html text!

<p><table border="0" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th style = "background-color: #FFFFFF;font-family: Century Gothic;font-size: medium;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px">SITE</th>
etcetera, etcetera ...

I'm trying to append this table to an email like so:

import win32com.client as win32

def report_email(email):        
    html_table = build_table(frame, 'blue_light')
    
    outlook = win32.Dispatch('outlook.application')
    mail = outlook.CreateItem(0)
    mail.To = email
    mail.Subject = 'Table below'
    mail.Body  = "Hi, here is a table" + html_table
    
    return mail.Send()

Thanks so much for all you help!

buran · Accepted Answer · 2020-12-29 08:29:04Z

2

pretty_html_table.build_table is expected to return the HTML code for the table. The problem is that you use mail.Body. Use mail.HTMLBody instead.

Here is MailItem.HTMLBody docs

answered Dec 29, 2020 at 8:29

buran

14.4k13 gold badges45 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Oliver Over a year ago

Thanks so much! This works, except now the text in my mail.Body doesn't send ... anyway to send both? Preferably the text, then the html table below

buran Over a year ago

Why would you have anything in Body, if you want to send HTMLBody? Everything should be in HTMLBody. You can send mail as plain text or as HTML, not both (open Outllok and check the settings).

Collectives™ on Stack Overflow

Python 3: pretty_html_table returning HTML text rather than table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related