Working with Excel files in Python
Microsoft Excel is a world-renowned software in the field of bookkeeping and tabular record management. Similarly, the XLSX file format that was introduced with Excel has seen rapid and widespread adoption and is now supported by all the major product vendors.
You will find that Microsoft Excel and its XLSX format are used quite a lot in the marketing and sales departments of many companies. Let’s say, for one such company’s marketing department, you are building a web portal in Django that keeps track of the products purchased by users. It also displays data about the purchases, such as the time of purchase and the location where the purchase was made. The marketing and sales teams are planning to use this data to generate leads or to create relevant advertisements.
The marketing and sales teams also use Excel quite a lot. You might want to export the data available inside your web application in XLSX format, which is native to...
