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.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.