Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago
Solved

Is it possible to use spreadsheet component (Table View in it) in the Book ?

Hi All,  I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external...
Dashboards
Excel Add In
Extensible Documents
Reports
Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago
Copy Link

Hi MarkBird 

None of the existing dashboard components worked for me, so I created an Extender Business Rule and used BR Apis to create data tables and VB.Net code to export it to excel and drop it to file share. Please let me know if you have any further questions, I am happy to answer. 

Regards

Sridhar 

LinkedIn: Sridhar 

jwagner's avatar
jwagner
New Contributor III
2 months ago
Copy Link

Hi Sridhar, would you be able to share a code snippet of how you were able to use Vb.Net to export a data table into excel?  I assume you used a business rule.