title: Calendar with date and datetime picker keywords: Jexcel, javascript, excel-like, spreadsheet, date, datetime, calendar description: Example from basic to advanced calendar usage, date and datetime picker # Calendar column type The example below shows how to use and customize special calendar column type. Jspreadsheet uses the jSuites [Javascript Calendar](https://jsuites.net/docs/javascript-calendar) plugin ### Source code ```html
``` ## Date column customization Customize the format and the behavior of your column through the initialization options, as follow: {.ignore} ```javascript options : { // Date format format:'DD/MM/YYYY', // Allow keyboard date entry readonly:0, // Today is default today:0, // Show timepicker time:0, // Show the reset button resetButton:true, // Placeholder placeholder:'', // Translations can be done here months:['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'], weekdays:['Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'], weekdays_short:['S', 'M', 'T', 'W', 'T', 'F', 'S'], // Value value:null, // Events onclose:null, onchange:null, // Fullscreen (this is automatic set for screensize < 800) fullscreen:false, }; ``` More information about the jSuites [Responsive date time picker](https://jsuites.net/docs/javascript-calendar) Considering the example above, you can create a calendar including a time picker by simple send the option **time:1** as the following example. ```html
```