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!
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!
