Can I Add a Button to Export a Repeated Section to Excel?

I'm very excited to say I've figured this out. Unfortunately this is a draft. I call it that because the part that is currently exporting to excel is table2excel which is not meant for production as it is only reliable in Chrome, and sometime FireFox. None-the-less this works, and in a way that will easily segway to a better export solution. You should be able to replace table2excel with another method to export, but this will give you an idea of how to make it happen.

1. We mapped out how Nintex renders repeating sections. However, this proved unnecessary, because all we needed was to use the "data-controlname" attribute of each field to collect data.(i.e. data-controlname="field1")

2. We then used a little javascript, html, and css to build the HTML table and hide it on the page. The HTML goes in a label on the actual form where you want the Export button to render. The CSS goes in the custom CSS in form settings, and the JS can go in the custom JS in settings, however we put this in an external file and included it in the JS includes section of the advanced section in form settings. 

/*****HTML*********************************/

<table id="tableID">
<th>Item Number</th>
<th>Part Number</th>
<th>Description</th>
<th>Qty</th>
<th>Unit Cost</th>
<th>Total Cost</th>
</table>

<button id="btnexport">Export</button>

/*****CSS*********************************/

#tableID{display:none;}

/*****JAVASCRIPT*********************************/

// Get a handle to the table
var printTable = ("#tableID");

// Get arrays of all data points
var unitCosts = $("div[data-controlname='txt-unitCost']");
var itemTotals = $("div[data-controlname='cal-itemTotal']");
var quantities = $("div[data-controlname='txt-qty']");
var itemNums = $("div[data-controlname='calc-itemNum']");
var partNums = $("div[data-controlname='txt-partNum']");
var descriptions = $("div[data-controlname='txt-description']");

var itemCount = itemNums.length;

// build the table by 
for(var itemIndex = 0; itemIndex < itemCount; itemIndex++) {
var strRow = "<tr><td>" + $(itemNums[itemIndex]).text() + "</td>"
+ "<td>" + $(partNums[itemIndex]).text() + "</td>"
+ "<td>" + $(descriptions[itemIndex]).text() + "</td>"
+ "<td>" + $(quantities[itemIndex]).text() + "</td>"
+ "<td>" + $(unitCosts[itemIndex]).text() + "</td>"
+ "<td>" + $(itemTotals[itemIndex]).text() + "</td>";

$(printTable).append(strRow);
}

3. Then we applied table2excel the JS was included in the same file mentioned above.

FINAL RENDER:

Very cool. I've also dabbled getting data from a repeating section into excel a different way...

https://community.nintex.com/community/dev-talk/blog/2018/10/10/repeating-section-extract-and-split-to-excel

This though, dumps all of the lists items repeating sections into excel.

T.