synchronisation input text with data write in jspreadsheet
npm install @jspreadsheet/syncinputThe syncInput plugin sync data of jSpreadsheet in Input hidden.
This plugin is Free
- Sync data in input hidden
jSpreadsheet, a lightweight Vanilla JavaScript plugin, can help you create exceptional web-based interactive tables and spreadsheets. Compatible with most widely-used spreadsheet software, such as Excel or Google Spreadsheet, it offers users an unrivalled Excel-like user experience. It also works well with prominent modern frameworks and flexibly utilizes a large collection of events, extensions and configurations to meet different application requirements. Impress your clients with a better user experience and a great dynamic interactive data management tool.
- jSpreadsheet Pro v8
or
- jSpreadsheet Pro v9
- or
- jSpreadsheet Pro v10
| Option name | Description | Type | Default Value |
|---|---|---|---|
checkRow | Function for checkRow before add in sync value | Function (row data, instance of jSpreadsheet, index rows) → should return true or false | null |
fieldsRequired | Array of index columns or name columns who are not empty | Array | [] |
inputElement | DOMElement of input | DOMElement | null |
inputId | Id of Element, if element not exist, plugin create input with id=inputId and name=inputId, id inputId is null by default input is jSpreadsheet_DATA | String | null |
processedValues | get processed value (replace formula by value) | Boolean | true |
worksheetId | synchronize specifics worksheet identify with worksheetId, by default it's first worksheet loaded | String or Array of Id | null |
if you have a lot a plugins, add on the top autoWidth
Header on page
``HTML
`
Initialize plugin on jSpreadsheet
`JavaScript`
jspreadsheet(document.getElementById('spreadsheet'), {
...
plugins: [
...
{ name:'syncInput', plugin:jss_syncInput, options:{inputId:'IdMyInput'} },
...
],
...
});
You can use this CDN link
`HTML`
javascript
import jss_syncInput from '@jspreadsheet/syncinput';
``Copyright GBonnaire.fr and Code released under the MIT License