Hi,
I am trying to generate a CSV file from HTML(convert HTML to CSV plugin), but in the plugin's smart service, there is a parameter called 'CSS query' (text type). I am confused about what to put in that. Can anyone help with this?
You will see this parameter in data --->input section
Discussion posts and replies are publicly visible
Why would you bother with the intermediary HTML and CSV steps, as opposed to just creating an Excel document directly?
How can I create excel directly, I am attaching sample output ,I want to create excel for below data ,is this possible Directly ?
I have data in the below format , do we have direct plugin to convert below data into excel
This is a very complicated way ... I think I can help you.
This is your CSV output. Write it to a file using the smart service "Text Doc from Template".
Thanks for your efforts Stefan Helzle
I wanted to pass csv file to "Generate Excel from CSV" smart service this plugin accepting only csv file as input,
But "Text Doc from Template" giving output in DOCX extension
If you create a simple text file with a placeholder like "###content###", not in MS WORD !!!, and change the extension to "csv", the output will keep that extension.
Thank you very much Stefan Helzle , Its working now as expected
I also just became aware of a newer plugin called "JSON to Excel" which would allow you to take your array data, format it into a JSON string, then pass it into that smart service and create an EXCEL document directly, without needing the CSV intermediary. As a bonus, this smart service accepts a base template, meaning you could provide an empty template with pre-named, pre-formatted columns (you can set custom column widths, give friendly column names with colors/styles applied, etc, all of which will persist in the final generated file.)