Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to Count Number of Occurrence in a Column in Google Sheet?
In data analysis and spreadsheet management, keeping track of the frequency of specific values in a column is a typical activity. When it comes to effectively counting occurrences, Google Sheets offers robust features that can be used with both enormous datasets and straightforward lists. In this article, we'll show you step-by-step how to count the occurrences of a particular value in a column using Google Sheets functions and formulas. From simple counting to more complex filtering and criteria-based counting, you'll master a variety of methods that can be used in a variety of situations. This information will enable you to ...
Read MoreStructural typing in Typescript
TypeScript, a superset of JavaScript, introduces static typing to JavaScript, allowing developers to catch potential errors and enhance code quality. One of the key features that set TypeScript apart is its support for structural typing. While other statically typed languages often rely on nominal typing, TypeScript embraces the concept of structural typing, which provides a more flexible and intuitive approach to type checking. In this tutorial, we will explore the concept of structural typing in TypeScript and its benefits and provide relevant examples to illustrate its usage. Understanding Structural Typing Structural typing is a type system that focuses on the ...
Read MorePrivate, Public & Protected Access Modifiers in TypeScript
Access modifiers are essential because they allow us to enforce encapsulation and define the boundaries of class member accessibility. With access modifiers, we can restrict access to certain members, ensuring they are only accessible within the class itself. We can also make members public, allowing them to be accessed from anywhere in our codebase. Furthermore, protected members enable access within the class and its derived classes. In this tutorial, we will explore the private, public, and protected access modifiers in TypeScript. Syntax Users can follow the syntax below to apply access modifiers to class members in TypeScript − class ClassName ...
Read MoreIs it possible to generate TypeScript declaration files from JS library?
If you have ever worked with JavaScript libraries in your TypeScript projects, you may have encountered situations where you needed type information for those libraries. TypeScript declaration files, denoted with the .d.ts extension, provide type information for JavaScript code, enabling better static type checking and editor support in TypeScript projects. In this tutorial, we will explore different scenarios and methods for generating TypeScript declaration files from JavaScript libraries. We'll cover scenarios such as generating declaration files for existing JavaScript libraries, generating declaration files for your own JavaScript code, and leveraging tools like dts-gen and tsc to generate declaration files automatically. ...
Read MoreHow to use Record type in typescript?
In TypeScript, the Record type is a powerful tool that allows you to define an object type with specific keys and corresponding value types. This tutorial will guide you through the fundamentals of using the Record type, providing syntax explanations and practical examples along the way. Whether you're a beginner or already familiar with TypeScript, this tutorial will help you understand how to leverage the Record type effectively in your projects. Syntax The syntax to create a Record type in TypeScript is straightforward. The type definition starts with the keyword Record, followed by angle brackets () containing the key and ...
Read MoreHow to Get Window History in TypeScript?
The user’s history of visited web pages is represented via the window.history object. A history of the pages that have been loaded is stored in an array called the history object. The history object only provides a finite amount of information. The history object only has a few properties and methods since it is impossible to know where the current URL is located within the history object. The previous URL in the history list is loaded using the history.back() method. The second method of history is the forward() method, which loads the following URL in the history list. It is ...
Read MoreHow to Fix Absolute Imports in TypeScript?
Introduction When working on TypeScript projects, organizing and managing module dependencies is essential for maintaining a clean and scalable codebase. Absolute imports offer a convenient way to reference modules using a fixed path relative to the project's root directory. However, configuring and fixing absolute imports can sometimes be challenging, especially for beginners. In this tutorial, we will explore various scenarios where absolute imports may encounter issues and discuss practical solutions to resolve them. By the end, you'll understand how to fix absolute import problems in TypeScript effectively. Scenario 1: Missing TypeScript Configuration Before utilizing absolute imports, we must ensure that ...
Read MoreHow to insert radio buttons or option buttons in excel?
Microsoft Excel can be used for inputting as well as getting data, but it additionally can construct flexible forms. These flexible forms assist users in several ways whether users take a poll, design a survey, or create a test to learn about other people's perspectives. A flexible form radio button is often known as an essential component. These flexible forms assist users in several ways, whether they take a poll, design a survey, or create a test to learn about other people's perspectives. A flexible form's radio button, often known as the options option, is an essential component. Example 1: ...
Read MoreHow to draw Regular Polygon in TypeScript?
Regular polygons, such as squares, triangles, and hexagons, are fundamental shapes used in various applications and graphics. Drawing regular polygons programmatically can be useful in TypeScript, allowing you to create geometric shapes dynamically. In this tutorial, we will explore how to draw regular polygons in TypeScript by leveraging basic mathematical principles and the HTML5 canvas element. Syntax function drawRegularPolygon(ctx: CanvasRenderingContext2D, n: number, x: number, y: number, r: number): void { const angle = (Math.PI * 2) / n; ctx.beginPath(); ctx.moveTo(x + r, y); for (let i = 1; i
Read MoreHow to insert picture into text box?
The steps for placing an image in an Excel text box are covered in this article. The objective of this article is that the text box allows the user to in line with the text put an image. In this manner, the image will function as a (big) text letter. Although the text box in the screenshot has a boundary, the user can obviously eliminate the surrounding area if the user like. For example, If the user wants data where they can see the employee name as well as their photo in Excel so with the help of inserting the ...
Read More