Examples
Autonumber
The native auto increment column type
Source code
<html> <script src="https://jexcel.net/v7/jexcel.js"></script> <script src="https://jexcel.net/v7/jsuites.js"></script> <link rel="stylesheet" href="https://jexcel.net/v7/jexcel.css" type="text/css" /> <link rel="stylesheet" href="https://jexcel.net/v7/jsuites.css" type="text/css" /> <div id="spreadsheet"></div> <script> var data = [ ["1","DIVINELY UNINSPIRED TO A HELLISH EXTENT","LEWIS CAPALDI"], ["2","NO 6 COLLABORATIONS PROJECT","ED SHEERAN"], ["3","THE GREATEST SHOWMAN","MOTION PICTURE CAST RECORDING"], ["4","WHEN WE ALL FALL ASLEEP WHERE DO WE GO","BILLIE EILISH"], ["5","STAYING AT TAMARA'S","GEORGE EZRA"], ["6","BOHEMIAN RHAPSODY - OST","QUEEN"], ["7","THANK U NEXT","ARIANA GRANDE"], ["8","WHAT A TIME TO BE ALIVE","TOM WALKER"], ["9","A STAR IS BORN","MOTION PICTURE CAST RECORDING"], ["10","YOU'RE IN MY HEART","ROD STEWART"] ]; jexcel(document.getElementById('spreadsheet'), { data: data, columns: [ { type: 'autonumber', title: 'Id', readOnly: true }, { type: 'text', width: '350px', title: 'Title' }, { type: 'text', width: '250px', title: 'Artist' }, ], license: 'YjQzMzdlOTRiOGY3ZTQ0ZDQ4ZTI1YWU3MDFjMDI0ZWJmOTNjODA1NWFiZTRiNDJhNmRiYTJlZjkwODQ3N2IwMWRmNWRjYWUwZDViM2VhMmI3NzVjOTcwMzVlN2ZhODI1Y2EyMmE3NDI0ZmE0ZjVmNGQ2MWEzN2M3MTA4MThhMDUsZXlKdVlXMWxJam9pY0dGMWJDNW9iMlJsYkNJc0ltUmhkR1VpT2pFMk16SXdPVEkwTURBc0ltUnZiV0ZwYmlJNld5SnFjMlpwWkdSc1pTNXVaWFFpTENKcVpYaGpaV3d1Ym1WMElpd2lZMjlrWlhOaGJtUmliM2d1YVc4aUxDSnFjMmhsYkd3dWJtVjBJaXdpTVROemQyMHVZM05pTG1Gd2NDSXNJbXh2WTJGc2FHOXpkQ0pkTENKd2JHRnVJam9pTXlKOQ==', }); </script> </html>