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...
Forum Discussion
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.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!
Oh, and you’ll need to paste this into you “Referenced Assemblies” line on the BR properties.
C:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\bin\DocumentFormat.OpenXml.dll; C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.0\WindowsBase.dll
If a choice is given I would’ve gone with EPPlus than OpenXML. That thing is convoluted. Now, to answer your question Darpan Table View cannot do that. If and only IF books support a table view query then it was easier to do this.
For now as John mentioned you need something that can create an EXCEL file. My choice is EPPlus (it is an external dll). You could use interop however, that means you need EXCEL installed and it is slow.I’ll have to check that out for sure, thanks Celvin!
