Search and replace
This extensions adds the search and replace features to the JSS spreadsheets.Author
Jspreadsheet Pro Team.License
Available on the premium edition only.Installation
Please choose one of the following options// From NPM npm install @jspreadsheet/search // From CDN https://cdn.jsdelivr.net/npm/@jspreadsheet/search/dist/index.min.js
Example
Click in the search icon in the toolbar to open the search and replace features.Browser
NPM
<html> <script src="https://jspreadsheet.com/v9/jspreadsheet.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" /> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" /> <script src="https://cdn.jsdelivr.net/npm/lemonadejs/dist/lemonade.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/search/dist/index.min.js"></script> <div id="spreadsheet"></div> <script> // Set the license for both plugin and the spreadsheet jspreadsheet.setLicense('OWY1OTQ0NGZiMjQ1YjU0ZjY0NWMyNjAyZTI0M2JkNTAwNDE4MGJhYmNlYzhiZTkzMGQ5MmJmZGRmNTI5NjZkMmMyYWEzMDQ4NTk5NDNjMjc0YzZlMjJkOWRlYjAxZDI5MjNjOGQwMmRiYmJhNDA5Yzk0ODhhMzFlMDA1ZjU2YjAsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTRNRGsxTURrM09Td2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Set the extensions jspreadsheet.setExtensions({ search }); // Create the spreadsheet var spreadsheet = jspreadsheet(document.getElementById('spreadsheet'), { toolbar: true, worksheets: [{ minDimensions: [10, 10], }] }); </script> </html>
// Jspreadsheet Pro import jspreadsheet from 'jspreadsheet'; // Import extension import search from '@jspreadsheet/search'; // Set the license for both plugin and the spreadsheet jspreadsheet.setLicense('OWY1OTQ0NGZiMjQ1YjU0ZjY0NWMyNjAyZTI0M2JkNTAwNDE4MGJhYmNlYzhiZTkzMGQ5MmJmZGRmNTI5NjZkMmMyYWEzMDQ4NTk5NDNjMjc0YzZlMjJkOWRlYjAxZDI5MjNjOGQwMmRiYmJhNDA5Yzk0ODhhMzFlMDA1ZjU2YjAsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTRNRGsxTURrM09Td2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Set the extensions jspreadsheet.setExtensions({ search }); // Create the spreadsheet var spreadsheet = jspreadsheet(document.getElementById('spreadsheet'), { toolbar: true, worksheets: [{ minDimensions: [10, 10], }] });