Generate Excel Report from MySQL Database using Python Flask

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 or UI on which end users will click and will get an option to save the generated excel file as per their chosen location. We are going to use xlwt API for generating excel report. As we…

Continue

A guide to write excel file using Python

Introduction This tutorial shows a guide on how to write excel file using Python. You know that excel is great for generating reporting data. It also allows you to perform calculation on data, build complex formula which could be used to apply on different data. You can use this easily accessible excel tool to organize, analyze and store your data in tables. What’s more, this software is widely used in many different application fields all over the world and it also applies to data science. We have seen various operations…

Continue

A guide to read excel file using Python

Introduction This tutorial shows a guide on how to read excel file using Python. You know that excel is great for generating reporting data. It also allows you to perform calculation on data, build complex formula which could be used to apply on different data. You can use this easily accessible excel tool to organize, analyze and store your data in tables. What’s more, this software is widely used in many different application fields all over the world and it also applies to data science. We have seen various operations…

Continue

Generate Excel Report from MySQL Database using Codeigniter

Here we will see how to generate excel report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications and it’s easy to work with Codeigniter for building web applications. Why excel reporting? Most people in your organization are likely to be familiar with excel, hence it ensures a short (or nonexistent) learning curve during implementation. It allows you to use templates and formulas to aggregate data. It has very easy-to-use charting functionality compared to other software, and several helpful built-in features. It is…

Continue