Back to Examples

Email and links

Adding email or links in your javascript spreadsheet.

<html>
<script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />


<div id="spreadsheet"></div>

<script>
let data = [
    [ '1', 'richard@gmail.com', 'https://bossanova.uk/jspreadsheet' ],
    [ '2', 'sergiomartins@gmail.com', 'https://google.com' ],
];

jspreadsheet(document.getElementById('spreadsheet'), {
    data: data,
    columns: [
        {
            type: 'dropdown',
            width: '140px',
            title: 'Name',
            source: [
                {
                    id:'1',
                    name: 'Jorge'
                },
                {
                    id:'2',
                    name: 'Sergio Martins'
                }
            ]
         },
        {
            type: 'email',
            width: '250px',
            title: 'Email'
        },
        {
            type: 'url',
            width: '250px',
            title: 'Url'
        },
    ],
    license: 'ZTkxNjA3MjUwZDNjYWI0ZDg4NmRhMWZkYmU4YWRkNTE0ODUwMWY4ZTk5MmMwNzZiZjFjYWY0YjgzNWI3YjdjZTU2MTZmODZmNTY0YWNlN2Y1NGJlZmE1YTc5NWY3MzRiYjJhNzFmNTc5OTAwOTZkM2E4OTBiZTc1NzcwNGYzZjUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpFM01EUTNOemsxTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0ozWldJaUxDSnNiMk5oYkdodmMzUWlYU3dpY0d4aGJpSTZJak0wSWl3aWMyTnZjR1VpT2xzaWRqY2lMQ0oyT0NJc0luWTVJaXdpZGpFd0lpd2lkakV4SWl3aVkyaGhjblJ6SWl3aVptOXliWE1pTENKbWIzSnRkV3hoSWl3aWNHRnljMlZ5SWl3aWNtVnVaR1Z5SWl3aVkyOXRiV1Z1ZEhNaUxDSnBiWEJ2Y25SbGNpSXNJbUpoY2lJc0luWmhiR2xrWVhScGIyNXpJaXdpYzJWaGNtTm9JaXdpY0hKcGJuUWlMQ0p6YUdWbGRITWlMQ0pqYkdsbGJuUWlMQ0p6WlhKMlpYSWlMQ0p6YUdGd1pYTWlYU3dpWkdWdGJ5STZkSEoxWlgwPQ==',
});
</script>
</html>