Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In this tutorial, we will learn How to send FormData objects with Ajax requests in jQuery. The FormData object stores value in the form of key-value pair. It mainly sends form data to the server with HTTP requests. If the form’s encoding type had been set to multipart/form-data, the submitted data would have been sent similarly via the submit() function. The FormData object contains multiple operations methods such as append, delete, set, etc. Syntax const formData = new FormData() formData.append('key', 'value') Users can follow the above syntax to create a FormData object. Asynchronous JavaScript And XML are referred to ... Read More
When you collect data from another source and use that in an Excel sheet, it may not look good. The space provided between numbers in an Excel cell is very less and it will not be very clear. There is a need for increasing the space between the numbers in the cell to represent the numbers neatly. You can use Formulas in Excel to add more space between numbers. In this tutorial, we will take an example to show how you can use a simple formula to add space between numbers in cells and make them more presentable. Adding Spaces ... Read More
Applying subscript and superscript are not default functions in Excel, however you can customize the Excel ribbon or the quick access toolbar to show these functions. In this article, we will take a simple example to demonstrate how you can customize the Excel ribbon. Adding Subscript and Superscript Functions to the Excel Ribbon The Excel ribbon is the place that includes some of the frequently used functions such as Conditional Formatting, Cell Styles, Autosum, etc. Step 1 To display the subscript and superscript functions on this ribbon, right-click on the ribbon and select "Customize the Ribbon", as shown in the ... Read More
We use commas to separate items of the same category in a list. If the words are not separated clearly by commas and spaces, then it looks ugly and impossible to understand. You might have come across situations where you borrowed some data from the Internet and used it in an Excel sheet, only to realize that the data missing spaces and commas. You can, of course, insert commas manually, but it will be a time-consuming affair. In this tutorial, we will show you a simple way to insert spaces after commas in an Excel sheet. Adding Spaces after Commas ... Read More
A series line in Excel helps us to connect the data objects of same time period. A series line helps us to analyse the charts more efficiently without any confusion. A series line connects the data objects of same rows with a line. Generally, series lines are added to the stacked or 100 stacked columns. In this tutorial, we will demonstrate how you can add series lines in a chart in Excel. Adding Series Line in an Excel Chart Let us suppose we have an Excel sheet with the following data: Step 1 To create the chart, select the ... Read More
If you have a huge Excel sheet with lots of data and there is a requirement to add a semicolon to each cell, then you wouldn't surely do it manually. In this tutorial, we will show you a simple hack that you can use for this purpose. Adding Semicolon to Each Cell Using "&" Operator Let's start with the first method. You can add a semicolon to each cell using the "&" operator. Step 1 Let us consider we have the following Excel sheet that contains a list of numbers and names. We will be using the concept of adding ... Read More
A pivot cart can help us understand the data in a very efficient manner. In this tutorial, we will show how you can add a secondary axis to a pivot chart in Excel to help depict and comprehend complex data in a simple way. Adding Secondary Axis to a Pivot Chart in Excel Let us assume we have an Excel sheet which contains data similar to the one shown below: Step 1 We need to create a table for the data. To create the table, select the data → click Insert → click table. It will convert our data ... Read More
In this tutorial, we will learn how to catch syntax errors in JavaScript. In JavaScript, we get will errors if we write any mistakes in code. Like, ReferenceError, i.e., when we call a variable that does not exist in our code. TypeError i.e. when we tried to change the value which is immutable or try to use a variable in an appropriate way. SyntaxError i.e. when we tried to interpret invalid code. We will learn more about this error in detail below. What is Syntax Error? A syntax error is thrown when there is a glitch in ... Read More
In this tutorial, we will learn to find the non-digit character with JavaScript regular expression. ASCII code 'A' is 65 and 'a' is 97 etc. Now, we will check how to find a nondigit element (\D) in a given text using RegExp. RegExp is an object that specifies the pattern used to do search and replace operations on string or for input validation. RegExp was introduced in ES1 and it is fully supported by all browsers. Syntax Syntax for the non-digit element is, new RegExp("\D") or simply /\D/ /\D/, is introduced in ES1. It is fully supported by ... Read More
In our code, usually, we will get an issue with errors. Errors will disturb the normal flow of our application. So, it is required to handle error exceptions in our code to implement any application in any programming language. Now, we will see how to handle exceptions in Clojurescript. Before that, first we learn what Clojurescript is. What is ClojureScript? At the fundamental level, Closurescript is an accent of the closure programming language that is used to compile to JavaScript. Actually, closure originally compiled only to Java virtual machine bytecode, later in 2011 Closurescript came as an option to ... Read More