DataTable Export EXCEL - JSFiddle

HTML

xxxxxxxxxx
 
<table id="tb_rgc" class="display compact cell-border textos" cellspacing="0" width="100%">
</table>

JavaScript

Module

xxxxxxxxxx
 
// AJAX emulation
$.mockjax({
    url: '/test/0',
    responseTime: 250,
    response: function(settings){
        this.responseText = { "data" : [
          { "cd" : 795, "ds" : "Abc", "v1" : 123.45, "v2" : 91234.56 }
         ,{ "cd" : 795, "ds" : "Def", "v1" : 123.45, "v2" : 91234.56 }
        ] }
    }
});
​
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
​
$.extend( true, $.fn.dataTable.defaults, {
   "dom":      "lBftip"
  , rowId:      "cd"
  , "scrollY":         "200px"
  , "scrollCollapse":  true
  , "lengthMenu":      [[10, 100, 500, 1000, -1], [10, 100, 500, 1000, "Todos"]]
  , "pageLength":      1000
  , "processing":      true
  , "deferRender":     true
  , buttons: true
  , select: { style: "multi", selector: "td:first-child"}
  , buttons: [ {extend:"excel", exportOptions: { orthogonal: 'export' }}]
  , colReorder: true
});
​
​
$('#tb_rgc').DataTable({
    "ajax": { url: "/test/0", type: "POST"},
    "columns": [
      { "data": "ds", title: "Desc." },
      { "data": "v1", title: "Val 1", render: $.fn.dataTable.render.number(".", ",", 2) },
      { "data": "v2", title: "Val 2", render: $.fn.dataTable.render.number(".", ",", 2) }
    ]
});
​

CSS

xxxxxxxxxx
 
​

609px

JSFiddle Console. Turn on/off in Editor settings.
☁️ "Running fiddle"
"MOCK POST: /test/0", { accepts: { *: "*/*", html: "text/html", json: "application/json, text/javascript", script: "text/javascript, application/javascript, application/ecmascript, application/x-ecmascript", text: "text/plain", xml: "application/xml, text/xml" }, async: true, cache: false, contents: { html: [object RegExp] { ... }, json: [object RegExp] { ... }, script: [object RegExp] { ... }, xml: [object RegExp] { ... } }, contentType: "application/x-www-form-urlencoded; charset=UTF-8", converters: { * text: function String() { [native code] }, text html: true, text json: function( data ) { // Attempt to parse using the native JSON parser first if ( window.JSON && window.JSON.parse ) { return window.JSON.parse( data ); } if ( data === null ) { return data; } if ( typeof data === "string" ) { // Make sure leading/trailing whitespace is removed (IE can't handle it) data = jQuery.trim( data ); if ( data ) { // Make sure the incoming data is actual JSON // Logic borrowed from http://json.org/json2.js if ( rvalidchars.test( data.replace( rvalidescape, "@" ) .replace( rvalidtokens, "]" ) .replace( rvalidbraces, "")) ) { return ( new Function( "return " + data ) )(); } } } jQuery.error( "Invalid JSON: " + data ); }, text script: function( text ) { jQuery.globalEval( text ); return text; }, text xml: function( data ) { var xml, tmp; if ( !data || typeof data !== "string" ) { return null; } try { if ( window.DOMParser ) { // Standard tmp = new DOMParser(); xml = tmp.parseFromString( data , "text/xml" ); } else { // IE xml = new ActiveXObject( "Microsoft.XMLDOM" ); xml.async = "false"; xml.loadXML( data ); } } catch( e ) { xml = undefined; } if ( !xml || !xml.documentElement || xml.getElementsByTagName( "parsererror" ).length ) { jQuery.error( "Invalid XML: " + data ); } return xml; } }, data: { ... }, dataType: "json", error: function(b,c){var d=r(a,null,"xhr",[a,null,a.jqXHR]);-1===h.inArray(!0,d)&&("parsererror"==c?K(a,0,"Invalid JSON response",1):4===b.readyState&&K(a,0,"Ajax error",7));C(a,!1)}, flatOptions: { context: true, url: true }, global: true, isLocal: false, jsonp: "callback", jsonpCallback: function() { var callback = oldCallbacks.pop() || ( jQuery.expando + "_" + ( ajax_nonce++ ) ); this[ callback ] = true; return callback; }, processData: true, responseFields: { text: "responseText", xml: "responseXML" }, success: function(b){var c= b.error||b.sError;c&&K(a,0,c);a.json=b;i(b)}, type: "POST", url: "/test/0", xhr: function createStandardXHR() { try { return new window.XMLHttpRequest(); } catch( e ) {} } }

New Automatically expiring fiddles

Add expiration date to your fiddle (time button next to Save), it can be: 1 day, 10 days, 1 month, 6 months, 1 year, and you can keep the fiddle forever. Right now the default is Keep forever but this will probably change.
Ability to download a fiddle

We've added the ability to download a specific fiddle version from the Editor's interface. I'll be downloaded as a Zipped single HTML file.
Your recent fiddles when logged out

Saving a fiddle, even when you're logged out, will put it under the Your recent fiddles modal in the sidebar. They will eventually disappear (since they're anonymous), but now you'll have time to save them under your user after logging in.
Tailwind CSS

Added Tailwind CSS to the list of precompilers - even though it's really HTML, you can activate it from the dropdown in the CSS panel. Tailwind CSS would be best used with HTML Hot-reload enabled.
Code linting and formatting

We've replaced the dated code linter and formatted with more modern ones: Stylelint and Prettier.
JSFiddle 3.0
The 3.0 updates brings a lot of changes, most notably a modern UI refresh.

There was an increadible amount of under-the-hood changes for the front-end, we've mostly moved away from pre-processors. The light/dark themes are using a modern light-dark() approach. The refactoring allows for more changes to be made in a spedier manner.
- In the new sidebar you can find our mini-apps (right now the Color Palette Generator)
- System theme follows your OS settings
- CSS Hot-reload - styles update immidietly as you type
- HTML Hot-reload (experimental) - update HTML immidietly as you type
- Results panel color follows the selected theme
- Title and description are now a single field
- Public Profile page is completelty redesigned and can be easily used as your code showcase
- Groups are now Collections and we have big plans for them
- Collections are completely redesigned
- Users can now add groups straight from the editor
Import fiddles as modules

Import fiddle code into other fiddles with Modules and Imports.

JS Modules: import [name] from '@jsfiddle/[username]/[fiddle].js'

CSS Import: @import url('@jsfiddle/[username]/[fiddle].css')

See how this works in this fiddle.
Fiddle listing shows latest version

The fiddle listings (Public, Private, Titled, etc) will now display latest versions instead of the ones saved as Base versions - this was causing more confusion than good, so we decided to change this long-standing behavior.
Evaluate code into the console

Custom Console beta is getting more stable and feature-rich. Just added the ability to evaluate code in the console.

Console

Ad-free

Use pre-released features

Fiddle collections

Private collections and fiddles

Console

Console

Language

Doctype

Language

Extensions

script attribute

Language

Reset CSS

Keep JSFiddle running.Whitelist us in your content blocker.

Join the 4+ million users, and keep the JSFiddle dream alive.

Ad-free

Use pre-released features

Fiddle collections

Private collections and fiddles

Console

Tabs:

Visual:

Embed snippet Prefer iframe?:

Behavior

General

Console

New Automatically expiring fiddles

Ability to download a fiddle

Your recent fiddles when logged out

Tailwind CSS

Code linting and formatting

JSFiddle 3.0

Import fiddles as modules

Fiddle listing shows latest version

Evaluate code into the console

`script` attribute

Keep JSFiddle running.
Whitelist us in your content blocker.