django-import-export. How to disable the creation of empty cells?

Question

Django

Good day. I am trying to import xls table. There are only a few rows and columns filled in. How can I make django-import-export not create those empty cells? And then when importing, in addition to what is needed, it also creates empty cells in the database and assigns them None values. Thank you.

Answer 1

If you need to exclude some columns altogether, then:

class Meta:
        model = MyModel
        exclude = ('some_column', )

And in order to exclude rows that match / do not match some conditions, you need to override the skip_row method of import_export.resources.Resource