>> Is there a way to style the sheet instead of setting style by range or cell
I think you may be looking for the workbook's default style, or column styles, but not sure what you mean. Do you have some example what you are trying to achieve?
>> i read the workitem 2774 regarding not supporting the autfilter in Excel5 and i was wondering if any progress or new ideas took place regarding it from 2007 till now and thanks in advance
The plan is to get as many things as possible to work in Excel5 writer including autofilter, but the most critical issue is the broken formula support. There is this work item for autofilter: