{"id":4361,"date":"2017-11-02T11:48:39","date_gmt":"2017-11-02T07:48:39","guid":{"rendered":"https:\/\/dhtmlx.com\/blog\/?p=4361"},"modified":"2026-01-30T11:57:47","modified_gmt":"2026-01-30T08:57:47","slug":"filtering-export-excel-now-available-dhtmlxpivot-1-2","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/filtering-export-excel-now-available-dhtmlxpivot-1-2\/","title":{"rendered":"Filtering and Export to Excel are Now Available in dhtmlxPivot 1.2"},"content":{"rendered":"

We are very pleased to announce the release of dhtmlxPivot 1.2! Our JavaScript Pivot table<\/a> becomes more powerful, and can help you in maximizing your app’s efforts at delighting your customers with smart data reporting. So, what are the new cool features?<\/p>\n

UI for Data Filtering<\/h3>\n

Starting from the version 1.2, you or the end user of your app can apply filters from UI and display the necessary data on-the-fly. There are 3 types of filters available: string, number and dates. Read about filtering in docs<\/a><\/p>\n

\"pivot-filtering\"<\/p>\n

Export to Excel<\/h3>\n

dhtmlxPivot 1.2 comes with the ability to export the pivot table to an Excel file. As an output, you’ll get an excel table with all your custom styles and templates. Try yourself<\/a><\/p>\n

Increase in Performance<\/h3>\n

Now you can make your Pivot table even faster. It can be achieved by using aliases, that allow using ids instead of constantly repeated data values in a dataset. This allows you to decrease the size of a dataset file which leads to the increase in speed of data loading. Find more in our docs<\/a><\/p>\n

Extended Data Loading<\/h3>\n

With dhtmlxPivot 1.2, you can build reports with the data loaded from server-side scripts . You can use Pivot with any RESTful server side – java, .net, php, node.js etc. In addition, the Pivot can load data from CSV files. If this is not enough, you can use DataDriver API and load data from any custom format.<\/p>\n

You can check a sample of loading data from CSV<\/a>, or refer to the technical documentation<\/a>.<\/p>\n

Conditional Formatting<\/h3>\n

Now you have the ability to style the cells based on some specific conditions. For example, you can paint the cells with min and max values with different colors:<\/p>\n

\"pivot-conditional-formatting2\"<\/p>\n

You can use this feature to improve data perception if you need to highlight certain values.<\/p>\n

\"pivot-conditional-formatting\"<\/p>\n

So, you can set any logic you need and mark the important data. Check the docs<\/a><\/p>\n

Related material:<\/h3>\n