Create from a HTML table
From the v4+ is is possible to create a online spreadsheet from a static simple HTML table.
The Official Top 10 biggest albums of 2019
General | |||
Info | Stats | ||
POS | TITLE | ARTIST | PEAK |
1 | DIVINELY UNINSPIRED TO A HELLISH EXTENT | LEWIS CAPALDI | 1 |
2 | NO 6 COLLABORATIONS PROJECT | ED SHEERAN | 1 |
3 | THE GREATEST SHOWMAN | MOTION PICTURE CAST RECORDING | 1 |
4 | WHEN WE ALL FALL ASLEEP WHERE DO WE GO | BILLIE EILISH | 1 |
5 | STAYING AT TAMARA'S | GEORGE EZRA | 1 |
6 | BOHEMIAN RHAPSODY - OST | QUEEN | 3 |
7 | THANK U NEXT | ARIANA GRANDE | 1 |
8 | WHAT A TIME TO BE ALIVE | TOM WALKER | 1 |
9 | A STAR IS BORN | MOTION PICTURE CAST RECORDING | 1 |
10 | YOU'RE IN MY HEART | ROD STEWART | 1 |
=SUMCOL(TABLE(), 3) |
Source code
<html> <script src="https://bossanova.uk/jspreadsheet/v4/jexcel.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v4/jexcel.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <h4>The Official Top 40 biggest albums of 2019</h4> <table id="spreadsheet"> <thead> <tr> <td colspan='4'>General</td> </tr> <tr> <td colspan='3'>Info</td> <td colspan='1'>Stats</td> </tr> <tr> <td id='pos'>POS</td> <td id='title'>TITLE</td> <td id='artist'>ARTIST</td> <td id='peak'>PEAK</td> </tr> </thead> <tbody> <tr> <td>1</td> <td>DIVINELY UNINSPIRED TO A HELLISH EXTENT</td> <td>LEWIS CAPALDI</td> <td>1</td> </tr> <tr> <td>2</td> <td>NO 6 COLLABORATIONS PROJECT</td> <td>ED SHEERAN</td> <td>1</td> </tr> <tr> <td>3</td> <td>THE GREATEST SHOWMAN</td> <td>MOTION PICTURE CAST RECORDING</td> <td>1</td> </tr> <tr> <td>4</td> <td>WHEN WE ALL FALL ASLEEP WHERE DO WE GO</td> <td>BILLIE EILISH</td> <td>1</td> </tr> <tr> <td>5</td> <td>STAYING AT TAMARA'S</td> <td>GEORGE EZRA</td> <td>1</td> </tr> <tr> <td>6</td> <td>BOHEMIAN RHAPSODY - OST</td> <td>QUEEN</td> <td>3</td> </tr> <tr> <td>7</td> <td>THANK U NEXT</td> <td>ARIANA GRANDE</td> <td>1</td> </tr> <tr> <td>8</td> <td>WHAT A TIME TO BE ALIVE</td> <td>TOM WALKER</td> <td>1</td> </tr> <tr> <td>9</td> <td>A STAR IS BORN</td> <td>MOTION PICTURE CAST RECORDING</td> <td>1</td> </tr> <tr> <td>10</td> <td>YOU'RE IN MY HEART</td> <td>ROD STEWART</td> <td>1</td> </tr> </tbody> <tfoot> <tr> <td></td> <td></td> <td></td> <td>=SUMCOL(TABLE(), 3)</td> </tr> </tfoot> </table> <br> <script> jspreadsheet(document.getElementById('spreadsheet')); </script> </html>