Richtext and HTML editor column type

Adding a HTML Editor input in your spreadsheet



Source code

<html>
<script src="https://bossanova.uk/jspreadsheet/v4/jexcel.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v4/jexcel.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" />

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

<script>
var options = {
    data: [
       [ 'the Sorcerer`s Stone', '<img align="left" src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAKAAgQMBIgACEQEDEQH/xAAbAAACAwEBAQAAAAAAAAAAAAAFBwAEBgMCAf/EAEEQAAIBAgQEBAQEAggEBwAAAAECAwQRAAUSIQYTMUEiUWFxBxQykUKBobEj8BUkUmKywdHhMzRy8RYmNVSCkqL/xAAaAQADAQEBAQAAAAAAAAAAAAACAwQBAAUG/8QALBEAAgIBBAEDAwIHAAAAAAAAAQIAEQMEEiExQRMyMyJRgcHRBRRCYXGhsf/aAAwDAQACEQMRAD8AeOFv8RpGjz2nI/8Abjt/ebDIwu/iLHrzSNj2px+7YRqPZKNL8kAU6VNZGWhppJQDYlFvY+WO9Blk9UGkjjX+G1muQLYu8Gry2rRYgERkXFtvFjrw0S1FVm13KjtuTY4+dz6t13geK/3PSB7g51ULbb7dccdJAVivge+lrbN57/ng4kEdZGaT5UQjk61kK+IuLDv1G+PUlYsWWUklSutZYnUgKNzYW9sb/OlTSrzc4tzAFTSzJHHM8DhCpa9uw2ufTcYoALJKAFHtbG0q/mXiSngEchkpCGWZiB2Gr18vzxl6GlApDXNIoUuYlVlN2I6kYbptX6indxMu4fqMtpaemiZZWQSOoBIvuR6YH1kDU0rxSga16G2xHmMFMzjlkyikUgBgyawzAWspB6n2x4z6nnqq2JYFAVIizs2ygXPf8ugxHptWwYB2vv8AFdTBxAcrJboLEdxjjLF4WR0sw6gjcHBqjoBTZjTpVQiXmXaNj4QLC+6ne/pjo9NSumaVGvQ6sysXuwTxbnYd/IYrOuRWodff81CLCB0ccoKwHhAHTFeRQd9IO/lguuUyHSuoc4xmRYyPqW/6H0/bHuDI1dIT8z/GljaRFC+E9Lfvvgzq8K+Zu4S7wfYZ/CAARynAa1vLDCGF5wd/69Ftb+G/7DDDx6+k+Oedq/k/EmJiYmKpLJjC8chWzONW7wD9zjdYXnxAl5ecw9RanH+JsI1HslGl+SeeHZeZPWOyWlIQs+snX13t2Ptt6DHjKZ0lyytSOCOCOOMhVQkn6TuSdzinlmaxUQk1Qs7vbUQwGw6WFsd8rmpoKCpiedUeYEKGB6WIFz074+V1GBt2Q12RU9GpeiqKVXWq5sS3owpRTuu/QD9LYGVskNXllHS00jSSxEFwkbEgWNyNsCWYA+L8yPPHpJ3hLNGQVZdLo6hlcdbEHrirHoQh3A8zStQ9DmCVOdULUqSgIjxOHHQefX0GBGZVEU1QEpgFpYAUhRe99yw9z/ljiuZTOvIipaOklqINQl5ZXWpF7A6rAEd/S2xxVpYZKiVYQZo3bli5AspcSA372Dx2O/Q3w3T6La26qrr94HRuaTNqqSKiy5FfTMoWQSDoRpZT+4+/pjnlEz1NNm2qeRpOUvjYnyffGfnrXzBqBH5wQUgYFCtlIQswO2/0Adu/pjzR1k1PAKqF9I5LyFGAvbUVCsoJ+q3tgRoT6FCrv9bm2OpsqJf4GT32YK320n/bHGQCTKs3Kbl2bp6YDrnNTSZhEagRtJH4RGpsoHoNtu17dRi9l2Y08bTU0mtY6lyySWHhJ7H/AFxG2kyITx9v+3O8TtnFRVU9fTvRmM6KUyHUinYE3IPXp6455rIRRZcwcrrhINu4IU2xUzFHp/6rDIXRFJ0MBaxIJQHrYWBtsPtjxU5qlZHFBJT8toBaMxN4bEC1wR6Dvh2PSlWQgWBc0DzC3BZds/iJFl5b9e/TDFwueCm157Ce4jcH7DDGGPodL7JDrPk/EmJiYmKZJJhYfE0TDPIXjZdIpBdWH95t8M/C0+Jpvm0Ea3LNTjb01NhOf2R+m+SY+GuKuizjluelx1wQWpUgWtr8j++BlVCsr8ojUpN/S3p645aZ4iIVUylgVivudRFgGA8juD98RhFJnpF2XkQgZfHbt0O+Po51apFCheJTZpW8Maj1c7H8r4rxU8VI6rUzU9RUompoXkCxDcLZ26E6mUeQ1Dr1xerXmmqIZJnngpz/AAhFOq8oyurCzKOhjcLcEkWsb77kMdQGyXPawgKbz60LRwwwpApVSQI95CNy2wOw2x4irKFKGSSSAMkSxoJS8swZWLhQASTYFHB228sD9AeGZJleSspJS0awRgGJpCupbE/hk0kgXPj22ti/V1sRepYVNHSJLErQxTOiILssgKg2BPik1X3B377EIBNT6lRDGqGGip5EKaS0cQjuDFzbeEXI0K48O99O298VYqqKpnmhpqebkaU8cU3MjZAysu72NtWkWuCTtjxLWRSw0q02Y0fzFLAgpZGnvGrgW03vbVdEO++lm7bYIR8iprFipFRqKS8UqRG6cuTY2t2Vj1HkDjiK8Tez3KlTS1PzDSQRcx2LNIUDKxIY6iEf6QD2BI6+ePUFUjwm48S/hOxH5Y5KstPQrAKiomhEJqpijkvO0hAjRWP0k8sbjoCcdJonWQxVEas71DwwyRP4hoj1SFi2xQMGW+x2/PAlA3MIORwYVqMwhOVrPNUwrNEVVYiwaRx0NwCCNtum+BdfURI5dAQC5KqeoW+w/LFKoqDGkckgBV1DRSIQVcX3IPaw7drY9xI61MVRV2Osgqlth7/pjilCajcmaj4fTzy8SQ6otERhksSdz0w1BhZcExaOK0I+loXb9ADhmjFOnNrch1Xv/EmJiYmHyaTCz+IjFeJoCo1sKRTpVvGBqbcDDMwnPjEr/wDiekljJVko1sQbEeNsBkTetR+mNZAZQppI9cswa4LaU1beEdvvf9Mc4qU1lWdPhjh8T2b6j2UW+9/bzxSo6166jnksRV08ZeXykUfiHqNr+mDWWxLHl9FHMQXmUzMD1Ja1h+S/t6Y88g4+fMtdrFDzKcNI9TUJl7q7kRmnMTKDHOjC2xA/hs2gHfwlkBuDjnNmSlPlKSWWrrVRSFSIqWOoAaw3ha8Z0sLkHShvtccaotUQ1RiqpBHGTGZkcoWQFSbsOwNt/Q445tmEOTUcWV5crSVxI1SgamUDoOp362HbDgS3+YpSAOYSrVZH+Zrs4NEnLMaQwyXlXdSfFsd9Kj8XQeI2wI/pLJoR/AykTgkF5ZW1FrbFrPcXt7YEmkn+Y5le8yFzdnPif+fTFgUsTBdLamYeElrh7eXr6dcM2AdmOXG7eKhbOsxypMxh+Uo6ergaEa4uWFW34CLC4YKbH8u+JFTUdUFaIVdCYl8CLd1v5HvbrgVRvCah4J4VWQAlCqjc+uCcFfLRWaNrWNyGFwf9O+HnSsV3YzFIyraP3JFU1tBVU8lbIZ4leO9Yket42UFQdIsNgdrjrgkamlmooJqw/wBUikeNgbkbsNMW25FlVnPkD5nF2jrcqzdWSSSOnqlH17cuT136j33wITKpaXOWpEleOFo9VTBGw0MqkEAHsGuB7E+2IrINMKIhsQBam59b52OnjzOqdJYzKzf8Mr1Y2mIvtswAHYWO/bqs0MxKmyoT4d7hPT2/7YJVkcmoggyxyxjVCoAIJZVsvoQ1ve3njO5vDBliQfLanZ9UZQk6pGG3hHlcG/Tr724KcosQEyFOG6m34CnRs9p4mkUyrHIFGrciw3/bDOGE18MKKb/xdDWVj6pjBIAo6KCB3/LtthyjFePEca0ZLnfe9ifcTExMMiZMK74n0yzcQU5K3Pyqj/8ATYaOMNx1RpV5lHfZ1hGlh7nB4zTRmJdzVFuU+WkSWlTdFu19wb7G/TY3tbA6biPMXTkvSRS8tQg0hl6bdR327YNsYZuZGso5qDwgfiHp6YF1NE/IMyr4CzAHz3wOp9Ot1R4QsauCxxS1PTtTNlkQiKlCpkPQgg/vgtlOUyQQNWTKZaj6ndt9F9h/3xmq6n0SgAfVuR5YYMkxp5UaO2pvwxjcH29b4LTqvYEVsp+TxBBiWYMrysLDYdbm4+3W+Bc1PNSVABtJSyMomHa39r0I63HljQ5k1M007Mhp545NlCaldCLhiB0N7g28umKiyicNNqUo5YGQISL26dNjhh9J++DHLkb+kzO1/Mp6oc3eWF92t9Q6YMVKPWLyyWMksVgV3stgov2tuBvirmlDPJBdI3OgdGU3t6Hofbr5Yv8ABjtPSVHNcqVZYFjWYoz2Go/mBbp2BwtHGNSsLP8AU1/eZ/Msh4lyimirKxDNRutxJA4cBTuAbE2O9+/vvjtwlxS0FTVGukkeOQKvMXxMh3v36Y0vEefTUOWoksjzSSQonIiRo01/2ApuLjTfa99WMHlYqY6mCSsiRIadg6xslgTfYWHXphBpgd0lIN0Ixqd1iyw5nmEjrl8kca0sbtaSRAdWrbtcKBfe3sLjaaY5vmLZo6DTbRAOyqOv6k/rgNxBmlZWwmSrlY6iWC2+n+b41OVBKCky+llbSKhR4S1gxC6rH3ucO0yqtkQiGJAaafghf/NCuSgOmTwr0Ht6YZowpuB6pk4+eib6TCzr/dsi3H6j7YbIxztuMzKKapMTExMDFSYXnxLrvlZwitZ5ILXv9Iubn/f9+hYeFn8RMwpoeIvlcwRXpxl4mAI6NzCux63sccY3CaeKypm6OAVYdLEgg/6/r+2N/wALiOt4Wp0q1+qSS7kd79cBq/g4SXbJ5jcgkQSeIH2I3H54OcIU81LkhpK2F1niqHurb7nT9/8AfEmewksRSr8zA8Q0JoJ3jci6eQt3vf8AQ43GaRrSU0lXGBzI4mZQejWH+/64zvHUegMWYNI4uT622v7f6YJcT5lFDlkbxzIHMKnSVLA3A2JF7beeK9G9pJNXxYHmZpJpaipizRqvn3jDCliJ0qp8Wh97sFYnYj9MW8mrIo6qmpnm5dLzmlka9tIIA/yt+eMhQUtVU1MgoQ3MjiaVgoudK9dvzxssry6McMrV1X/OVp1xMDYrGNlIF977n2K9ML1C1y3mbpWHtHFTvnOe1K1BFJJLFTMdITWWtte+/p26YqZbmjwITRRRiXQnzSVSjxOBYujA7X73wKpsprKmEyUnMnjRyvMjIIJHXqbj/TBKmyHM6j/mgkMQ+olQWPp5Y7HirgCHkcvyJyr8zqp6yxWNBG/gijANmH4r9z64tZbkvOQ1VWzEhjpS1yW63Pn1wRpMphoihEZcfiLDr5i+NXkkEcmR1EMsepDM17bWuowWpx+niJELELYboreI1080i/Qjbof5tjU5xSyz0uX1Mc9hSIkgANyCAtv2wF41pJKOWdHbUvY+Y8/ftg5TSLFH8sQzNJEqhFT6yFU2G2/c/fCVyVi4hbbymGeBYpJuPlzAaWhmjmKsB59B9gfthujphQ/DZieJKTwsF5c6gk+Rva3pc4bw6YZjNiJ1Pvn3ExMTDJPJhI/G52XimlC7aqAA+o1sf8sO7CP+OYvxNSkC7fJL/jfHToO4JzyaWsNNUuTpgFrE9FFv12xrsqnmq8vqqplTmPUO52NraVvt16YV/DuaQZVXzzVUDSLJSvB4bEoSVOoX6/ThjcEVU9ZwzVVbMAEq5AFYDZLLte1++EalR6dx+myE5KMyfHMjSTkMoAUkWX6dhc/f/PGczPNaianWBnYWUIBsQY7bqfYi49zjS8XvoeZVUgE3Knt/JOOtHwZluaZVSVZlminkiUuytcH1semC0zqmPmFqMDZX+mU/hmtOk9ZPLJGszroiQmzOBu1vPfTe2DcrU9RW1OTBgJIwaqhVD4b2vInTsd9vM+WLVdlNPS8NtQQ0fPpohc6hcpe/j8wfUdMYOSSolq4uQ8slXG4NPIP+Ijdt+jb/ANrf1w119ZSYpmOEjHNNwbQVEOcZhPGT8o0fQG4Zibja/UWO/r641TQyX2jU3HngPT5tzMwkrYl8EUSiviEBjkiB2LFT1AIvcbb40CuksayQusiOLqym4IwxXsVfUqwilqVflJHUBiAo6DsMduF5mkyzMVkjP8OsZQCOo7H9sSuDyUU8atoLxsFbuDbtjnwnKXo65yzFhOupvN9Nj9z++J9Wx2VGUAwmP4/d50ZtyAulX7Nfvt2xK3iXLMrWNER6ioGlrBgqRto02v7dse+O2hNS0a3SwGw6b9fb/fGQpI3E80jRc6Iku0Rl0A3ZgPtthWBbxxOZiH4jF+FXEhzbjCGmWjSKMU0jakv6bdPfDrHTCZ+GFNHHxlE6VHNtTyLZVKoDYbKLdB533w5xh61XEmcknmTExMTBQJMI/wCOJI4qo7G16Fb/AP3bDwwkPjgXXiqiZGIPyI6f9b46YZgKSlqK6pEVOmuViXJ7AD+Rhp8E0ktDwpLBVxhpfm2blo3XZSN/yGMhkXFAybKYQsUctVJVMZtICMI9K2Ow63/bDJonapy+W+pHdxc20kiw9iL/ALYVqeMUPTEnJF5xtEvOZNQMhJeTSLbjoPYbff1278M59HTwQUlU2mJKdQCfMdf0P6YH8UuqbpYXX99x/Prj3l2QU9dw7BXCtmjmVW1xiMPcBiNtxvYeeAwY96VKMuc4XDCbeqjWenkjXxhbq4Ru+x6f2um/lgVleX01PXJ8xSqtXFqNPUEC8yHvtsSAftbAbL5a+CJqjKsyWvRpVlljaHlOLWB/E3UADB7LswoauaSQx8ioiYrZwVNmJA/M4L6sSkHqMx5MeZww7/vCpepjDGnSnk1rokScGzL5Ajp19sAMtgzfI4nBpo6yjLFuVG1p4/a/hb229zfByMRtpkW4Fux6jEjmEjnl7jpe5/bCkejYlzY1JvzB1bXLXZZ8zlVQvOp5Q5DoQybEFXU7gkHv546cKSH+j80MSqwarVgP+pQcSqqqT5eScFNTMYGYL4iVa1vysceeB2eWizVNwFlALdb/AMMG/wCuOztuQmTsPqEyvGjNNUyyMxLEi9j3F72xlaWnkcO7AkpIxVg1rAsbg/njWcXMGOpdZZbG7Dtbp0F97/bGeoa4QM9OwbSkrll5WpWfUdLXAJ2HbDMF7OJJmrfzNv8ACqmWPjmGQSSG9NKBqJIbpuDh5DCU+FU083FlMZICqLTygSFl1OTY3IF/1O3lh1DDV6iX7n3ExMTBQJMJX41xl+KKQjtRL/jbDqwpvi1LBHxBTc76jSray3P1NjVFmYepgMhoopKkSyRkmCRJS8jlYkUMCSbC9/IdD0wyMtppcyyxa2nrZIEmkktDNArC6uVv1B7eeMIzwsmhUbR3C9z5k/zbGjyziOiynIYIaqmqAgMhV00lbatxueu+F5CGG2PwYMqncRUF8QZYINTyOJQOwp7Aj0/iXxQyqvWOgkhjiYpzDZT4Qo626k9b/c475pxHTZimqnEhjcjcoB0H6b3xTyaSmppJYqtjadtUYA2uL3H6j7YZjGwXAzoznie5TE7rPF/VnVbFIiQbjy8x7nzxWkerZ0d5n1Dcb7jBeGryqaV41SQFfNdm9RbHbXQWvyX0Dv2xzP4Iik02c8qJUyrOKmjOlrslgoW3QDGkp87ppYibFG3uMZ753KRMEET2I+s/T++Onz2VxghqWY39QP8APAthQ1YlGHNqaIXkCUOSVmEULFtTayXI6nck/rvja5DlbJw9FLHVaHm16wsJuxDEdbqTsO++Msmd5dE9oqKWMNsJgw69t+uDCcWxZRkkUTUXOhZntKkoXqxNrWxubDQAm4XLkt9oOzqgTZpJecCL+KOy+dz48ZFK5qPMasJzAZGjLcmJWBUgahv0vbqMGsw4qTM5i3yskQ3HicH9sUlalkqnLRkTFQW8W5GkDBeiUTkQPUGXJSmab4U5ilXx1DEiKoWmlIHQrYKLdL2w8x0wkvhdTwJxrBMi2kNNKL+lhh2jpgSu3iqgsbPc+4mJiY6DJhK/GgkcV0Fhe9GB7eNsOrCW+MymTiuhQbXoxv8A/J8OwGnuLyKWWhMflQNdXQU2vl/MyMsZK6tNgTvv5DHSqZK7JQJtRjTUy7eJbHr9hj7l4/o9hLBbmoGAkPYkWvbzsTj4ymLLYgw/hoCFZQPM7N5j3x2N0bMSPMt1WHVY9MoY2IPzHJ58nrJo3qI+XEVOuQFBMSqsRGNy2kML+X5jE0LmVXllLFKUNROIhJouFZiADbbbfF+tqKvMoCa8RvIWVrm6kaRpHQ26dreWKlQZoWgraRI4qmKRXVRGoUMvQgdL7A+uMDGyCeYkYcvo3XBnaKFw1IkEgeWaqNPGunQ+pSBcAk+EllIN/MbWxc+Xqa2s/o+KrHzTuY42eMiOVx+HVe63tsSu/pgUtfU5hTQCqjgtCxaKdbrKlzfTcH6b3NrbEkjBOPNZ59bPKOcwN540VXa4sTqAve3frgMmTIavsRukwvsYA0DOdBRQ1MUNbJVGCkeRo6ptFvlnXSbnfe4YW6X332x0nyyqjkgppJCjNO0RhZLkAPoDdd1JuR6C/lilTo96ilke9I7I5ib6ZGW4BPtc/pgi1VUPUpM8jySpp0uxB+kAL9rDHZcuQN3cPRaGwSeOx3KKZchkzSJakhKSOSVhouTocKQN/M7YLw5ZLVcNLKr8xl1saVl3Cg7svW9r7+mKT1si1skgWMNLEYpwsa+ME6j289zbBqlqXXKoTBLokiZmR0AuDfG5M+ooFYGD+HodwZrI4mTlyloHqZJJohT0yxO7pdrcwXRRcC5O/tY+gx5qqeJKtJQ7NqiU+OPQVO4O1zvsMEq7M5Xqp50Ea85QssaxDlygdFZTtYWFvI9McK1/m5FqEfdkAZbX022wbNl2Bm8xWnw4lylAbIml+EpI4zhTdl5EpU9hsMPQdMIj4Sy6uPIYwVOmmmuQPbD3HTAOzMbaY6IjEJ1PuJiYmAgz/9k="><span>On his 11th birthday, <b>Harry</b> receives a letter inviting him to study magic at the Hogwarts School of Witchcraft and Wizardry. <b>Harry</b> discovers that not only is he a wizard, but he is a famous one. He meets two best friends, Ron Weasley and Hermione Granger, and makes his first enemy, Draco Malfoy.</span>' ]
    ],
    columns: [
        { type:'text', width:200, title:'Title' },
        { type:'html', width:400, title:'HTML' },
     ],
     minDimensions:[2,2],
}

jspreadsheet(document.getElementById('spreadsheet'), options);
</script>
</html>