LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Anshul

I am a user of old lavastorm and not very familiar with the new 'cool' nodes.

I am looking for completely automating an existing manual work involving following steps:

1. query database.
2. write query result as raw data to an excel sheet
3. create some pivots and charts.
4. Send the excel (with raw data, pivots and charts) in an email attachment to the user.

I know how to do the steps 1, 2 and 4 in lavastorm.
But I do not know how to do step 3.

Can someone advise how to achieve this or suggest an alternative way?

Thanks in advance.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

Hi,

1. what you could possibly do is to use Output Image node for generating file out of the charts and send that file as an attachment using SendMail+ node.
2. there is another way which will not use Lavastorm charts... You can prepare your excel to create charts and pivots and then use appendExcel node to insert the data. Excel will then handle the rest for you.

Marek