I am trying to integrate Pivittable.js within a XLTS environment (I m using a proprietary tool and this is the only way I can use the report)
The tool uses Oracle sql to generate the XML which is passed to the XLTS. This of course create a table that renders in the browser when run by the Proprietary website.
**(1) Is it possible to use the XML generated as a source to the Pivotable?**
$("#output").pivotUI(
, {
rows: ["Country"],
cols: [],
renderers: $.extend(
$.pivotUtilities.renderers,
$.pivotUtilities.plotly_renderers,
)
});
**(2) IF not, can I pass JSON? I know how to convert the created table to JSON:**
data = JSON.parse(JSON.stringify($("#masterTable").DataTable().rows( { search:'applied' }).data().toArray()));
I am trying to integrate Pivittable.js within a XLTS environment (I m using a proprietary tool and this is the only way I can use the report) The tool uses Oracle sql to generate the XML which is passed to the XLTS. This of course create a table that renders in the browser when run by the Proprietary website.