Forum Discussion
Solved
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...
I would like to know how to create an Excel document using a data table in BR. When I used a table view from Excel, it was too slow since the table view has too many rows and columns. Basically want to see the rest of the codes you posted.
Thanks!
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.
https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/902b6b1ced71600532c07ec9ac72ae871d360651.png
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!
Hey John,
I can see you are using Visual Studio to write rules, do you mind sharing how to write rules in visual studio I find the br editor a bit cumbersome.
Thanks,
Sudarshan
Yeah, so the first thing is you need to get the DLLs or Assemblies for the OneStream API. I get these off the file system when I install a server, like on a VM or personal machine. Once you have those, you simply add them as references in your project, and you should get the full intellisense you need. You can't actually compile or debug rules in VS, it is just a Code Editor, not a full IDE unfortunately. But I still find a ton of value in it! Also, you can easily use Visual Studio Community, you don't need a full license for the work we do.
If OneStream can com up with SDKs that would be great. Instead of us adding dlls for the rule types.
Agreed! And even better would be a way of hooking into a live OS environment for real time debugging 🙂
Got it, our organization uses a cloud instance so dont think I can access the DLLs unfortunately. But thanks for this
Sent you a link via PM to my personal Dropbox with the latest version of the assemblies I have
