Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Sometimes, in Excel the user wants to extract data for the provided task, the extraction will be from right to left. For example, if a cell contains data “Ana Ban” then the extracted string will be “Ban”. To demonstrate the formula used to accomplish this task will provide a simple example. All explanations are guided in a detailed stepwise manner. The first example guides the process of using the formula to perform the same task. Example 1: To pull or extract characters from right to left in a cell until a space is reached in excel by using the ... Read More
Protecting the workbook structure in Excel. It is an essential task that helps in accessing safeguarding the integrity of the user spreadsheet and prevents unauthorized modifications to the layout and organization. By implementing workbook structure protection, users can maintain the integrity of formulas, data validation settings, and other structural elements within their Excel workbook. This protection feature is particularly useful whenever the user needs to share a workbook with others or collaborate on a project while ensuring that the underlying structure remains intact. In this guide, we will explore the steps required to protect the workbook structure in Excel, ... Read More
The bounding rectangle of an object is a rectangle drawn around an object in the image. There are two methods to find the bounding rectangle in OpenCV − Straight Bounding Rectangle It is a straight rectangle as it does not consider the rotation of an object. It can be computed using the function cv2.boundingRect(). Its syntax is as follows − x, y, w, h = cv2.boundingRect(cnt) img = cv2.rectangle(img, (x, y), (x+w, y+h), (0, 255, 0), 2) Here, "cnt" is an array of the contour points. It returns the top-left coordinate (x, y) and width and height (w, h) ... Read More
In this article, the main objective is to guide the user through the process by using which printing X rows per page become easy for the user. This article describes two examples of how to perform the same task. The first example includes using the page break manually. The second example is based on the use of kutools. If will talk about the easiest guided example, is the second example that uses the kutools, as the number of steps performed to achieve the task is too less when compared with others. Example 1: To print X rows per page ... Read More
Printing worksheets without fill color in Excel ensures that the printed copies are clear and legible, without the distraction of background colors. Whether users have applied fill colors to cells or used conditional formatting, removing the fill color before printing can enhance the readability of the printed document. By following a few simple steps, the user can ensure that the available worksheets are printed without any background colors, allowing the data and content to take center stage. This helps maintain a professional and organized appearance when sharing or presenting your Excel worksheets in hard copy format. This explanation will allow ... Read More
Worksheets without any blank rows mean an Excel sheet that does not contains any blank row. But while mapping any data to reality the same thing is not possible. So, it is better to remove the blank rows from Excel before printing the worksheets. The same task can be done in two ways, first method is to remove the blank rows, from the Excel sheet by using the VBA code, while the second method describes the process of using kutools to perform the same task. This article provides two general examples, to demonstrate the process of achieving the same task, ... Read More
In Microsoft Excel, a formula can be defined as an expression that performs calculations, manipulates data, or returns a specific value based on the inputs provided. Formulas in Excel typically start with an equal sign (=) and can contain a combination of numbers, operators, functions, cell references, and constants. To understand more precisely consider the below given Excel formula elements: Numbers: these values can be directly written in a formula. An example includes any number such as 5, 1. 5, -3, etc. Operators: these can be defined as the mathematical symbols used to perform calculations. Examples include addition (+), ... Read More
In this article, the user will learn the process of locking and protecting some selected cells in Excel. Locking and protecting nonempty cells in a selected range with the "Protect Sheet" feature in spreadsheet applications like Excel or Google Sheets provides an additional layer of security to prevent accidental or unauthorized modifications to important data. By using the "Protect Sheet" feature and locking selected cells, the user can add an extra level of control and safeguard to the user spreadsheet, promoting data integrity, collaboration, and data security. In this article, two examples are provided. The first example, allow the ... Read More
One of the most popular ways to manage and distribute Python packages is through the Anaconda distribution, which is a free and open-source distribution of Python. Installing Python packages in Anaconda is a simple process that can be done through various methods, such as using the conda command, pip, or the Anaconda Navigator. In this guide, we will explore the different methods for installing Python packages in Anaconda and explain how to use each one. Whether you are a beginner or an experienced Python developer, this guide will provide you with the knowledge you need to effectively manage and distribute ... Read More
OpenCV provides us the function cv.rotate() to rotate an image (NumPy array) in multiples of 90 degrees. This function rotates an image in three possible ways: 90, 180, and 270 degrees clockwise. We use the following syntax − Syntax cv2.rotate(img, rotateCode) rotateCode is a rotate flag specifying how to rotate the array. The three rotate flags are as below − cv2.ROTATE_90_CLOCKWISE cv2.ROTATE_180 cv2.ROTATE_90_COUNTERCLOCKWISE Steps To rotate an input image, you could follow the steps given below − Import the required libraries OpenCV and matplotlib. Make sure you have already installed them. Read the input image using ... Read More