Export store to Excel

[delusion]

Has anyone used this with a tree panel? I have it working for a grid, but when i try to give it a tree componenet, or a tree store, it goes into the excelFormatter, tries to render a workbook,

then does on this

try { __flash__toXML(Downloadify.getTextForSave("downloadify_1355328296803")) ;}catch (e) {"<undefined/>"; }

which i assume is from the downloadify.swf, and then dies with the catch(e) being a TypeError : undefined_method

It's very strange as it gets past this point when using a grid component.

thanks for any ideas anyone might have

[mikih]

does anyone have a clue whats wrong with the generated excel source? I am happy to help, but have no starting point


Cheers

Florian

[Sheng_Yunzhou]

Hi Sarz,

I had the same style problem too but I used the updated Style.js here http://www.sencha.com/forum/showthre...l=1#post773479

[vitalz]

I use a different button which events a controller handles and then the controller tries to fire event on a hidden exporter button.

Ext.define("MyApp.view.MyPanel", {
extend:"Ext.panel.Panel",
requires:['MyApp.view.component.Table'],
alias:"widget.mypanel",
title:"Table Data",
itemId:"mypanelId",
layout:'fit',
items: [
{
xtype:'exporterbutton',
itemId:'exportmytableId',
hidden:true,
store: Ext.create("MyApp.store.data.SomeData"), /* why should I define store two times initially? */
swfPath: '../myapp/ux/exporter/downloadify.swf',
downloadImage: '../myapp/ux/exporter/download.png'
},
{
xtype:'mytable',
itemId:'mytableId',
forceFit: true,
store: Ext.create("MyApp.store.data.SomeData")
}
]

});



Ext.define("MyApp.controller.Export", {
extend: "Ext.app.Controller",

...blah de blah...

/* handle event from tbar button */
exportMe : function() {
var mytable = Ext.ComponentQuery.query('mytable[itemId="mytableId"]');
var exporter = Ext.ComponentQuery.query('exporterbutton[itemId="exportmytableId"]')[0];
exporter.setComponent(mytable, {});
exporter.fireEvent('click'); /* 'down' event also never works; the same is applicable to exporter.body variable */
}

});




But it seems that event never happens. I do not see Save download dialogue...

I have also tried to use Downloadify JS without Ext.ux.exporter.Button but it looks when the ExtJS extension requires (absolutely useless in my current case) swf path, download image... it is completely locked by button logics somewhere in the source code that is why I suppose to use Downloadify JS separately (without knowing implementation details) is still not a good idea!

[xdengli]

export to csv , use notepad to open normal ，but use excel to open garbled Chinese
character
what can i do ? tks。

[Sheng_Yunzhou]

Vitalz: I think the problem is because the exportbutton is actually a swf file (which triggers the opening of download window), not a button, therefore fireEvent('click') may not work.

I'm also waiting for solutions.

[vitalz]

export to csv , use notepad to open normal ，but use excel to open garbled Chinese
character
what can i do ? tks。

Well... that is a hack way. Surely I personally may do it.
But I am developing system for customers who will never go such painful way. What means when user clicks export button browser downloads an Excel file.

[vitalz]

Vitalz: I think the problem is because the exportbutton is actually a swf file (which triggers the opening of download window), not a button, therefore fireEvent('click') may not work.

I'm also waiting for solutions.

Yes, flash is going to be completely removed. Otherwise flash is a reason to never use Ext.ux.exporter user exentension. So, it looks Downloadify is based on flash... we have to hope something will change.

First heard flash became main reason we refused Ext.ux.exporter and replaced it by server side Apache POI.

The other important feature after no flash is good news that multi stores/tables may be exported to one file. For instance, there are some tables on the screen and those tables need to be exported to one *.xls

[kalchas]

I modified the Ed Spencer, Mason Zhang files and now export to Office 2003,2007,2010, Libreoffice is possible.

[vitalz]

I modified the Ed Spencer, Mason Zhang files and now

did you remove flash?