Merge/Unmerge Cells In this example I am going to show you how to merge and unmerge cells in excel sheet using Python script. You can merge two or more columns in a single row or multiple rows in excel file. For merging cells you need to specify the range of rows and columns in the…

Posted in Excel Python

Python Excel Merge Unmerge Cells

Images in Excel In this example I am going to show you how to insert images in excel file using Python script. You may have a requirement that needs to insert one or more images into an excel file. Either to represent something using the images in the excel file or you may need both…

Posted in Python

Insert Images In Excel File Using Python

HTML Table HTML table is mainly used to display data in tabular format in rows and columns. Each row contains one or more columns to display data. Each row is indicated by <tr/> tag, whereas each column is indicated by <td/> tag. The HTML table is indicated by <table/> tag. The HTML table header is indicated by <thead/> and body is indicated by <tbody/> tag….

Posted in React JS

HTML Table Conditional Cell Color Using React

HTML Table HTML table is generally used to display data in tabular format in rows and columns. Each row contains one or more columns to display data. Each row is indicated by <tr/> tag, whereas each column is indicated by <td/> tag. The HTML table is indicated by <table/> tag. The HTML table header is…

Posted in Angular

HTML Table Conditional Cell Color Using Angular

Borders in Excel File In this example I am going to show you how to create borders in excel file. I will create two sheets in the same excel file. In one sheet I will show how to create borders around rows and columns without writing any text. In the other sheet I will show…

Posted in Excel Python

How To Create Borders In Excel File Using Python

Git Password Update Here I am going to show you how to update password in Git client. You may need to update password in your Git client while accessing Git repository for several reasons. For example, your organization allow access to different systems using SSO (Single Sign On). So while you update password upon expiration,…

Posted in Git

Update Password In Git Client

Manifest File A manifest file contains metadata for a group of accompanying files which are part of coherent unit. For example, the files of a computer program may have a manifest describing the name, version number, license and the constituent files of the program. Manifests provide consistency and reproducibility, and can help you automate deploying…

Posted in PCF

PCF (Pivotal Cloud Foundry) App Manifest File

PDF In this example I am going to show you how to add images to PDF documents or files. you may need to add or include images into pdf files along with text information. There are a number of advantages while using pdf as a document for various purposes, such as: PDF format reports allows…

Posted in Python

Python Add Images To PDF Documents

JenkinsFile In this tutorial I am going to show you how to read YAML/YML config file in JenkinsFile. The JenkinsFIle is used for Jenkins pipeline which is used to perform many steps such as, building, testing, deploying a job through Jenkins. The yaml/yml config file can be a PCF manifest file or any other config…

Posted in Jenkins PCF

How To Read YAML File Into JenkinsFile

Introduction In this example I am going to show you how to color HTML table’s cells based on condition. The condition may be a value range, for example, HTML table cells (<td/>) have certain values and based on values you can choose background color of the cells. I am using pure JavaScript to iterate through…

Posted in CSS HTML JavaScript

HTML Table Conditional Cell Color

Introduction Here I am going to show you how to write Junit test for Spring Boot main class. A class having main method in Spring boot application is called main class and the purpose of this class is to deploy the application into embedded Tomcat server without configuring deployment descriptor or generating war file for…

Posted in Junit Spring Boot

How To Write Junit Test For Spring Boot Main Class

Problem While you are building a Jenkins pipeline job through Jenkins for the first time, you may encounter such error “failed to find any usable tags for the pipeline in pipelineMode“. This error may arise due to the fact that you have created the branch recently and there is no tag version yet released for…

Posted in Git Jenkins

Jenkins – failed to find any usable tags for the pipeline in mode