DEV Community

AndySqlman
AndySqlman

Posted on • Edited on

Display Excel spreadsheet with graphics in the body of an email

Q: I have a completed Excel spreadsheet (such as the one below). Can I display this spreadsheet in the body of an email? How can I do this?

Image description

A: Yes, you can use SQLMessenger to convert the Excel spreadsheet into an HTML table and display it in the body of an email. Please note that these methods require Office 2010 or a later version installed on your computer.

Method 1: Insert the Excel spreadsheet into the email body when configuring the email body template.

  • This method is suitable for displaying simple Excel spreadsheets in the email body, processes quickly, but does not support formulas and other content within the spreadsheet.

Step1: Select the Excel spreadsheet file you want to insert
Image description

Step2: The system converts the contents of the first sheet of the Excel spreadsheet into HTML format and displays it in the email body
Image description

  • You can fine-tune the table contents in the body template.

Note: that the SQLMessenger body editor does not support direct modification of table and chart styles. If the size, position, or column width of the converted chart does not meet your requirements, delete the inserted table in the body template, adjust the table format in Excel, and re-import it. You can also directly modify the HTML code of the template in the body template editor to adjust the format.

  • Edit the HTML code in the body template editor

Image description

Method 2: Add a "Customize Spreadsheet Template" type attachment template to the task, and the system will display the content of the attached spreadsheet in the email body during task execution.

  • This method is suitable for handling tables with formulas or pivot tables. Due to the required format conversion during task execution, the processing speed is relatively slower.

  • Add a "Customize Spreadsheet Template" type attachment template to the task.
    Image description

Reposted from:https://www.sqlmessenger.com/faqview.html?id=526

Top comments (0)