GridPanel directly to Excel.

[robshim]

I have got the grid to download as an xls spreadsheet, but I can't get it to work in IE. (I know it can work in IE because I have seen a site where it does.) Any advice?

[Monz87]

i already try the code, but i have an error message. when i click export to excel, i get an error " 'type' is null or not an object. "

this is my code

bbar: new Ext.PagingToolbar({
store: store,
pageSize: 5,
plugins: [filters],
emptyMsg: 'No record found',
displayInfo:true,
items:[
'-',
{
text: 'Clear Filter Data',
handler: function () {
grid.filters.clearFilters();
}
},
{
text:'Clear Grouping',
handler : function(){
store.clearGrouping();
}
},
{
text:'Export to Excel',
handler: function(){ document.location='data:application/vnd.ms-excel;base64,'
+ Base64.encode(grid.getExcelXml()); }
}
]
})

i already import exporter.js into my jsp.

anybody can help me...?

[sKuD24]

It doesn't work with ExtJs 3.3.0 and FireFox 3.6.13 : when I click the link button, FireFox crash completely !!!

[isaac]

Really want this! Great work. I tried this with ExtJS 2 and I'm getting FF to crash and it doesn't work in chrome at all (yes I know about what's supported....)

[Condor]

Javascript shouldn't be able to crash browsers. You should report this to the appropriate buglists (Bugzilla & Chromium Issues).

Anything unusual about what you are exporting (large dataset, unusual characters, etc.)?

[Tod]

In reading the last dozen posts, it is very unclear the status of this plugin. Is it working? Does it work with 3.3? Does it work with IE8? Is there an online demonstration -- this is very useful, if I can get it to work!

Thanks,
-Tod

[pops]

FF crashs when I used the animals Base64.encode.
When I use the btoa function, I got a "String contains an invalid character" exception.

Below, the input string I want to encode :

<?xml  version="1.0" encoding="utf-8"?><ss:Workbook  xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"  xmlns:x="urn:schemas-microsoft-com:office:excel"  xmlns:o="urn:schemas-microsoft-com:office:office"><o:DocumentProperties><o:Title>undefined</o:Title></o:DocumentProperties><ss:ExcelWorkbook><ss:WindowHeight>9000</ss:WindowHeight><ss:WindowWidth>33050</ss:WindowWidth><ss:ProtectStructure>False</ss:ProtectStructure><ss:ProtectWindows>False</ss:ProtectWindows></ss:ExcelWorkbook><ss:Styles><ss:Style  ss:ID="Default"><ss:Alignment ss:Vertical="Top" ss:WrapText="1"  /><ss:Font ss:FontName="arial" ss:Size="10"  /><ss:Borders><ss:Border ss:Color="#e4e4e4" ss:Weight="1"  ss:LineStyle="Continuous" ss:Position="Top" /><ss:Border  ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous"  ss:Position="Bottom" /><ss:Border ss:Color="#e4e4e4" ss:Weight="1"  ss:LineStyle="Continuous" ss:Position="Left" /><ss:Border  ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous"  ss:Position="Right" /></ss:Borders><ss:Interior  /><ss:NumberFormat /><ss:Protection  /></ss:Style><ss:Style ss:ID="title"><ss:Borders  /><ss:Font /><ss:Alignment ss:WrapText="1"  ss:Vertical="Center" ss:Horizontal="Center" /><ss:NumberFormat  ss:Format="@" /></ss:Style><ss:Style  ss:ID="headercell"><ss:Font ss:Bold="1" ss:Size="10"  /><ss:Alignment ss:WrapText="1" ss:Horizontal="Center"  /><ss:Interior ss:Pattern="Solid" ss:Color="#A3C9F1"  /></ss:Style><ss:Style ss:ID="even"><ss:Interior  ss:Pattern="Solid" ss:Color="#CCFFFF" /></ss:Style><ss:Style  ss:Parent="even" ss:ID="evendate"><ss:NumberFormat  ss:Format="[ENG][$-409]dd-mmm-yyyy;@" /></ss:Style><ss:Style  ss:Parent="even" ss:ID="evenint"><ss:NumberFormat ss:Format="0"  /></ss:Style><ss:Style ss:Parent="even"  ss:ID="evenfloat"><ss:NumberFormat ss:Format="0.00"  /></ss:Style><ss:Style ss:ID="odd"><ss:Interior  ss:Pattern="Solid" ss:Color="#CCCCFF" /></ss:Style><ss:Style  ss:Parent="odd" ss:ID="odddate"><ss:NumberFormat  ss:Format="[ENG][$-409]dd-mmm-yyyy;@" /></ss:Style><ss:Style  ss:Parent="odd" ss:ID="oddint"><ss:NumberFormat ss:Format="0"  /></ss:Style><ss:Style ss:Parent="odd"  ss:ID="oddfloat"><ss:NumberFormat ss:Format="0.00"  /></ss:Style></ss:Styles><ss:Worksheet  ss:Name="undefined"><ss:Names><ss:NamedRange  ss:Name="Print_Titles" ss:RefersTo="='undefined'!R1:R2"  /></ss:Names><ss:Table x:FullRows="1" x:FullColumns="1"  ss:ExpandedColumnCount="14" ss:ExpandedRowCount="3"><ss:Column  ss:AutoFitWidth="1" ss:Width="40" /><ss:Column ss:AutoFitWidth="1"  ss:Width="60" /><ss:Column ss:AutoFitWidth="1" ss:Width="100"  /><ss:Column ss:AutoFitWidth="1" ss:Width="50" /><ss:Column  ss:AutoFitWidth="1" ss:Width="50" /><ss:Column ss:AutoFitWidth="1"  ss:Width="75" /><ss:Column ss:AutoFitWidth="1" ss:Width="75"  /><ss:Column ss:AutoFitWidth="1" ss:Width="75" /><ss:Column  ss:AutoFitWidth="1" ss:Width="75" /><ss:Column ss:AutoFitWidth="1"  ss:Width="150" /><ss:Column ss:AutoFitWidth="1" ss:Width="50"  /><ss:Column ss:AutoFitWidth="1" ss:Width="100" /><ss:Column  ss:AutoFitWidth="1" ss:Width="100" /><ss:Column  ss:AutoFitWidth="1" ss:Width="100" /><ss:Row  ss:Height="38"><ss:Cell ss:StyleID="title"  ss:MergeAcross="13"><ss:Data  xmlns:html="http://www.w3.org/TR/REC-html40"  ss:Type="String"><html:B><html:U><html:Font  html:Size="15">undefined</html:Font></html:U></html:B></ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell></ss:Row><ss:Row  ss:AutoFitHeight="1"><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Fiche</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data ss:Type="String">N°  Offre</ss:Data><ss:NamedCell ss:Name="Print_Titles"  /></ss:Cell><ss:Cell ss:StyleID="headercell"><ss:Data  ss:Type="String">Type</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Divisible</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Nature</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Disponibilité</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Surface</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Loyer</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Prix</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Adresse</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">CP</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Commune</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Offreur</ss:Data><ss:NamedCell  ss:Name="Print_Titles" /></ss:Cell><ss:Cell  ss:StyleID="headercell"><ss:Data  ss:Type="String">Négociateur</ss:Data><ss:NamedCell  ss:Name="Print_Titles"  /></ss:Cell></ss:Row><ss:Row><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">undefined</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">1</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">\\prugnieres\testpdfs\DLEF01010991.pdf</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">8020204</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">L</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">O</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">A</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data ss:Type="String">Voir  descriptif</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">357/1 497</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">70</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String"></ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data ss:Type="String">2/4 ALL?E DE LA  FRESNERIE</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data  ss:Type="String">78330</ss:Data></ss:Cell><ss:Cell  ss:StyleID="even"><ss:Data ss:Type="String">FONTENAY LE  FLEURY</ss:Data></ss:Cell><ss:Cell  ss:StyleID="evenundefined"><ss:Data ss:Type="undefined">PAREF  GESTION</ss:Data></ss:Cell><ss:Cell  ss:StyleID="evenundefined"><ss:Data ss:Type="undefined">DE  SAINT REMY  Thibault</ss:Data></ss:Cell></ss:Row></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></ss:Workbook>

[alisyah]

Hello Animal,

I have tried your code, and it worked well when I paste it to replace code in examples/array-grid.js.

Now I am trying to use your code in my program.
The button (which titled as Excel) is shown perfectly. But when I click it, FireBug shows an error:
"cm is undefined", which links to this code: for (var i = 0; i < cm.getColumnCount(); i++) { ... }

Does it mean that code "var cm = this.getColumnModel();" is not working?
What should I check to get it run?

Fyi, I put the grid in a panel.

I appreciate any comments or suggestions.
Thanks.

[Surinder singh]

Hi

try this http://www.developerextensions.com/i...1.4&Itemid=480

[robshim]

I can't open this site - http://www.developerextensions.com -in IE or Firefox!