topic Attribute table to multiple worksheets in single excel workbook based on field value in Data Management Questions

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

OumerBhat — Wed, 29 Mar 2017 11:34:20 GMT

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.

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

DanPatterson_Retired — Thu, 30 Mar 2017 00:36:43 GMT

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.

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

OumerBhat — Thu, 30 Mar 2017 04:21:48 GMT

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.

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

NeilAyres — Thu, 30 Mar 2017 05:53:09 GMT

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