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.
Are you asking about the Text Doc from Template smart service?
Seems like there is no documentation. What a pity!
I assume this uses some kind of CSS selector to find the data table in the HTML.
No Mike Schmitt it's HTML to CSV smart service
Stefan Helzle can you suggest any other ways to create CSV I have data in one local variable (list of text string),iam passing data from that local variable to process variable
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
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.)