Introduction Here I am going to show you how to generate excel report from MySQL database using Python Flask. We will create a web application using light-weight web framework called Flask. We will generate the excel file on the fly from MySQL database in this web application. A download link will be provided on front-end…

Introduction Here I am going to show you how to generate CSV report from MySQL database using Python Flask. We will create a web application using light-weight web framework called Flask. We will generate the CSV (comma separated values) file on the fly from MySQL database in this web application. A download link will be…

Introduction Here I am going to show a simple example on how to download a file from web application using Python Flask. I will download the file which is kept in the server location. The file could be of any type of file, i.e., pdf, text, excel, word etc. In this example there will be…

Introduction I am going to show you how to read file and write to a PDF document using Python 3. The file content may be in any format and it depends on you how you are going to parse it. I am going to show you how to read text file and write into PDF…

Introduction In my previous tutorial I had shown how to create PDF document using Python 3 but, here we will see how to convert HTML content into PDF document. Sometimes it may be good idea to directly write HTML content into PDF file to print the texts mixing with different styles. In this example I…

Introduction In this tutorial I will show you how to write to pdf file using Python 3. I will also create header, footer along with body of the text in the generated pdf file. I will also decorate such text with color and style. I am going to use fpdf library to create pdf file….

Introduction In this guide I will tell you how to create header and footer in word document using Python 3. We will finally create docx file. Sometime you want to write some text in header and footer of word file to enhance the readability of viewers. Headers and footers are linked to a section; this…

Introduction In this guide I will show you how to detect and delete empty rows from excel file using Apache POI in Java. I will see also how to read and write excel file using Apache POI. If you have few cells or columns in a row then you can deal with those empty cells…

Introduction We will create an example here and we will show you how to upload single file or multiple files using AJAX and jQuery along with Python Flask technologies. You can either upload single file using browse button or multiple files using browse button by holding CTRL key(in Windows OS) from keyboard while selecting multiple…

Introduction In this post we will see how to set print area for excel sheet using apache poi in Java. There may be many number of columns and rows in your excel sheet but you need only few columns and rows to be printed in paper instead of all columns and rows from the sheet…

Introduction This example is about to upload multiple files using Python Flask REST API. We have also seen how to upload single file using Python Flask REST API. We may need to upload single or multiple files according to application’s requirements and here we are going to create an example on Python Flask REST API…

Introduction I will create here Python Flask REST API file upload example though you might have seen how to upload file using Python Flask in web application. You may need to upload a single file or multiple files into your application for a reason and here I am going to use light-weight web based Python…