How to generate Excel Report from MySQL Database in Spring Boot

Here I am going to show you how to download excel file from MySQL using Spring framework. Generating excel report from MySQL database has few advantages over other file formats. Most of the people you are working with in your organization are familiar with excel file format, hence it needs a short learning curve. You may also like to read how to download json file in Spring Boot. The excel file has other benefits as given below: It allows you to use templates and formulas to aggregate data. It has…

Continue

How to add comments in excel sheet cell using Apache POI Java API

Introduction In excel file we have seen there are comments on text cells or columns. So in this tutorial we will see how to add or insert comments in excel sheet cell using Apache POI Java API. Comments can help you to remember what all are formulae or instructions you want to provide to other excel users. In this example we will create an excel file using Apache POI and Java programming language. In the excel file we will create a sheet and on particular columns on particular rows we…

Continue

Upload and display multiple images using Python and Flask

Introduction Here I am going to show you how to upload multiple images and display them one by one once images get uploaded. I am using here Flask as a web based framework on top of Python language. On the UI (User Interface) we have input field which is used to select multiple files. To select multiple files after clicking on browse button you need to hold Ctrl key (Windows OS) on the keyboard.

Continue

File Upload and File Download REST APIs Testing using Rest Assured in Java

Introduction In this tutorial we will test REST APIs used for file upload and file download. The file upload or download application might have been created using any server side technology. We are going to use here Rest Assured library with Junit 5 framework in Java programming language. We will use multipart for file upload test. For download test you don’t need such content type – multipart. The fluent API used by REST Assured supports the familiar Given/When/Then syntax from behavior driven development (BDD) framework, resulting in a test that is easy…

Continue

Add images to Excel file using Apache POI in Java

Introduction In this tutorial we will see an example on how to add images to excel file using Apache POI in Java programming language. Using Apache POI library it becomes easy to insert or add images into excel file. Images are part of the drawing support. To add an image just call createPicture() on the drawing patriarch. In this example we will insert or add two images of types png and jpg/jpeg. I am going to show you example using both maven and gradle build tools. Here I am using Apache POI…

Continue

How to generate line chart in Excel using Apache POI

Introduction In this tutorial I will show you how to create line chart in excel file using Java based Apache POI library. I will also show you how to build this application using both maven and gradle build tools. This is a standalone application and you can use this concept of line chart generation in any Java based application. In this example we will create two lines representing area of each country with marker and population of each country with marker. A line chart or line plot or line graph…

Continue