Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Scheduled export to Excel


Casper Holt

Recommended Posts

  • 3 months later...

Hi there,

 

From DV side, you can create a trigger to invoke a Store Procedure / Java Custom Function to export data as csv format (for excel format, it may need more 3rd library under .NET).

 

Form Excel side, you can make a spreedsheet to load the data from published view via ADO driver, and make a timer through VBA to reload the data from DV. It is easier but the excel needs to opened all the time....

 

for your reference, hope it helps

 

Danny Yu from Taipei

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...