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
When you download the plugin from the app market, it should include some documentation.
Hi Stefan Helzle , I have seen your reply for below query
https://community.appian.com/discussions/f/process/31199/convert-html-to-csv-smart-service-set-row-1-in-csv
I checked that plugin i didn't find about that ,Can I get any inputs from you?,It would be helpful for me.
OK, I was just confused since I looked in that older thread you linked and the only thing Stefan mentioned was the "text from template smart service" which I linked.
But also, if you're just trying to create a CSV from data in a local variable, what's wrong with the "text from template smart service", using a CSV file as your template? All you'd do is output text with rows delimited by a newline (afaik) and columns delimited by, i believe, a comma.
Not sure why you need that HTML? Would you mind describing the whole use case you have?
Hi Mike Schmitt ,Stefan Helzle the requirement is in below query
https://community.appian.com/discussions/f/user-interface/38954/data-into-excel
As chris suggested some code I am trying to create CSV file so we have plugin to create excel with csv
Process flow :
Creating html document from local variable data by passing into process variable (using generate html from Doc smart service )
Giving html document as input to smart service to create CSV files
Atlast that CSV file is giving as input to CSV to excel converter smart service
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