Creating a Table then Adding Two Filters and Exporting to Excel

Our sample projects and report templates can help you learn the basics of working with our products.
Products ✖Dashboards.JS ✖Engine ✖Export ✖Components ✖
This example illustrates how to add a filter to the table element in the dashboard and store the result in the Excel file.

Installation and running
Use npm to install requred modules: 
$ npm install
Run Sample: 
$ npm start

Step by step
Stimulsoft Dashboards.JS module loading: 
var Stimulsoft = require('stimulsoft-dashboards-js');
Creating new dashboard: 
var report = Stimulsoft.Report.StiReport.createNewDashboard();
var dashboard = report.pages.getByIndex(0);
Load and add reg data: 
var dataSet = new Stimulsoft.System.Data.DataSet();
dataSet.readXmlFile("Demo.xml");

report.regData("Demo", "Demo", dataSet);
report.dictionary.synchronize();
Create new table element: 
var tableElement = new Stimulsoft.Dashboard.Components.Table.StiTableElement();
dashboard.components.add(tableElement);
Add column to table: 
var productIDColumns = new Stimulsoft.Dashboard.Components.Table.StiDimensionColumn();
productIDColumns.expression = "Products.ProductID";
tableElement.columns.add(productIDColumns);
Add filter to table: 
var productIDFilter = new Stimulsoft.Data.Engine.StiDataFilterRule();
productIDFilter.condition = Stimulsoft.Data.Engine.StiDataFilterCondition.BeginningWith;
productIDFilter.path = "Products.ProductID";
productIDFilter.value = "1";
tableElement.dataFilters.add(productIDFilter);
Export to Excel: 
report.exportDocumentAsync((data) => {
    // Converting Array into buffer
    var buffer = Buffer.from(data)

    // File System module
    var fs = require('fs');

    //Saving to a file
    fs.writeFileSync('./SampleDashboard.xlsx', buffer);
}, Stimulsoft.Report.StiExportFormat.Excel2007);

In the screenshot below you can see the result of the sample code:

Creating a Table then Adding Two Filters and Exporting to Excel
View on GitHub Download
By using this website, you agree to the use of cookies for analytics and personalized content. Cookies store useful information on your computer to help us improve efficiency and usability. For more information, please read the privacy policy and cookie policy.
I agree