GridPanel directly to Excel.

[emredagli]

(By putting break point on FIREBUG) Check the,
var vExportContent = grid.getExcelXml();
parameter.

[vvreddy@12]

Hi,

I have put a break point in the firebug and found the result int the xml format. The problem which I am facing is not with firefox but with IE. The code is working fine with firefox and is not working with IE.

Please find the result of the variable vExportContnet as an attachment and at the same time I am sending my code to you.

Thanks,
Vishnu

[Animal]

Could your problem be something to do with not reading the very first line in ths thread?

This needs a browser that supports data URLs. FF, Opera and IE8 will support this.

[vvreddy@12]

Hi Animal,

I have seen that line in the early conversations but there was a thread given by emredagli in which he specified that he could export the data into an excel using IE 7. So we have started to use that piece of code in your code.

Thanks,
Vishnu

[emredagli]

Hi vvreddy,
unfortunately, I haven't work with jsp files. Actually I test my code by using aspx files in .NET.
I want to ask firstly, What did you mean as getting blank page? If when you try to open document in excel and getting improper format, The problem may related with:

        fields: [
           {name: 'company'},
           {name: 'price', type: 'float'},
           {name: 'change', type: 'float'},
           {name: 'pctChange', type: 'float'},
           {name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
        ]

In "company" field, it's type isn't declared.
Or you can try by giving all formats as string (I used as string to all fields).

The second is if you change the part:

          if (Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2 || Ext.isSafari3) {
              var dataURL = '../jsp/exportexcel.jsp';
              params =[{
                   name: 'ex',
                   value: vExportContent 
              },{
                  name: 'FileName',
                  value: 'excel.xls'
              }];
              post_to_url(dataURL, params, 'post');
          } else {
                
              document.location = 'data:application/vnd.ms-excel;base64,' + Base64.encode(vExportContent);
          }

AS

              var dataURL = '../jsp/exportexcel.jsp';
              params =[{
                   name: 'ex',
                   value: vExportContent 
              },{
                  name: 'FileName',
                  value: 'excel.xls'
              }];
              post_to_url(dataURL, params, 'post');

You can test it in Firefox. Try this and look at the response you send in firebug.

And also I change the format of the file "result.txt" (you sended) as "result.xls". And I can open it in excel. (Problem probably related with jsp... )

I hope you solve the problem.
Good luck.

[whodat]

Obviously this only works on the data in the Store - if you are using server-side paging, then perform this processing on the server. For quick and dirty conversion of a small table to Excel, this might be useful.

Hi Animal.. great user extension and I was able to get this working in IE7 and FF3.

Quick question/possible bug in regards to the statement above.

I am using paging but decided to do it on the client side with Condor's extension. So I have all of the data on the client side in my grid's store. But when exporting to excel, I only get the rows visible to the grid. Any suggestions as to why?

Digging a lil into your code, I found the following comments and code

// Generate the data rows from the data in the Store
        for (var i = 0, it = this.store.data.items, l = it.length; i < l; i++) {
            t += '<ss:Row>';
            var cellClass = (i & 1) ? 'odd' : 'even';
            r = it[i].data;
            var k = 0;
            for (var j = 0; j < cm.getColumnCount(); j++) {
                if (includeHidden || !cm.isHidden(j)) {
                    var v = r[cm.getDataIndex(j)];
                    if (cellType[k] !== "None") {

                        t += '<ss:Cell ss:StyleID="' + cellClass + cellTypeClass[k] + '"><ss:Data ss:Type="' + cellType[k] + '">';
                            if (cellType[k] == 'DateTime') {
                                t += v.format('Y-m-d');
                            } else {
                                t += v;
                            }
                        t +='</ss:Data></ss:Cell>';
                    }
                    k++;
                }
            }
            t += '</ss:Row>';
        }

Does this piece actually take all data present in the store, because it does not seem to...

Please let me know and thanks again for the extension.

[Animal]

Whuhhhhh?

MUST prevent myself going into Cox mode... MUST.....

[whodat]

Whuhhhhh?

I'm no sure I get you, I don't watch scrubs but I know dude in the pic is on that show.

If you're stating that this extension was just a way to illustrate the capabilities then yes, I understand you.

My concern was this this.store.data.items I thought this had all items in the store and not what was only loaded into the grid and I was paging locally and not on the server how could I get all of the records exported without loading the grid.

[Animal]

The Store can only expose what is in the current page, so you will only ever get the current page from the Store. If it didn't do this, it wouldn't be paged.

If you are using Condor's paging Store, then you need to ask him how to access the "real" Store containing the whole dataset, and use that.

[Rafael]

i try but have a error in my code:

unterminated string literal
in line:
'<ss:Cell ss:StyleID="title" ss:MergeAcross="' + (visibleColumnCount - 1) + '">' +