is there any way that I could export my table to xlsx in javascript in workflow? So that I could then attach this xlsx file to send an email via that workflow. Basically I want the same result as if I would click “Export data” in table.
I would like to add that you could create a report in Designer, where you prepare the export and then generate the report in Excel in the workflow—using a script, you select the target folder.
Another option that came to mind is the Pivot widget, which also offers the possibility of exporting data, but this method does not involve the workflow.