Html To Excel Transformation

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:

Exporting Appian data into Excel format for reporting and analysis
Generating policy comparison reports for insurance workflows
Automating report delivery to clients and business stakeholders
Converting structured HTML (tables) into Excel for downstream processing
Reducing manual Excel creation effort and improving turnaround time

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:

Supports both HTML file input and raw HTML code input
Converts structured HTML (table-based) into Excel (.xlsx) format
Generates downloadable Excel documents within Appian
Seamless integration with Appian process models and workflows
Designed for high-performance report generation use cases
Supports inline and internal CSS styling (within supported limits)
Secure processing within Appian environment (no external data exposure)
Compatible with Appian Cloud (Java 17) and on-prem environments

Smart Services:

Html File To Excel
Html Code To Excel

These smart services:

Accept HTML input (file or code)
Convert the content into Excel format
Save the generated document into Appian Document Management System
Return the generated Excel file for further use

peterb0003 27 days ago in reply to peterb0003

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!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Shaik Ahamed 28 days ago in reply to peterb0003

Hi peterb0003 ,

Thank you for testing it again and for sharing the screenshot.

I checked the issue, and the fix is to define the column widths using a <colgroup> instead of applying widths directly to the th/td classes. The converter currently reads <colgroup> widths more reliably when generating Excel files.

Please try the following example:

<html>
    <head>
        <style>
            table {
                width: 60ch;
                border-collapse: collapse;
                table-layout: fixed;
            }

            .colgroup-basic col:nth-child(1) {
                width: 10ch;
            }

            .colgroup-basic col:nth-child(2) {
                width: 15ch;
            }

            .colgroup-basic col:nth-child(3) {
                width: 35ch;
            }

            th,
            td {
                border: 1px solid #ccc;
                padding: 8px;
            }
        </style>
    </head>

    <body>
        <table class="colgroup-basic">
            <colgroup>
                <col />
                <col />
                <col />
            </colgroup>

            <tr>
                <th>ID</th>
                <th>Name</th>
                <th>Status</th>
            </tr>

            <tr>
                <td>1</td>
                <td>John</td>
                <td>Pending approval with additional details</td>
            </tr>

            <tr>
                <td>2</td>
                <td>Emma</td>
                <td>Completed</td>
            </tr>

        </table>
    </body>
</html>

This approach should correctly apply different column widths in the generated Excel file.

Please give this version a try and let me know how it works for you.

peterb0003 28 days ago in reply to Shaik Ahamed

Hi Shaik Ahamed , thanks for quick answer. I tried this approach, but sitill can not see the result:
- Cancel
- Up +1 Down
- Reply
- More
- Cancel
Shaik Ahamed 29 days ago in reply to peterb0003
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:

<html>

<style>

table {

width: 60ch;

border-collapse: collapse;

table-layout: fixed;

}

th, td {

border: 1px solid #ccc;

padding: 8px;

}

th.id, td.id {

width: 10ch;

}

th.name, td.name {

width: 15ch;

}

th.status, td.status {

width: 35ch;

}

</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>

Use this updated Example code.
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.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
peterb0003 29 days ago

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>
"
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 1 month ago
v1.0.2 Release Notes
- Fixed column breaks and width issues in the sheet.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 1 month ago
v1.0.1 Release Notes
- Fixed the Dependencies
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Shaik Ahamed 2 months ago in reply to Mohammed Sami

Thank you so much for your constant support, it truly means a lot. Really glad to have your encouragement.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Mohammed Sami 2 months ago

Great to see this live on the AppMarket, Shaik Ahamed! This is a high-quality addition to the ecosystem and a reflection of all the hard work you put into development and testing.

This plug-in is going to be a game-changer for easing complex document workflows. Converting HTML to Excel is a frequent requirement that can often be cumbersome to implement from scratch, and having a dedicated, vetted tool will save fellow developers significant time and effort. It’s a practical solution that directly addresses a common technical hurdle. Congratulations on this fantastic milestone!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Shaik Ahamed 2 months ago in reply to manishaa974971

Thank you for the feedback! Glad to see this plug-in is helping enable faster data delivery and streamline reporting.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel