Re: Using MS Excel for Dash Board integrating with uniPaaS 1.9


Frigyesi Viktória
 


I was following the same approach: placing a browser control on a Magic form, refreshing in the needed interval. The browser is showing a diagram, which is made in Excel. You can set the save as properties of the Excel Diagram to be HTML, one form, always overwrite without prompt (some VB is needed here within form). Diagram is refreshed automatically when new data is saved into source. The security settings need some adjustment too. It works fine as a Dashboard showing high transactional volume KPIs.

Feladó: main@magicu-l.groups.io <main@magicu-l.groups.io>, meghatalmazó: Wes Hein <wes@...>
Elküldve: 2020. május 18., hétfő 20:42
Címzett: main@magicu-l.groups.io <main@magicu-l.groups.io>
Tárgy: Re: [magicu-l] Using MS Excel for Dash Board integrating with uniPaaS 1.9
 
Rather than using a worksheet as the data source for the pivot table/dash board, use a different workbook.  By having your template reference a different file, you can delete and replace the data at will without messing up the dashboard

Wes

Join main@magicu-l.groups.io to automatically receive all group messages.