repositories {
    maven {
      url 'https://dl.bintray.com/openxp/public'
    }
}

dependencies {
     include 'openxp.lib:htmlexporter:1.0.0'
}

var htmlExporter = require('/lib/openxp/html-exporter');
var ioLib = require("/lib/xp/io");

exports.get = function(req, type) {
    var fileSource = null;

    if (type == 'pdf') {
		fileSource = htmlToPDF();
    } else {
        fileSource = htmlToExcel();
    }
    
    // Stream the file content to the client
    return {
        body: htmlExporter.getStream(fileSource),
        headers: {
            'Content-Disposition': 'attachment; filename="' + fileSource.name + '"'
        }
    };
};

function htmlToExcel() {
    var fileSource = htmlExporter.exportToExcel(getHtml());
    fileSource.name = 'htmlExporterTest.xlsx';

    return fileSource;
}

function htmlToPDF() {
    var fileSource = htmlExporter.exportToPdf(getHtml());
    fileSource.name = 'htmlExporterTest.pdf';

    return fileSource;
}

function getHtml() {
    return ioLib.readText(ioLib.getResource(resolve('html-exporter-test.html')).getStream());
}

<!-- This cell will, via the data-group attribute,  be added to two ranges, each of which will be the inputs to formulas -->
<td data-group="store_Dumfries_2_value, region_1_1_pg_5_value" class="numeric">
    486
</td>

...

<!--
    This raw value of this cell will, via the data-group-output attribute, be replaced with a SUM function taking as input all cells added to the specified range.
    The cell is then itself added to another range which will be used by a further function.
-->
<td class="subTotal numeric" data-group-output="region_1_1_pg_6_count" data-group="area_1_pg_6_cou