Validate .xlsx and .xls files in a few simple steps
You have an Excel file with many columns and rows, and you need to validate it. How would you do it? The following article will describe a simple way to do it that works fine with both small and big files.
First of all, we need to know which Excel columns we want to validate and what kind of validations to apply. In this example, I will use a file with five rows and five columns, but the method works just as well if it has 30,000 rows and 100 columns.
For simplicity, I will construct it all using only a couple of files: index.html
and script.js
. Obviously, this can be improved by separating the different parts into different classes and files.
Let’s start by creating a file called index.html
that will be the interface of our application. It has a button that, when pressed, will let us select a file.
#nodejs #react #javascript