GridPanel directly to Excel.

[Pekka Karalahti]

Same problem still and i have tried to change everything, store, grid, readers... I am desperate. I have debug the code and it writes first column/header okay into csv file but when code is looping to second header it gives error fld is undefined.

[vizcano]

I've got a problem trying to display hours, in da DateTime cell i've replaced t += v.format('Y-m-d'); for t += v.format('G:i'); because what i want to show is the hour and my excel crashes.

Another problem i'm dealing with is when de DateTime cell doesnt contain any value, the new excel crashes again saying "incorrect value" for those cells.

Could anyone help me with this problems?

[myth]

thank for the thread i find all info y need to export a excel ( i need to read 2 o 3 times but the infornation is here )

[Cassio11]

First of all, thanks for this great plugin!

However I ran into some trouble when I try to open the Excel-File.
It gives me an an error and directs me to the Log-File:

XML PARSE ERROR: Missing end-tag
Error occurs at or below this element stack:
<ss:Workbook>
<ss:Worksheet>
<ss:Table>
<ss:Row>
<ss:Cell>
<ssata>

None of my XML-Validators where able to find syntax errors.
I really ran into a wall here...


Edit:
Yay! Fixed it myself.
The cause were non-UTF-8 characters in the document, while my page uses iso-8859-1 - so I edited the xml header part in the exporttoexcel.js to ISO-8859-1.

[StagnantIce]

Work fast in IE6 and IE7

    createWorksheet: function(includeHidden) {

//      Calculate cell data types and extra class names which affect formatting
        var cellType = [];
        var cellTypeClass = [];
        var cm = this.getColumnModel();
        var totalWidthInPixels = 0;
        var colXml = '';
        var headerXml = '';
        var dataIndexes = [];
        
        for (var i = 0, len = cm.getColumnCount(); i < len; i++) {
            if (includeHidden || !cm.isHidden(i)) {
                var w = cm.getColumnWidth(i)
                totalWidthInPixels += w;
                colXml += '<ss:Column ss:AutoFitWidth="1" ss:Width="' + w + '" />';
                headerXml += '<ss:Cell ss:StyleID="headercell">' +
                    '<ss:Data ss:Type="String">' + cm.getColumnHeader(i) + '</ss:Data>' +
                    '<ss:NamedCell ss:Name="Print_Titles" /></ss:Cell>';
                    var di = cm.getDataIndex(i);
                    dataIndexes.push(di);
                    var fld = this.store.recordType.prototype.fields.get(di);
                switch(fld.type) {
                    case "int":
                        cellType.push("Number");
                        cellTypeClass.push("int");
                        break;
                    case "float":
                        cellType.push("Number");
                        cellTypeClass.push("float");
                        break;
                    case "bool":
                    case "boolean":
                        cellType.push("String");
                        cellTypeClass.push("");
                        break;
                    case "date":
                        cellType.push("DateTime");
                        cellTypeClass.push("date");
                        break;
                    default:
                        cellType.push("String");
                        cellTypeClass.push("");
                        break;
                }
            }
        }
        
        var visibleColumnCount = cellType.length;

        var result = {
            height: 9000,
            width: Math.floor(totalWidthInPixels * 30) + 50
        };



//      Generate worksheet header details.
        var A = [];

        A.push('<ss:Worksheet ss:Name="' + this.title + '">' +
            '<ss:Names>' +
                '<ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="=\'' + this.title + '\'!R1:R2" />' +
            '</ss:Names>' +
            '<ss:Table x:FullRows="1" x:FullColumns="1"' +
                ' ss:ExpandedColumnCount="' + visibleColumnCount +
                '" ss:ExpandedRowCount="' + (this.store.getCount() + 2) + '">' +
                colXml +
                '<ss:Row ss:Height="38">' +
                    '<ss:Cell ss:StyleID="title" ss:MergeAcross="' + (visibleColumnCount - 1) + '">' +
                      '<ss:Data xmlns:html="http://www.w3.org/TR/REC-html40" ss:Type="String">' +
                        '<html:B><html:U><html:Font html:Size="15">' + this.title +  '</html:Font></html:U></html:B> Generated by ExtJs</ss:Data><ss:NamedCell ss:Name="Print_Titles" />' +
                    '</ss:Cell>' +
                '</ss:Row>' +
                '<ss:Row ss:AutoFitHeight="1">' +
                headerXml + 
                '</ss:Row>');
        for (var i = 0, it = this.store.data.items, l = it.length; i < l; i++) {
            A.push('<ss:Row>');
            var cellClass = (i & 1) ? 'odd' : 'even';
            r = it[i].data;
            var k = 0; 
            for (var j = 0, len = dataIndexes.length; j < len; j++) {
                var v = r[dataIndexes[j]];
                A.push('<ss:Cell ss:StyleID="' + cellClass + cellTypeClass[k] + '"><ss:Data ss:Type="' + cellType[k] + '">');
                    if (cellType[k] == 'DateTime') {
                        A.push(v.format('Y-m-d'));
                    } else {
                        A.push(v);
                    }
                A.push('</ss:Data></ss:Cell>');
                k++;
            }
            A.push('</ss:Row>');
        }
        A.push ('</ss:Table>' +
            '<x:WorksheetOptions>' +
                '<x:PageSetup>' +
                    '<x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" />' +
                    '<x:Footer x:Data="Page &amp;P of &amp;N" x:Margin="0.5" />' +
                    '<x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" />' +
                '</x:PageSetup>' +
                '<x:FitToPage />' +
                '<x:Print>' +
                    '<x:PrintErrors>Blank</x:PrintErrors>' +
                    '<x:FitWidth>1</x:FitWidth>' +
                    '<x:FitHeight>32767</x:FitHeight>' +
                    '<x:ValidPrinterInfo />' +
                    '<x:VerticalResolution>600</x:VerticalResolution>' +
                '</x:Print>' +
                '<x:Selected />' +
                '<x:DoNotDisplayGridlines />' +
                '<x:ProtectObjects>False</x:ProtectObjects>' +
                '<x:ProtectScenarios>False</x:ProtectScenarios>' +
            '</x:WorksheetOptions>' +
        '</ss:Worksheet>');
        result.xml = A.join('');
        return result; 

[StagnantIce]

In IE send Ajax request with params is a bad case.

var data = grid.getExcelXml();
if ((!Ext.isIE7)&&(!Ext.isIE6)) document.location = 'data:application/vnd.ms-excel;base64,' + Base64.encode(data);
else
{
if (!Ext.fly('frmDummy'))
{
var frm = document.createElement('form');
frm.id = 'frmDummy';
frm.name = id;
frm.className = 'x-hidden';

var inp = document.createElement('input');
inp.type = "hidden";
inp.value = data;
inp.id = "data";
inp.name = "data"
frm.appendChild(inp);

document.body.appendChild(frm);
}
Ext.Ajax.request({
url: 'excel.php',
method : 'POST',
form: Ext.fly('frmDummy'),
callback: function(o, s, r){
},
isUpload: true
//params: { data: data }
});
}

[shailendra]

I'm using FF3 on a Windows machine.

I'm using this extension and so far it works very well except for two small things.

1. The filename seems to be a string of random letters.
2. When I try to save the file, the extension is weird - it shows up as .xls.part, and then when I actually save the file it adds another .xls to it so the filename ends up looking like this:

XR9oqU0s.xls.part.xls

The file opens fine, I'm just wondering if this has happened to anyone else?

Hi!
I just entered here
Its happening to me also, any solution you found pls let me know

[shailendra]

Thank you for sharing your code!

But Error ! IE7:
The data area passed to a system call is too small.

Hi!
sorry but i m also getting the same error in IE8
any solution ?
thanks

[calavera]

Hi!
I just entered here
Its happening to me also, any solution you found pls let me know

Me to. I get the weird file name and when I try to open with Microsoft Excel, it gives me an error at "Table". Don't know more of it. Tested on Firefox 3.6.3 . Any solution ? Thanks.

[Skunkerbr]

Hi..

I noticed that in Ext 3.2.1, the line:

var fld = this.store.recordType.prototype.fields.get(cm.getDataIndex(i));

..returns a Object type with another type in it. So now fld.type must be replace with fld.type.type in the switch to handle the field type right.

switch(fld.type.type) {
    case "int":
        cellType.push("Number");
        cellTypeClass.push("int");
        break;
    case "float":
        cellType.push("Number");
        cellTypeClass.push("float");
        break;
    case "bool":
    case "boolean":
        cellType.push("String");
        cellTypeClass.push("");
        break;
    case "date":
        cellType.push("DateTime");
        cellTypeClass.push("date");
        break;
    default:
        cellType.push("String");
        cellTypeClass.push("");
        break;
}

Anyone getting the same on 3.2.1 ? Or just me