Export store to Excel

**wiznia** · 8 Feb 2012 2:28 AM

mmmm, I can't find anything worng with the code. I know it had some problems with custom columns, and with the groupheader plugin, but yours is pretty straightforward.... Try debugging it.

**pavanextjs** · 8 Feb 2012 8:38 AM

OK i will try to debug it.

**droessner** · 23 Feb 2012 8:43 AM

wiznia,

Thanks for porting this plugin. Iv'e had it installed for a couple of months now and it's been working great. I just recently noticed that there seems to be an issue with this plugin when using Ext.History. However, this seems to be an issue only in Internet Explorer (I'm using IE8). It looks like when the button is rendered, the title of my page is changed to my title + the history link. I added the plugin to the history example, and after the button is rendered the page looks as follows (notice the title).

afterrender.jpg

When I click on the button, the title is changed again. See below:

afterclick.jpg

I've done a little debugging and as far as I can tell it may be swfobject.js that is causing this title change. I'm a little hesitant on changing swfobject so I figured I'd ask if this is something that you've come across and/or if you have any suggestions on what changes I could make to fix this issue.

Any help is appreciated!

Thanks,
Danny

**wiznia** · 24 Feb 2012 3:05 AM

I have no idea what could be changing the title... It only happens when you use Ext.History?
I doubt it's a swfobject issue, since it's widely used, but I really don't know what could be causing the issue... sorry.

**droessner** · 24 Feb 2012 5:18 AM

I actually just created a simple grid (without any of the Ext.History stuff) and added the exporter button and then just added "#text" to the end of my url and it still happened. I guess I'll keep digging, thanks anyway!

**BlackLine** · 24 Feb 2012 5:28 AM

Hi, wiznia.
I'm using your plugin and it works fine, thank you!

But I have a question about button - can I use there a simple button, without underlying png-image?
Could you tell me what code I should change to do it?

**wiznia** · 24 Feb 2012 6:24 AM

droessner, it only happens in IE? Can you post an example code?

BlackLine, you can't use a simple ext button, because the png is there to allow the download of the file (via downloadify). In previous versions a regular button was used, and a data-uri link but there's no support for data-uri in older browsers and there's a limit on the size of the data-uri that made browsers crash when the file was too large.

**droessner** · 24 Feb 2012 6:41 AM

Yes, I've only seen this issue come up in IE. I'm using IE8. Here is a really simple example. When you run this just add "#text" to the end of the url and load the page. When I initially load the page it adds "#text" to the title. When I click on the button it changes the title to just "#text"

Code:

<!DOCTYPE html>
<html>
<head>
    <title>Exporter Example</title>
    <link rel="stylesheet" type="text/css" href="../ext/resources/css/ext-all.css"/>
    <script type="text/javascript" src="../ext/ext-all-debug.js"></script>
    <script type="text/javascript" src="exporter/downloadify.min.js"></script>
    <script type="text/javascript" src="exporter/swfobject.js"></script>
    <script type="text/javascript" src="exporter/Formatter.js"></script>
    <script type="text/javascript" src="exporter/Base64.js"></script>
    <script type="text/javascript" src="exporter/Button.js"></script>
    <script type="text/javascript" src="exporter/csvFormatter/CsvFormatter.js"></script>
    <script type="text/javascript" src="exporter/excelFormatter/Cell.js"></script>
    <script type="text/javascript" src="exporter/excelFormatter/Style.js"></script>
    <script type="text/javascript" src="exporter/excelFormatter/Workbook.js"></script>
    <script type="text/javascript" src="exporter/excelFormatter/Worksheet.js"></script>
    <script type="text/javascript" src="exporter/excelFormatter/ExcelFormatter.js"></script>
    <script type="text/javascript" src="exporter/Exporter.js"></script>
    <script type="text/javascript">
        Ext.onReady(function(){
            Ext.create('Ext.grid.Panel', {
                title: 'test',
                height: 200,
                width: 200,
                renderTo: Ext.getBody(),
                tbar: [{
                    xtype: 'exporterbutton'
                }],
                store: [['test', 'test']],
                columns: [{
                    header: 'test'
                }]
            });
        });
    </script>
</head>
<body>
</body>
</html>

Thanks!
Danny

**jarobi** · 27 Feb 2012 5:56 AM

How this works if i use a Ext Js Chart. The 'exporterbutton' have to be inside the chart implementation? But how i put a button or toolbar to the Chart?

**wiznia** · 27 Feb 2012 9:26 AM

The button can be configured in 3 ways:
1) By putting it inside a gridpanel or treepanel (no extra config needed).
2) By passing a 'component' config option with an ext component that responds to getStore method.
3) By passing a 'store' config option.

I haven't used it with a chart, but I guess that if you provide the store of the chart it should work.

Export store to Excel

Thread Tools

Search Thread

Display