I have had a pretty rough experience with this module of python. Well, here is the code and I speculate the error to occur in line 34.
I am using the latest version of the module, excel and python.
The code does not pop any kind of error in the console but the excel file hence created is corrupt.
the code was too long to send here.