Join the Mozilla’s Test Days event from Dec 2–8 to test the new Firefox address bar on Firefox Beta 134 and get a chance to win Mozilla swag vouchers! 🎁

Mozilla サポートの検索

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

詳しく学ぶ

このスレッドはアーカイブに保管されました。 必要であれば新たに質問してください。

encodeURIComponent(), base64_encode() ne marchent plus depuis la derneière version

more options

window.open('data:application/vnd.ms-excel;base64,' + base64_encode(tab_text));


function ExportToExcel(mytblId){

      var htmltable= document.getElementById('my-table-id');
      var html = htmltable.outerHTML;
      window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));
   }

Ne marche plus sur fireFox depuis la dernière version, j'ai testé sur plein de sites qui utilise la même chose,et ça ne marche pas

window.open('data:application/vnd.ms-excel;base64,' + base64_encode(tab_text)); function ExportToExcel(mytblId){ var htmltable= document.getElementById('my-table-id'); var html = htmltable.outerHTML; window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html)); } Ne marche plus sur fireFox depuis la dernière version, j'ai testé sur plein de sites qui utilise la même chose,et ça ne marche pas

すべての返信 (6)

more options

encodeURIComponent() is a built-in function and should still be working in Firefox 48. However, it does not create a valid data URI.

base64_encode() is not a native JavaScript function; it appears to be a php function, or perhaps it is a function in a script library you are using? In JavaScript, you could try btoa():

https://developer.mozilla.org/docs/Web/API/WindowBase64/btoa

more options

Bonjour, J'ai testé, mais ça ne marche pas. Ci-joint le code Jord Burgos. le csv marche mais pas l'extraction excel.

Merci d'avance. /** /** excellentexport.js**/

* ExcellentExport.
* A client side Javascript export to Excel.
*
* @author: Jordi Burgos ([email protected])
*
* Based on:
* https://gist.github.com/insin/1031969
* http://jsfiddle.net/insin/cmewv/
*
* CSV: http://en.wikipedia.org/wiki/Comma-separated_values
*/

/*

* Base64 encoder/decoder from: http://jsperf.com/base64-optimized
*/

/*jslint browser: true, bitwise: true, plusplus: true, vars: true, white: true */

var characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/='; var fromCharCode = String.fromCharCode; var INVALID_CHARACTER_ERR = (function () {

       "use strict";
       // fabricate a suitable error object
       try {
           document.createElement('$');
       } catch (error) {
           return error;
       }
   }());

// encoder if (!window.btoa) {

   window.btoa = function (string) {
       "use strict";
       var a, b, b1, b2, b3, b4, c, i = 0, len = string.length, max = Math.max, result = ;

       while (i < len) {
           a = string.charCodeAt(i++) || 0;
           b = string.charCodeAt(i++) || 0;
           c = string.charCodeAt(i++) || 0;
           if (max(a, b, c) > 0xFF) {
               throw INVALID_CHARACTER_ERR;
           }
           b1 = (a >> 2) & 0x3F;
           b2 = ((a & 0x3) << 4) | ((b >> 4) & 0xF);
           b3 = ((b & 0xF) << 2) | ((c >> 6) & 0x3);
           b4 = c & 0x3F;
           if (!b) {
               b3 = b4 = 64;
           } else if (!c) {
               b4 = 64;
           }
           result += characters.charAt(b1) + characters.charAt(b2) + characters.charAt(b3) + characters.charAt(b4);
       }
       return result;
   };

}

// decoder if (!window.atob) {

   window.atob = function(string) {
       "use strict";
       string = string.replace(new RegExp("=+$"), );

       var a, b, b1, b2, b3, b4, c, i = 0, len = string.length, chars = [];
       if (len % 4 === 1) {
           throw INVALID_CHARACTER_ERR;
       }
       while (i < len) {
           b1 = characters.indexOf(string.charAt(i++));
           b2 = characters.indexOf(string.charAt(i++));
           b3 = characters.indexOf(string.charAt(i++));
           b4 = characters.indexOf(string.charAt(i++));
           a = ((b1 & 0x3F) << 2) | ((b2 >> 4) & 0x3);
           b = ((b2 & 0xF) << 4) | ((b3 >> 2) & 0xF);
           c = ((b3 & 0x3) << 6) | (b4 & 0x3F);
           chars.push(fromCharCode(a));
           b && chars.push(fromCharCode(b));
           c && chars.push(fromCharCode(c));
       }
       return chars.join();

   };

}


ExcellentExport = (function() {

   "use strict";
   var version = "1.3";
   var csvSeparator = ',';
   var uri = {excel: 'data:application/vnd.ms-excel;base64,', csv: 'data:application/csv;base64,'};
   var template = {excel: '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">{table}
'}; var csvDelimiter = ","; var csvNewLine = "\r\n"; var base64 = function(s) { return window.btoa(window.unescape(encodeURIComponent(s))); }; var format = function(s, c) { return s.replace(new RegExp("{(\\w+)}", "g"), function(m, p) { return c[p]; }); };
   var get = function(element) {
       if (!element.nodeType) {
           return document.getElementById(element);
       }
       return element;
   };
   var fixCSVField = function(value) {
       var fixedValue = value;
       var addQuotes = (value.indexOf(csvDelimiter) !== -1) || (value.indexOf('\r') !== -1) || (value.indexOf('\n') !== -1);
       var replaceDoubleQuotes = (value.indexOf('"') !== -1);
       if (replaceDoubleQuotes) {
           fixedValue = fixedValue.replace(/"/g, '""');
       }
       if (addQuotes || replaceDoubleQuotes) {
           fixedValue = '"' + fixedValue + '"';
       }
       return fixedValue;
   };
   var tableToCSV = function(table) {
       var data = "";
       var i, j, row, col;
       for (i = 0; i < table.rows.length; i++) {
           row = table.rows[i];
           for (j = 0; j < row.cells.length; j++) {
               col = row.cells[j];
               data = data + (j ? csvDelimiter : ) + fixCSVField(col.textContent.trim());

           }
           data = data + csvNewLine;
       }
       return data;
   };
   var ee = {
       /** @expose */
       excel: function(anchor, table, name) {
           table = get(table);
           var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML};
           var hrefvalue = uri.excel + base64(format(template.excel, ctx));
           anchor.href = hrefvalue;
           // Return true to allow the link to work
           return true;
       },
       /** @expose */
       csv: function(anchor, table, delimiter, newLine) {
           if (delimiter !== undefined && delimiter) {
               csvDelimiter = delimiter;
           }
           if (newLine !== undefined && newLine) {
               csvNewLine = newLine;
           }
           table = get(table);
           var csvData = tableToCSV(table);
           var hrefvalue = uri.csv + base64(csvData);
           anchor.href = hrefvalue;
           return true;
       }
   };
   return ee;

}());

/** Index.html. **/

<title>Export to excel test</title> <script src="excellentexport.js"></script> <style> table, tr, td { border: 1px black solid; } </style> Export to Excel
Export to CSV - UTF8
Export to CSV - Using semicolon ";" separator - UTF8

Column 1 Column "cool" 2 Column 3 Column 4
100,111 200 300 áéíóú
400 500 600 àèìòù
Text More text Text with new line ç ñ ÄËÏÖÜ äëïöü

more options
more options

hi, support.mozilla.org is intended for end-user support. if you have a question regarding web development please refer to Where to go for developer support instead. thank you for your understanding!

more options

Hello, Have you checked before answering me?!. I do not have a programming problem. Everything worked on my applications and full else on the web that uses the "end-user". but from version 48, nothing works.

This is not serious, it was just to tell you, because I love Firefox. But full user starts to go to Chrome, with Chrome, because it works.

Bonjour, Avez-vous vérifié avant de me répondre?!. je n'ai pas un problème de programmation. Tout marchait bien sur mes applications et sur pleines d'autre sur le WEB que utilise le "end-user ". mais à partir de la version 48, rien ne marche.

Ce n'est pas grave, c'était juste pour vous informer, car j'aime Firefox. Mais plein d'utilisateur commence à aller vers Chrome car avec chrome ça marche.

more options

If I try the "Export table to Excel" table in the 2014 article, both Firefox and Chrome open Excel without any workbook. When I look at the .xls file on disk -- Firefox and Chrome receive the identical file -- it doesn't seem to be in any recognizable Excel format (screen shot attached).

Do you have a more current or relevant link to test?

Note: I'm testing with Excel 2010 on Windows.

この投稿は jscher2000 - Support Volunteer により に変更されました