Spreadsheet images
This section is dedicated to handling images in the web based spreadsheet.Documentation
The image type brings a few options as shown below:Method | Description |
---|---|
absolute: Boolean | True for a floating image or false for an image within a cell. |
width: Number | Width of the image |
height: Number | Height of the image |
top: Number | Top reference of the image |
left: Number | Left reference of the image |
Examples
Basic image editor
Define the image upload editor for a column. The images will be stored as base 64 in the raw data.Double click in the image cell to upload a new image.
Source code
<html> <script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script> <script src="https://jsuites.net/v5/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" /> <div id="spreadsheet"></div> <script> // Set the JSS spreadsheet license jspreadsheet.setLicense('Yzk3ZWMzNDBlZDc2Y2E4NWIzZTc2MTUwZTg0YmYxMTRmZTU1NWFmMDc5ZDIzMWI2ZWExZDk1MzJiYzE3OTk0ZjExODQ1NDJhYThiYTI5YzZjNTk5YTUyYzc5OWM1NGI0NDY5MDNiMjM3NjFmZTBmZTkwZWViOGUyNGFlNGI3MWQsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTVOalV3TWpJMk15d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWQyVmlJaXdpYkc5allXeG9iM04wSWwwc0luQnNZVzRpT2lJek5DSXNJbk5qYjNCbElqcGJJblkzSWl3aWRqZ2lMQ0oyT1NJc0luWXhNQ0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owSWl3aVltRnlJaXdpZG1Gc2FXUmhkR2x2Ym5NaUxDSnpaV0Z5WTJnaUxDSndjbWx1ZENJc0luTm9aV1YwY3lKZExDSmtaVzF2SWpwMGNuVmxmUT09'); // Create the spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ data: [ ['LemonadejS', 'https://lemonadejs.net/templates/default/img/components.svg'], ], minDimensions: [2,4], columns: [ { type:'text', width:300, title:'Title' }, { type:'image', width:120, title:'Image' }, ], }], }); </script> </html>
Floating images
The following example shows how to embed a floating image.Source code
<html> <script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script> <script src="https://jsuites.net/v5/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" /> <div id="spreadsheet"></div> <script> // Set the JSS spreadsheet license jspreadsheet.setLicense('Yzk3ZWMzNDBlZDc2Y2E4NWIzZTc2MTUwZTg0YmYxMTRmZTU1NWFmMDc5ZDIzMWI2ZWExZDk1MzJiYzE3OTk0ZjExODQ1NDJhYThiYTI5YzZjNTk5YTUyYzc5OWM1NGI0NDY5MDNiMjM3NjFmZTBmZTkwZWViOGUyNGFlNGI3MWQsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTVOalV3TWpJMk15d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWQyVmlJaXdpYkc5allXeG9iM04wSWwwc0luQnNZVzRpT2lJek5DSXNJbk5qYjNCbElqcGJJblkzSWl3aWRqZ2lMQ0oyT1NJc0luWXhNQ0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owSWl3aVltRnlJaXdpZG1Gc2FXUmhkR2x2Ym5NaUxDSnpaV0Z5WTJnaUxDSndjbWx1ZENJc0luTm9aV1YwY3lKZExDSmtaVzF2SWpwMGNuVmxmUT09'); // Create the spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ data: [ ['LemonadeJS', 'https://lemonadejs.net/templates/default/img/home.png'], ], minDimensions: [4,4], cells: { B1: { type:'image', options: { absolute: true, width: '200px' } } }, }] }); </script> </html>