Focal Point
[SOLVED] Excel Template with a Chart

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4657090786

June 29, 2017, 09:11 AM
gerndude
[SOLVED] Excel Template with a Chart
Can anyone point me to a "WebFOCUS and Excel Templates for Dummies" explanation of how to do this? I have an existing Excel file with two sheets; one has the data, the other has the chart. I want to populate the data sheet with a WebFOCUS report. This would update the chart and output as an Excel file. I have looked at lots of presentations from Summit, but I do not seem to be getting this right. I really need to solve this issue, so I can use Excel templates for this and other needs. Help!

This message has been edited. Last edited by: gerndude,


WebFOCUS 8203 Gen 43
App Studio 8203 Gen 04232018
Hyperstage 8203M Gen 1320
MS Sequel Server 2014
Windows 10
Excel/AHTML/PDF/HTML
Chrome, IE11
June 29, 2017, 09:29 AM
BabakNYC
https://webfocusinfocenter.inf.../pdfs/wf82crlang.pdf

Page 623 tells you everything you need to know about templates.


WebFOCUS 8206, Unix, Windows
June 29, 2017, 04:11 PM
gerndude
Thanks. I had already read that several times. I finally realized my issue. Once I re-created my chart using the Excel doc that was output using WebFOCUS, everything worked. I had originally tried using a provided Excel doc. Basically, I had to create my chart from scratch using the WF created Excel doc.


WebFOCUS 8203 Gen 43
App Studio 8203 Gen 04232018
Hyperstage 8203M Gen 1320
MS Sequel Server 2014
Windows 10
Excel/AHTML/PDF/HTML
Chrome, IE11