I have a excel sheet with 7 collums and 20 rows. I need to capture data from excel in formatted tabular way and email the data in body (Not as attachment)
I tried it with converting excel to csv and capturing data using variable, but the data is not formatted !!!
Hi
If you are sending the email in html format this would be quite simple. Use the CSV iterator to loop through the values and for each row, append a html row (containing the values) to a string, which you can then set as the body of the email.
If the email is plain text then this may be quite difficult if the values in your spreadsheet are varying length. If you need to create a table in a plain text email, it may be easiest to use the xml actions to create an xml document, then create a xslt which will style the data neatly into a plain text table.
Regards,
Steve