Documentation
Most common questions and answers
What is the best way to create odd/even rows on a online spreadsheets?
How to transform multiple HTML static tables in dynamic jspreadsheet tables?
How to disable paste over a jspreadsheet spreadsheet?
How to intercept and change a pasted string over a Jspreadsheet table?
How to overwrite a type of a cell over a column type?
How to disabled the javascript contextmenu of my spreadsheet?
How to change the default download filename?
How to add an external action without losing the spreadsheet focus?
How to keep the selection of the spreadsheet clicking in a element outside.
Solution: Adding the following CSS code on your project.
.jexcel tbody tr:nth-child(even) { background-color: #EEE9F1 !important; }
var tables = document.querySelectorAll('table'); for (var i = 0; i < tables.length; i++) { jspreadsheet(tables[i]); }
jspreadsheet(document.getElementById('spreadsheet'), { onbeforepaste: function(instance, data, x, y) { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { onbeforepaste: function(instance, data, x, y) { data = data.replace(',', '.', data); return data; } });
jspreadsheet(document.getElementById('spreadsheet'), { columns: [ { type: 'text' }, { type: 'text' }, ], cells: { B2: { type:'number', mask:'$ #,##.00', decimal:'.' }, B3: { type:'percent' }, } });NOTE: Only available from Jspreadsheet Pro v7.
jspreadsheet(document.getElementById('spreadsheet'), { columns: [ { type: 'text' }, { type: 'text' }, ], contextMenu: function() { return false; } });
jspreadsheet(document.getElementById('spreadsheet'), { csvFileName: 'yourname' });
Working example:
https://jsfiddle.net/spreadsheet/v5tbxg01/Add a class to the external element: jexcel_object