It's all about the answers!

Ask a question

Can we embed an excel worksheet into the RQM dashboard?

seema prabhu (166) | asked Mar 21 '13, 9:07 a.m.
retagged Mar 25 '13, 7:06 a.m. by Gerd Schiering (12211316)

I have a report that is created in excel, which contains charts. I would like to display this on the RQM dashboard. Is there a way we can do this.

I have tried using html widget and savingthe excel chart as an image . However this does not work.

Please advise.

Laura Kuczarski commented Mar 21 '13, 9:22 a.m.

What happens when you try to include the image in the HTML widget?

One answer

permanent link
Gerd Schiering (12211316) | answered Mar 25 '13, 7:05 a.m.
Hi Seema,
You will need to put your image of the chart on a server that can be reached by a URL that is accessible from the RQM server machine (It will not go through  any firewalls you might have in place!).

The steps are:
On the dashboard use the "External Content" widget.
In the settings of that widget you can specify the external URL for your image graph:
For example:

In case this is blocked by your infrastructure you can also try to use the Tomcat server of your CLM installation
Create the folder C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static
(or where you have installed your server) and put your images in there.
For example C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static\mychart.jpg
The URL to use  inside the widget is then something like https://clm-server:9443/static/mychart.jpg

Hope this helps,
Gerd Schiering
IBM Rational

Your answer

Register or to post your answer.