Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: External Links in DOORS 8.1
Topic Summary: How to identify sheet and cell within Excel File using external links
Created On: 22-Jan-2007 16:56
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 22-Jan-2007 16:56
User is offline View Users Profile Print this message


Don Fowler

Posts: 12
Joined: 28-Jun-2005

I am using a DOORS 8.1, Windows platform, Mozilla Firefox default browser. I have been able to create an external link (using DOORS 8.1 External Links capability) to an excel file using the url file protocol:

file://C:\Documents%20and%20Settings\myplace\My%20Documents\Systems%20Engineering\comments.xls

I, however, cannot seem find the right protocol for identifying the sheet and cell location within the excel file. I have read the white paper and there is no example for excel. It doesn't look like anyone else has had any similar problems on this forum, so it might be an easy question to answer.

Thanks, Don Fowler
Report this to a Moderator Report this to a Moderator
 23-Jan-2007 11:46
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Don,

I tried to create Hyperlinks from MS Word to an MS Excel file.
This worked fine. You have to add something like this at end:

file.xls#Table1!A1:B5
or
file.xls#NamedArea

But unfortunately I was not able to use this syntax outside MS Office. So it did not worked from IE and of couse not from Doors External Links ....

So this may be a starting point for someone else

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 23-Jan-2007 21:28
User is offline View Users Profile Print this message


Don Fowler

Posts: 12
Joined: 28-Jun-2005

Hi Reik,

That seems to be the case. I didn't know about the "#" after the filename so I tried your suggestion and found it did not work any better with Mozilla Firefox. Without the capability to link to a specific location in the spreadsheet, the value of the External links is limited. Oh, well, it seemed like a good idea anyway.

Thanks,
Don
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.