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?
Printable View
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?
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...?
It doesn't work with ExtJs 3.3.0 and FireFox 3.6.13 : when I click the link button, FireFox crash completely !!!
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....)
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.)?
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
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 :
Code:<?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 &P of &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>
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.
I can't open this site - http://www.developerextensions.com -in IE or Firefox!