Category: JavaScript

To parse Excel (XLS) file in JavaScript, we use the read-excel-file package.

To install it, we run

npm i read-excel-file

Then we add an input with

<input type="file" id="input" />

Then we write

import readXlsxFile from "read-excel-file";

const input = document.getElementById("input");

input.addEventListener("change", async () => {
  const data = await readXlsxFile(input.files[0]);
});

to select the input with querySelector.

And then we add a change event listener with addEventListener.

We call readXlsxFile with the selected file to get a promise with the read Excel data as nested array.

To send a JSON object using HTML form data with JavaScript, we use fetch.

For instance, we write

const ajax = async (config) => {
  const request = await fetch(config.url, {
    method: config.method,
    headers: {
      Accept: "application/json",
      "Content-Type": "application/json",
    },
    body: JSON.stringify(config.payload),
  });
  response = await request.json();
  console.log("response", response);
  return response;
};

to call fetch with the URL to make the request to and an object with the headers and body.

We set body to the stringifed JSON object we get with JSON.stringify to send that as the JSON body.

We set the headers to the request headers keys and values.

Then we get the JSON response in a promise with request.json.

To detect "shift+enter" and generate a new line in text area with JavaScript, we check the keys pressed in the keyup event handler.

For instance, we write

if (event.keyCode === 13 && event.shiftKey) {
  console.log("Shift+Enter key Pressed");
}

to check if enter is pressed by checking if keyCode is 13.

And we check if shift key is pressed with shiftKey.

If both are true, then shift+enter is pressed.

To get and set the current web page scroll position with JavaScript, we set the scrollTop property.

For instance, we write

document.documentElement.scrollTop = document.body.scrollTop = 1000;

to set the scrollTop property of the body element to 1000 to scroll 1000px down.