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

Thank you JackLacava for providing those details. 

I tried all 3 steps, 2nd and 3rd is working. But for the 1st step if I try to export using DM step with SQL Table Editor/Grid View components with in dashboard, it is just exporting empty file with out data. 

Thank you. 

Sridhar 

MarkBird's avatar
MarkBird
Contributor III
2 years ago
Copy Link

Hi Sridhar 

We're having a similar issue. Did you manage to resolve this?

Regards,

Mark

  • 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.