Query Parameter in Plugin

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.

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.)

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.)