Scheduled export to Excel

[Casper Holt]

I would like to build a scheduled export from Tibco to a Excel file. What would be the best method to do so

[Danny Yu]

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