We have is to open excel programmatically and add VBA code to the workbook using C# as we can't use OpenXML or ClosedXML libraries.

How to add VBA code in Excel using C#

Use the NumberFormat property of Cell/Range, instead of the DataType property to change the format which is Excel. If you’re curious about NumberFormat and DataType, why those two solve different purposes in Excel, please browse through this post, where I’ll be experimenting and explaining in more detail

Setting datatype for a cell - ClosedXML/OpenXML

Everything about React and its libraries that one must know before going to interview.

ReactJS Interview Questions

Everything about Docker and Kubernetes that one must know before going to interview.

Docker & Kubernetes Interview Questions

Everything about Design Patterns that one must know before going to a Java interview.

Design Patterns Interview Questions For Java

Everything about Maven and Ant that one must know before going to a Java interview.

Interview Questions for Maven & Ant (Java)

Everything about Gradle that one must know before going to a Java interview.

Gradle Interview Questions

Everything about Hibernate ORM that one must know before going to a Java interview.

Hibernate Interview Questions

Basics about Spring Boot that one must know before going to a Java interview.

Spring Boot Interview Questions

Everything about Java Collections that one must know before going to a Java interview.

Java Collections Interview Questions

Generate Password in Linux Shell

How to create SSH Key for Git?

Authenticate Users in Nginx using htpasswd basic authentication

Java Interview Preparation - Deadlocks

Java Interview Preparation - Kafka

Java Interview Preparation - Microservices

Java Interview Preparation - Spring Boot

Java Interview Preparation - Streams

URL Encode a String in Linux Shell

Create Virtual Machine with Vagrant

VSCode Dev Container - Configurations

This guide provides step-by-step instructions on how to connect to a virtual machine using the Remote - SSH extension in Visual Studio Code. For demonstration purposes, an AWS Instance is used as an example in this article.

SSH configuration with Visual Studio Code

Terraform is an infrastructure as code tool that lets you build, change, and version infrastructure safely and efficiently. This includes low-level components like compute instances, storage, and networking; and high-level components like DNS entries and SaaS features.

Install Terraform for Windows and configure it for AWS

Master/slave is a model for a communication in which one device or process (known as the master) controls one or more devices or processes (known as slaves). Control always flows from the master to the slave(s) once the master/slave relationship is established.  Jenkins Master: Schedule the jobs, assign slaves, and send build commands to slaves to execute the jobs. It will also monitor the slave state (offline or online) and get back the build result responses and the display build results on the console output. Jenkins Slave is a java executable which receives the build instructions from the central master node. There is no need to install Jenkins on the slave node. It is sufficient to have a JRE (Java Runtime Environment) installed on the slave node.

Jenkins Master Slave Configuration

How to create a Spring Boot application with Spring Initializr and run it using maven. We will expose a simple endpoint that returns "Hello World".

Create a Spring Boot Application with Spring Initializr

Jenkins is an open-source automation server.  It helps automate the parts of software development related to building, testing, and deploying, facilitating continuous integration, and continuous delivery. Jenkins is an open-source continuous integration/continuous delivery and deployment (CI/CD) automation software DevOps tool written in the Java programming language. It is used to implement CI/CD workflows, called pipelines. We can install Jenkins through native system packages, Docker, or even run standalone by any machine with a Java Runtime Environment (JRE) installed.

How to install Jenkins in Linux

In this post will explain how you can install Java JDK 17 & Maven to your Ubuntu machine.

How to install Java OpenJDK 17 & Maven to Ubuntu

To create a executable JAR file you'll need to specify a Main class. We have two different maven plugins for the same. One is provided by Spring and the other is standard plugin provided by Apache

Create Executable Jar File

In this post I'll try to briefly explain how you can start your java development carrier. The environment used would be MacOS but anyhow the content should make sense for any development environment

Hello Java! with MacOS

This post explains how to delete old remote tracking branches and tags locally which are deleted from remote repository

Deleting old branches & tags from local Git repository which are not present in remote

This blog post will give you an in-depth look into the process for setting up and upgrading Azure CLI.

Installing & Managing Azure CLI

This post will introduce you to Homebrew, the missing package manager for MacOS. If you want to install any open-source package not present in the App Store, you can do so with this tool. Here I'll explain how you can install Homebrew and the basic commands you need to run for searching, installing, uninstalling, and maintaining your packages/libraries.

Introducing Homebrew, the missing package manager for MacOS

Stop your virtual machine if there are no active SSH connections. This would be useful if you want to save costs for VM which are inactive. This is only useful for very less use cases when the user knows how to start the VM whenever he starts development and can wait few minutes for boot up of machine but makes sense for users who get billed for VMs which are not in use. Most of the cloud providers don't provide any easy way to do this. This way you can save about 60% of your cloud provider bill.

Stop Virtual Machine If no active SSH connections

This post will explain how you can set up your self-hosted agent for your Azure Pipelines. This post will be specific to how you can set up your cloud VM running on Ubuntu to act as a pipeline agent for your projects, but it can still be useful for other Linux flavors

Setting up self hosted agent i.e. configuring cloud VM for Azure Devops Pipelines

This blog post will explain how you can configure your Azure functions to use Tables for storing JSON objects with NodeJS

Using Table Storage with Azure Functions with NodeJS

This blog explains how you can create an spring-boot command-line java application that is compatible with Windows/Linux/Mac.

Create an spring-boot command-line java application compatible with Windows/Linux/Mac

This post will explain you how you can use Spring Boot DevTools on IntelliJ as it won't work automatically

Spring Boot DevTools on IntelliJ

This blog will explain how you can achieve full-screen zoom whenever the user clicks on an image. Full zoom effect can be achieved by pure react and HTML CSS; no special libraries are needed; you'll have complete control on how to configure zoom for your images in your blog or website, etc.

Zoom Image to full screen Using React

This blog will provide a basic introduction of terraform for managing Azure resources.

Managing Azure Resources with Terraform

This blog explains adding an apex domain to Azure Static Web App in detail.

Add Apex domain to Azure Static Web App

This blog post will discuss and solve the most commonly occurring issues with unit testing your Spring Boot Application.

Common Issues Encountered while unit testing Spring Boot

Any long running project will have numerous opensource dependencies. Adding these dependencies is made very easy with Nuget packages, etc. This article will give you a gist of details on how you can go about managing your dependencies for project.

How to manage dependencies for your .Net Projects?

This post explains all the core concepts you’ll need to learn about Azure Functions &amp; the possible questions that can come on this topic.

Azure Functions Interview Questions

This post explains all the core concepts you’ll need to learn about Azure Cosmos DB &amp; the possible questions that can come on this topic.

Azure Cosmos DB Interview Questions

This post explains all the core concepts you’ll need to learn about Azure Queue Storage &amp; the possible questions that can come on this topic.

Azure Queue Storage Interview Questions

This post explains all the core concepts you’ll need to learn about Azure Table Storage &amp; the possible questions that can come on this topic.

Azure Table Storage Interview Questions

This post explains all the core concepts you'll need to learn about Azure Blob Storage &amp; the possible questions that can come on this topic.

Azure Blob Storage Interview Questions

All important questions and answers related to Azure Cloud Shell.

Azure Cloud Shell FAQ

Everything about JUnit &amp; Mockito that one must know before going to an interview will help you answer questions.

JUnit & Mockito Interview Questions

Everything about Apache Kafka and ZooKeeper that one must know before going to an interview will help you answer questions.

Apache Kafka & ZooKeeper Interview Questions

Collection of all basic Java questions that one must know before going to a Java interview.

Java Interview Questions

Environment variables store information about the operating system environment. This information includes details such as the operating system path, the number of processors used by the operating system, and temporary folders' location. These variables are globally accessible, and programs can query the value of the variable.

How to configure environment variables in Windows

Java is a general-purpose, class-based, object-oriented programming language. It is fast, secure, and reliable and is platform-agnostic, so it is widely used for developing applications in laptops, data centers, game consoles, scientific supercomputers, cell phones, etc.

Brief Introduction to Java

SSL is a protocol for web browsers for authentication, encryption, and decryption of the data sent over the internet.

Basics of SSL (Secure Sockets Layer)

When you click an email on a website to reply to it, you expect your Gmail to open, but it doesn't. This is the default behavior of chrome. This post will tell your everything about configuring Gmail as your default email application on your Google Chrome browser.

Set Gmail as a default mail app for Google Chrome

There are three types of Excel Macro buttons which I've described in the previous post on how to create them manually in Excel, along with their advantages and disadvantages. In this post, I'm going to explain to you how to create them using VBA. Creating buttons with VBA will save you more time if you create many sheets with buttons. Also, I will explain the common styling functions which you can use to make the buttons look good in your project.

Create different types of Excel Macro buttons using VBA

There are three different types of Excel Macro Buttons 1. Shapes 2. Form Controls 3. ActiveX Controls

Overview of different types of Excel Macro Buttons

This post will explain to you how to install Git on a Windows 10 machine and go through all the configuration options available while installing it. This will be helpful even if you’re on Mac/Linux, etc.

Guide to install Git

Git is a version control system, which tracks the changes you make to files, so it keeps a record of what you've done, and helps you to revert to specific version should you ever need it. It also makes collaboration easier, allowing multiple people to work on a single file/folder, without the need to worry about overwriting someone's work.

What is Git Source Control System?

WordPress is a CMS (Content Management System) which is the simplest, popular way to create your blog, business, website, etc. And has become the most popular CMS for everyone looking to build a website and is designed for everyone, emphasizing accessibility, performance, security, and ease of use.

What is WordPress?

A content management system, often abbreviated as CMS, it's a software that helps users create, manage, and modify, i.e. work with content.

All Posts Posts