search

4teamwork / ftw.linkchecker

0 stars 0 forks source link

Add functionality to create excel report #9

Closed busykoala closed 5 years ago

busykoala commented 5 years ago

Resolve #4

I added an issue (#8) to remove example data in this file as soon as there is another source for the data.

busykoala commented 5 years ago

I hope my commit isn't too confusing. It definitely makes the code better readable and one can better follow the steps done.

I also noticed that longer strings will not match with column width. Therefore I changed the default font to a monospaced one. Since I couldn't figure out how to operate on the workbook to set default font type/size i had to approximate the font size. The font size/type set now, will increase the cell width a little too much as strings are getting longer. But since it's linearly enlarging because it is monospaced the impact is pretty small.

Also I didn't notice before that the dependency to xmlswriter is missing because I've installed it with pip before.