Skip to main content

Convert Excel to JSON using JavaScript

Updated on: coderszine team

In previous tutorial, we have explained how to Convert CSV Data to JSON using JavaScript. In this tutorial, we will explain how to convert Excel file data into JSON using JavaScript.

The Excel file is popular file type that created with extension such as .xls, xlsx. It is a spreadsheet file that can be created by Excel or other spreadsheet programs. The Excel file type represents an Excel Binary File format.

The Excel files are widely used for storing data. It contain numerical data separated by rows and columns within a cell. Sometimes we need to get data from Excel file and convert into JSON data to use further in web applications.

(more…)

Rendering HTML in React

Updated on: coderszine team

In our previous React tutorial, we have explained how to Create React Select Dropdown List from API. In this tutorial, we will explain How to Render HTML in React.

There might be times when we have HTML content from external sources or WYSIWYG editors or via REST API to render using React. By default, it’s not possible in React due to security reason. It treats all content as string and thus all tags are visible on the page.

(more…)

Setup TinyMCE Editor in React

Updated on: coderszine team

In our previous React tutorial, we have explained how to implement Autocomplete Search in React. In this tutorial, we will explain how to setup TinyMCE Editor in React .

We often need to use WYSIWYG html editor into our React project. The WYSIWYG HTML editors are used in web application that allows to preview the end results and source of content before saving or printing final content.

TinyMCE is an open-source WYSIWYG html editor to use in web applications. In this tutorial, we will explain how to integrate TinyMCE editor in React application.

We will use react tinymce-react package to use TinyMCE in React application.

(more…)

Build Autocomplete Search in React

Updated on: coderszine team

In our previous React tutorial, we have explained how to create React Select Dropdown List from API. In this tutorial, we will explain how to create React Autosuggest Search using API.

The autosuggest search is a very user friendly feature of web application in which partial text search ebabled to display dropdown list of matching option values to select from.

In this tutorial, we will implement autosuggest search component to allow users to enter partial search text, an api request made to fetch data based on search text and display in dropdown list as suggested items to select fom suggested list.

(more…)

React Select Dropdown List from API

Updated on: coderszine team

In our previous React tutorial, we have explained how to create react select dropdown. In this tutorial, you will learn to create React Select Dropdown List using REST API.

We will use react-select library to create an async select dropdown list by making http client request to API using axios package and loading response data to dropdown list. We will also use useState hooks to set and get selected values.

(more…)