Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about how to export Django model data to Excel tables. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

The following describes how to build a feature similar to Tencent Cloud-console-CVM list data export to Excel based on Django.

All right, the requirements analysis is complete:

Click the `Export 'list button to bring up the export dialog box

According to the corresponding fields of the Django model, check the fields to be exported for data export.

You can add the option of `Export current list field `and `Export all` in the dialog box.

There are usually a lot of models in a django application, and recently I have seen some personal django projects on GitHub. With regard to the Django export excel section, they are all written through flexible functions, one by one for a model that needs to be exported, which is certainly not the best way.

To implement how to export data from different Model to excel tables in Django. Moreover, for all models, the exported table data is humanized and readable.

Friends who have been familiar with the Django admin framework may know that the idea of lists in the admin framework is suitable for redesigning to export Excel tables.

The following is a screenshot of the core code to export arbitrary model data:

Usage: `def download (request): objects = User.objects.all () # queryset. Return make_to_excel (objects, fields= ['id','xxx',]) # return "" above is how the Django model data shared by the editor is exported to the Excel table. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.