Attribute table to multiple worksheets in single excel workbook based on field value

341
3
03-29-2017 04:34 AM
Highlighted
New Contributor

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.

Reply
0 Kudos
3 Replies
Highlighted
MVP Esteemed Contributor

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.

Highlighted
New Contributor

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.

Reply
0 Kudos
Highlighted
MVP Frequent Contributor

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 

And

xlwt 1.2.0 : Python Package Index 

Reply
0 Kudos