GridPanel directly to Excel.

[alaska]

Just a note! did not work with Ext.grid.RowNumberer() im my tests

[Animal]

Feel free to make it work.

[krzak]

Just a note! did not work with Ext.grid.RowNumberer() im my tests

hm... it work for me with RowNumberer()... something else might break you tests.

[alaska]

im using NoahK17 version, ill try the original, and report

[aproust94]

It's all in the first post: This needs a browser that supports data URLs. FF, Opera and IE8 will support this.

Thank you mankz. I wrote something wrong about ie7. I know that's not work. But in all case the utf-8 issue is not due to the kind of browser. Maybe the encoding. I'd try many things, but nothing works.

If you got an idea ?

Al

[aproust94]

Well, after reading many threads about downloading and more, I found a solution bases on this thread and jrh's message (#34) [URL="http://extjs.com/forum/showthread.php?t=23937&page=4"].
First of all, for utf8 issue, I don't use Base64 encoding. Except for data url.
So to get more compatibility with major browsers, I use this following code when I create a button (top toolbar). If the browser support data url, I use this way else I create a downloader :

                                        id: 'grid-excel-button',
                    iconCls: 'icon-excel',
                    text: EXPORT_EXCEL_BUTTON,
                    handler: function(){
                        var exportContent = IssueListingEditorGrid.getExcelXml();
                        if (!Ext.isIE6 || !Ext.isIE7 || !Ext.isSafari || !Ext.isSafari2 || !Ext.isSafari3) {
                            document.location='data:application/vnd.ms-excel;base64,' + Base64.encode(exportContent);
                        } else {
                            if (!Ext.fly('frmDummy')) {
                                var frm = document.createElement('form');
                                frm.id = 'frmDummy';
                                frm.name = id;
                                frm.className = 'x-hidden';
                                document.body.appendChild(frm);
                            }
                            Ext.Ajax.request({
                                url: 'export/excel.php',
                                method : 'POST',
                                form: Ext.fly('frmDummy'),
                                callback: function(o, s, r){
                                    alert(r.responseText);
                                },
                                isUpload: true,
                                params: { ex: exportContent }
                            });
                        }
                    } 

Your PHP code should be like this one:

header("Pragma: public");
header("Expires: 0"); // set expiration time
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition:attachment;filename=export");
echo $_REQUEST['ex']; 

Hope this helps someone

Al

[ckr]

Great work Animal! Works like a charm.


For others using - FYI
One item I ran into was the length of the title of my grid. The grid title is used as the worksheet title, and it seems that Excel will only let you have 31 characters. You will get a warning when opening the data link saying that a string is too long. Excel will truncate the title, but the error message might be a bit bothersome. So anyone having a long grid title will need adjust accordingly. It is easily fixed.

[miihiir]

Well, after reading many threads about downloading and more, I found a solution bases on this thread and jrh's message (#34) [url="http://extjs.com/forum/showthread.php?t=23937&page=4"].
First of all, for utf8 issue, I don't use Base64 encoding. Except for data url.
So to get more compatibility with major browsers, I use this following code when I create a button (top toolbar). If the browser support data url, I use this way else I create a downloader :

                                        id: 'grid-excel-button',
                    iconCls: 'icon-excel',
                    text: EXPORT_EXCEL_BUTTON,
                    handler: function(){
                        var exportContent = IssueListingEditorGrid.getExcelXml();
                        if (!Ext.isIE6 || !Ext.isIE7 || !Ext.isSafari || !Ext.isSafari2 || !Ext.isSafari3) {
                            document.location='data:application/vnd.ms-excel;base64,' + Base64.encode(exportContent);
                        } else {
                            if (!Ext.fly('frmDummy')) {
                                var frm = document.createElement('form');
                                frm.id = 'frmDummy';
                                frm.name = id;
                                frm.className = 'x-hidden';
                                document.body.appendChild(frm);
                            }
                            Ext.Ajax.request({
                                url: 'export/excel.php',
                                method : 'POST',
                                form: Ext.fly('frmDummy'),
                                callback: function(o, s, r){
                                    alert(r.responseText);
                                },
                                isUpload: true,
                                params: { ex: exportContent }
                            });
                        }
                    } 

Your PHP code should be like this one:

header("Pragma: public");
header("Expires: 0"); // set expiration time
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition:attachment;filename=export");
echo $_REQUEST['ex']; 

Hope this helps someone

Al

Hey Al,

I am trying to use your code, however, no success. It's doing nothing. Is it working for anyone else?

It does not give any error, but does not do anything as well.

Thanks.

Mihir

[Marcelo Delgado]

Hi Animal I think this is great ! I was looking over Internet a lot but I did not find nothing like this. My problem is that I am using gwt-ext in my application and I would like to have this functionallity in it. I really dont know how to include this in my application, can you give me some tips about this or point me where to go.

Any help it would be great

Thanks

Marelo

[iwagon]

AH, thanks for that! I'll do conditional method creation and update post 1.

Правильнее будет:
encode : (typeof btoa == 'function') ? function(input) { return btoa(utf8Encode(input)); } : function (input) {