I have an Excel workbook which contains 2 worksheets, one is hidden and contains data grid, and another contains some texts (titles, descriptions) and a few charts which data source is from the hidden worksheet.
I want to export the sheet that has charts into outlook email, how can I achieve that?
I tried to save the excel into a memory stream (in Html format) and then extract the html string and set it to the HtmlBody of Aspose.Email.MailMessage but it resulted in “This page uses frames, but your browser doesn’t support them.” in the mail body.
I also tried to save it in memory stream with MHtml format and load it by MailMessage.Load() method , but it resulted in chart in image files in attachments and also some other unknown files which “cannot be previewed”.
Is there a way to export ole objects from Excel worksheet to email? Just like press Ctrl +A in a worksheet and then copy it and paste the data in email? In that way, we still can edit the charts in email, like change the size of chart, add chart elements, change chart styles, chart filters, etc.