Overview
This plug-in is designed to automate the transformation of HTML-based data into Excel documents within Appian applications. It is particularly useful for generating structured reports, exporting comparison data, and delivering client-ready Excel outputs without manual intervention.
Key business use cases include:
The plugin is especially valuable in data-heavy workflows such as policy checking automation, where comparison results need to be delivered in Excel format quickly and accurately.
Key Features & Functionality
The plugin provides robust HTML-to-Excel conversion capabilities within Appian using smart services.
Key features include:
Smart Services:
These smart services:
Shaik Ahamed great plugin!I have a question: I am trying to use html code to excel. I tried to make columns in excel wider and formatted, but nothing works for me. I tried multiple approaches (including the code below), which creates nice html, but after exporting, i see all columns with the same width. Is there any example for this?Thanks
"<html>
<style>table {width: 600px; border-collapse: collapse;table-layout: fixed; }
th, td {border: 1px solid #ccc;padding: 8px;}
th.id, td.id {width: 100px;}
th.name, td.name {width: 150px;}
th.status, td.status {width: 350px; }</style>
<table> <tr> <th class=""id"">ID</th> <th class=""name"">Name</th> <th class=""status"">Status</th> </tr> <tr> <td class=""id"">1</td> <td class=""name"">John</td> <td class=""status"">Pending approval with additional details</td> </tr> <tr> <td class=""id"">2</td> <td class=""name"">Emma</td> <td class=""status"">Completed</td> </tr></table></html>"
Hi peterb0003,
Thank you for trying the plugin and for sharing the example.
For better Excel column sizing results, please try using ch units instead of px values when defining column widths. The converter maps ch values more accurately to Excel column widths.
Example:
You can then adjust the ch values based on the width you want in Excel.
Please give this approach a try — it should solve your issue.
Hi Shaik Ahamed , It works perfectly, thank you very much!BTW, is there any way to also use colors/links/background colors? i tried style before, also old <font color>, but without success. Maybe some documentation would be perfect to have!