this technique is buggy in version 1.6.1 @naegelyd suggested a workaround found <a href='https://bitbucket.org/ericgazoni/openpyxl/issue/273/allow-slicing-in-iterableworksheet'>here</a>