How To Convert Results Of Model Queries Into Xlsx Using Pandas In Python?

I have a standart model's collection in my project like this one: class Dimension(models.Model): dimension_id = MyCharField(max_length=1024, primary_key=True) name = MyChar

Solution 1:

I don't think you need pandas to write to excel.

I would use openpyxl for writing to excel. Just following the example on their page should be good enough for you. You just have to loop through your model and use openpyxl to write to specific rows and columns that you want.