jSpreadsheet plugin editors :


Date & DateTime




/* Extract of Options of JExcel */
columns: [
    {
        type: 'text',
        title:'Source/Text',
    },
    {
        type: 'date',
        title:'Editor Date',
    },
    {
        type: 'date',
        title:'Editor Date with format (EN)',
        locales: "EN",
        formatOutputOnCell: { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' },
    },
    {
        type: 'date',
        title:'Editor Date with format (FR)',
        locales: "FR",
        formatOutputOnCell: { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' },
    },
    {
        type: 'datetime',
        title:'Editor DateTime',
    }
 ],
                        


Numeral




/* Extract of Options of JExcel */
columns: [
    {
        type: 'number',
        title:'Source/Text',
    },
    {
        type: 'numeral',
        title:'Editor Numeral',
    },
    {
        type: 'numeral',
        title:'Editor Numeral with Format',
        mask: '0[.]00a'
    },
    {
        type: 'numeral',
        title:'Editor Numeral with format and custom decimal',
        mask: '0.00',
        decimal: ','
    }
 ],
                        

List of formats availables



Text with Pattern




/* Extract of Options of JExcel */
columns: [
    {
        type: 'text',
        title:'Source/Text',
    },
    {
        type: 'textpattern',
        title:'Force chars Id',
        pattern: "[0-9a-zA-Z]*",
    },
    {
        type: 'textpattern',
        title:'Force chars Id Uppercase',
        pattern: "[0-9a-zA-Z]*",
        uppercase: true,
    },
    {
        type: 'textpattern',
        title:'Force chars Email',
        pattern: "[0-9a-zA-Z@.]*",
    }
 ],
                        

This plugins are the free plugins available on Repo of JSpreadsheet plugins

Download full version

get started to use this plugin with this CDN :


<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/editors/dates/jexcel.editor.date.js"></script>
<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/editors/dates/jexcel.editor.datetime.js"></script>
<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/editors/dates/jexcel.editor.time.js"></script>
<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/editors/numeric/jexcel.editor.numeral.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/numeral.js/2.0.6/numeral.min.js"></script>
<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/editors/text/jexcel.editor.textpattern.js"></script>