Generate an Excel File from an Ext JS 4 Grid or Store

There were several Ext 3 examples available, however. So I ported and enhanced one that I found out there for your enjoyment.

Here’s the result, which I implemented as an override to the grid control. Calling it’s rather quite simple. Just invoke the grid’s downloadExcelXml() method.

{

  xtype: 'button',

  flex: 1,

  text: 'Download to Excel',

  handler: function(b, e) {

    b.up('grid').downloadExcelXml();

  }

}

Converting over the Ext 3 code and enhancing it to supply a suggested filename using a new Google Chrome trick, wasn’t quite so simple:

You can play around with the code on Sencha Fiddle:
https://fiddle.sencha.com/#fiddle/17j

Comments

ExtJS - Grid panel features

What can we do with ExtJS GridPanel? I have to develop a lot of applications in my web app and I see that grid component of ExtJS may fit in. However, I am not aware of what all things I can do with the - off the shelf available framework pieces - available plug-ins in the marketplace and - custom development through my own developers This is a typical question that we hear from the business users who wants to design an application by keeping the framework’s capability in perspective. In this article I have tried to put the list of stuff you can do with grid and hopefully that shall enable you to take advantage of the beauty of ExtJS. Pre-requisites This article assumes that you are familiar with basics of ExtJS What are the available options? In this section I will be taking you through some of the commonly seen usage of ExtJS grid panel. While covering all the capabilities of grid may not be possible, I am sure it will be helpful for the business users who want to

Ext4 Apply Store Filtering

In extjs4.1: There are many way for store filtering . Some of code i give here Filtering by single field: store . filter ( 'eyeColor' , 'Brown' ); Alternatively, if filters are configured with an id , then existing filters store may be replaced by new filters having the same id . Filtering by single field: store . filter ( "email" , /\.com$/ ); Using multiple filters: store . filter ([ { property : "email" , value : /\.com$/ }, { filterFn : function ( item ) { return item . get ( "age" ) > 10 ; }} ]); Using Ext.util.Filter instances instead of config objects (note that we need to specify the root config option in this case): store . filter ([ Ext . create ( ' Ext.util.Filter ' , { property : "email" , value : /\.com$/ , root : 'data' }), Ext . create ( ' Ext.util.Filter ' , { filterFn : function ( item ) { return item . get ( &

EXT JS 4: EMPTY VALUE IN A COMBOBOX

EXT JS 4: EMPTY VALUE IN A COMBOBOX Often, in an Ext JS combobox, it is difficult to go back to an empty value once you have selected an item, particularly if “forceSelection” is set to true. Here is my roundup of alternative solutions found from around the web… 1. Override beforeBlur The solution from http://www.sencha.com/forum/showthread.php?182119-How-To-Re-Empty-ComboBox-when-forceSelection-is-Set-To-TRUE overrides beforeBlur on the combbox to clear out lastSelection. Here is a copy of the override from the thread: 1 2 3 4 5 6 7 8 9 10 11 12 13 Ext.create( 'Ext.form.field.ComboBox' , { ... allowBlank: true , forceSelection: true , beforeBlur: function (){ var value = this .getRawValue(); if (value == '' ){ this .lastSelection = []; } this .doQueryTask.cancel(); this .assertValue(); } }); Or to apply the o

JS Architect's

Search This Blog