How To Forbid In jExcel Spreadsheet Adding New Columns — Tentamen Software Testing Blog

TL;DR

Let’s say that your web application has an import feature. You would like application users to use an Excel-like application to insert or copy/paste data to import it into your application.

jExcel

One way to do it is with the jExcel javascript library. Here is an example where you create a table using hardcoded values. jExcel is an interactive spreadsheet, which means you can add rows and columns. But in the import data table, you already defined supported columns, and you would like to forbid users to interactively add using TAB new columns. More confusion is created because those columns are automatically named with English alphabet letters, like in Excel (A, B, C, …).

Here is a code snippet where you forbid adding columns with TAB keystroke:

Originally published at https://blog.tentamen.eu on February 21, 2021.

--

--

--

Founder of Tentamen, software testing agency.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Recursion vs Iteration

How to run your db.json file from a deployed heroku application

Ooth integration with Create-React-App and Apollo GraphQL

Adding Tools To Your Technical Toolbox: JavaScript Edition II

10 Javascript questions for the next Interview!

React Concepts To Know For An Interview

Intro to Mocha JS

JavaScript HTMLCollection

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Karlo Smid

Karlo Smid

Founder of Tentamen, software testing agency.

More from Medium

Design cancellable asynchronous callbacks

React, ViteJS, TypeScript, and Jest

React Modal the reusable way (TS)

Adaptive responsive tables using react-table library