I am having attribute table, would like to create multiple excel worksheet in single workbook. Each worksheet should be created based on the values in the specific field.
Excel tools are somewhat limited... and perhaps rightly so, since it isn't the best platform to manage your data. There are many options should you wish to follow the programming route (ie via python) but again, this would really depend whether the need to get to excel in your desired format is worth the effort.
Requirement is to facilitate web user a one click option to generate summary and multiple worksheets in the same excel based on the frequency and unique values in the field.
There is lots of stuff you can do with the xlrt module in python.
Just assemble the data as a list, then go from there.
See the bit on writing to excel ....
Some Python Snippets
xlwt 1.2.0 : Python Package Index
Retrieving data ...