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 Automatically Save and Close an Excel File after a Certain Idle Time?
When we save the Excel workbook in shared memory, if one person accesses the sheet, other people will be unable to save the sheet; this problem can be solved by automatically closing the sheet after a certain amount of time. This tutorial will help you understand how we can automatically save and close an Excel file after a certain idle time. Automatically Save and Close an Excel File after a Certain Idle Time Here we will first insert VBA code for the sheet, then create a VBA module, then run it to complete our task. Let us see a straightforward ...
Read MoreHow to Automatically Run a Macro When a Cell Formula Result Changes in Excel?
We need to run a macro by going to the Developer menu and selecting Run Macro or by using the shortcut we created. But have you ever tried to run a macro based on a cell value? It can be done by using the VBA application. In this process, we will automatically run the macro when the value of the specified range has changed. This tutorial will help you understand how we can automatically run macros when the result of a cell formula changes. Here, we will first select the range of cells and then insert the VBA code for ...
Read MoreHow to Automatically Resize the Textbox to Fit the Contents in Excel?
When we use the text boxes in Excel, you may have observed that manually resizing the text boxes to fit the content is one of the most time-consuming processes, as adjusting them could be a slower process. This can waste a significant amount of time when doing the Excel work. This tutorial will help you understand how we can automatically resize the text box to fit the content in Excel. We can do it with the help of a VBA application, as it cannot be done by default in Excel. Automatically Resize a Textbox to Fit the Content in Excel ...
Read MoreHow to Automatically Reapply Auto-Filter When the Data Changes in Excel?
In Excel, a filter is used to group data based on a command value in any column. We can apply a filter to a table using the slicer. When we change the data in the filtered column, we can see that it will not apply to filtering. We need to close the filter and reapply it to update the data. This might create confusion when we are frequently changing the data in the filtered data. This tutorial will help you understand how we can automatically reapply the auto filter when data changes in Excel. Here we will first insert a ...
Read MoreHow to find all leaders in an array in Java?
In Java, Array is an object. It is a non-primitive data type which stores values of similar data type. As per the problem statement we have to find leaders in an array. An element is a leader if it is greater than all the elements to its right side. Let’s start! To Show You Some Instances Instance-1 Suppose the original array is {16, 17, 4, 3, 11, 14, 23, 2, 6, 10}. After finding leaders in an array the result will be − 23 10 Instance-2 Suppose the original array is {16, 17, 4, 3, 5, 6, 9, 1, ...
Read MoreCompare Two Different Files Line by Line in Java
In this article, we will compare two different text files which are saved in our system. We will check line by line of each text file, by comparing those we can identify the similarities and differences. Let’s see how we can do it by using the Java programming language. To Show You Some Instances Instance-1 Below figure depict two different text files with same content and hence output will be two files with same content. Instance-2 Below represents two files, say file1.txt and file2.txt with their content. file1.txt This is amazing. Java Language. file2.txt This is amazing. Python ...
Read MoreHow to Automatically Move the Cursor to a Specific Cell in Excel?
When we are dealing with large amounts of data moving around, accessing the data is one of the most often applied functions in Excel. Finding the data set could be a problem because the large dataset can consume a lot of time. Even when we know the address of the cell, it will take a lot of work to find it. We solve this problem by automatically moving the cursor to a specific cell. This tutorial will help you understand how we can automatically move the cursor to a specific cell in Excel. This process can be done in two ...
Read MoreFind First and Last Word of a File Containing String in Java
As per the problem statement, we need to find the first and last word of the given String. Let’s explore the article to see how it can be done by using Java programming language. To Show You Some Instances Instance-1 Suppose there is String “Java is a well-known high-level, class-based object-oriented programming language that Sun Microsystems created and first distributed in 1995. Over 3 billion devices run Java, which is currently owned by Oracle” After printing the first and last word of this String i.e “Java” and “Oracle”. Instance-2 Suppose there is String “For the creation of their desktop, web, ...
Read MoreSeparate Odd and Even Elements into Two Separate Arrays in Java
In Java, Array is an object. It is a non-primitive data type which stores values of similar data type. As per the problem statement we have to separate odd and even elements into two separate arrays and print the result. A number is said to be an even number if it is divisible by 2, else the number is an odd number. Note − The array must be an integer array. In this article, you will see how to separate even and odd numbers of an array into two different arrays by using Java programming language. Let’s start. To Show ...
Read MoreRead All the Emails Present in a File in Java
As per the problem statement we need to find all the Emails present in the file. Let’s explore the article to see how it can be done by using Java programming language. To Show You Some Instances Instance-1 Suppose there is given paragraph and it contains many different email ids and we want to extract all the mail id present in that paragraph. For e.g. − “I am a boy with email boy54@gmail.com. My friend’s email is friend78@gmail.com.”.” From the above paragraph, we need to take out the given two mail id in the paragraph i.e., boy54@gmail.com and friend78@gmail.com. Instance-2 ...
Read More