Generate Excel report (file as attachment) in a service for email distribution

Ask the community
1

Hi

Our client wants an excel report every on critical data sent by e-mail every day. When I build this in a service I miss the action node Export Data to generate the file.

I have looked into how to generate Excel files but that requires the Run Code action node which is also missing.

How can I achieve this?

My current approach is to use Create file object to build a CSV from a javscript function but I would prefer to use the Appfarm action nodes for this instead..

Generate document only supports PDF… I have read this post: Generate Excel document - #2 by Simona but it is not feasible to do this from an app, it needs to run as service.

Regards,

Johan

2

Hi!

Unfortunately, the only possibility at the moment is to use “Create File Object” node with custom file from code.

You can find an example on this at the bottom of this page:

1 Like
3

Hi

Thanks I managed to solve it satisfactory by generating a CSV. I still think this should be considered for further development.