Forum Discussion

darpan13's avatar
darpan13
Contributor
4 years ago

Table View - Tab Addition Automation ??

SOURCE: ONESTREAM CHAMPIONS Hi Team, Greetings for the Day. We have a requirement to download the registers data into an Excel Book with all Account as different Sheets and that too from with...
Excel Add In
JohnMorehead's avatar
JohnMorehead
New Contributor III
4 years ago

Darpan, I don’t think that Tables Views are actually your best option. You’re probably best off using an Extensibility rule to create an excel document of the exact format you desire, that way it will be flexible about the addition of accounts in the future, but give you control over the formatting of the data as necessary as well.

image
image.png1530×758 75.8 KB

 

This is a screenshot of some example code for creating an Excel document with separate sheets for each data table in a data set. If you need more info, just let me know!