In about 5 places throughout Teamwork, we provide the option to export reports in excel format, but we cheated: we used to simply generate CSV files and download them as ".xls" files. The problem with this is that excel would pop up a warning message when the file was opened and there was no styling or formatting to the data - it was just plain ugly text.
This has been bugging me for a while so last Friday when Sam asked me to add two missing columns (Invoice number and was invoiced) to the time excel report I couldn't help myself.
I've ended up spending all of last Friday and some of this morning programming new Excel code that generates 'real' excel files with nice styling.
Getting the date columns to render as proper dates that could be sorted etc. broke my heart - it took me about 200 attempts to get it right.
Hope you like it! :-D
ps. Dan and I are working on allowing you to assign tasks to multiple people - it will be sweet!