Excel data into grid

[trieyedwolf]

I was just wondering if there is a way to paste data from a excel table into a grid in extjs (sencha). Maybe with the ctrl + v option or a way to load the data from the excel too.
Thanks guys.

[aravindballa]

Hi,

Not yet from the framework side of things. Maybe we can file this as a feature request.

[trieyedwolf]

Hi,

Not yet from the framework side of things. Maybe we can file this as a feature request.

Thanks

[aicgroup-dev]

Hmm?, It is indeed built in, with one open issue... What about this ?

extend : 'Ext.grid.Panel',
alias : 'widget.data_common_data_genericdatagridviewer',

requires : [
    'Ext.grid.selection.SpreadsheetModel',
    'Ext.grid.plugin.Clipboard',
    
],

controller : 'data_common_data_genericdatagrid_vc',
viewModel : 'data_common_data_genericdatagrid_vm',

bind : {
    selection: '{selectedRow}',
    columns : '{columns}',
    store : {
        // access the data portion from the current record displayed
proxy : {
            type : 'memory'
},
        data : '{current.data}'
}
},

plugins: [{
    ptype: 'cellediting',
    clicksToEdit: 1
},{
    ptype : 'clipboard',

    /**
     * TODO : remove this functionality if EXT-16236 is fixed
*/
doPaste: function (format, data) {
        this.cmp.fireEvent('onPaste',data)
    },
}],

dockedItems : [{
    xtype :'toolbar',
    dock : 'top',
    items : [{
        text : /*i18n*/'Add row',
        handler : 'onAddRow'
},{
        text : /*i18n*/'Remove row',
        handler : 'onRemoveRow'
}]
}],

selModel : {
    type : 'spreadsheet',
    columnSelect : false,
    extensible : false, // by default this makes no sense for a viewer
},

emptyText : /*i18n*/'Paste data from the clipboard into the grid',
columnLines : true,

listeners : {
    afterrender : 'onAfterRender',
    // we take this to capture the paste events by CMD/STRG V
onPaste : 'onPaste'
}

and in the controller's onPaste method :

 onPaste(data){
     // do whatever you want with the data
}

[evant]

Yeah, this is absolutely supported, there's even an example of it in the kitchen sink:

http://examples.sencha.com/extjs/6.5...ic#spreadsheet