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: Importing sheets as tables from an Excel spreadsheet
Topic Summary: Import Excel to DOORS
Created On: 20-Dec-2005 15:06
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.
 20-Dec-2005 15:06
User is offline View Users Profile Print this message


Jason Lutz

Posts: 13
Joined: 14-Jul-2005

I have a very large Excel spreadsheet with multiple sheets (50 or more), which I plan to have as individual tables in a DOORS module.  Does anyone have suggestions as to how this should be done?

The ideas I have thus far are not very appetizing to me:
1)  Save each sheet as a table in Word and import the Word document into DOORS.
2)  Copy and paste each sheet from Excel into DOORS.
3)  Save each sheet as a csv file, import it into DOORS, and "Insert module as table" from the imported module into the module I wish the table to reside.

I may be able to save some time using Excel macros or DXL, but I know neither at the moment, so I'd like to get some opinions before I learn one or the other.  Or better yet, if there is an easier solution out there, I'd like to do that.

Thank you,
Jason Lutz
Report this to a Moderator Report this to a Moderator
 21-Dec-2005 14:49
User is offline View Users Profile Print this message


Richard Good

Posts: 152
Joined: 22-Mar-2005

Hi Jason,
Your question is not really a DOORS question, what you appear to want to do is write an excel macro which creates tables in a word document for each sheet in your workbook then use the standard export to doors tool.

If you are only going to do this once then and you are only looking at 50 sheets then don't waste your time with macros simply do a cut and paste 50 times, it'll only take you a few minutes!

If you need to do this many times then your macro should be somthing like: -

'get the word application Word VB help is quite good on this sort of stuff you'll need to look up the syntax
dim WordApp as application
dim ActiveDoc as word.document
set WordApp = getobject(,word.application)
set ActiveDoc = WordApp.activedocument

dim ws as Worksheet
for each ws in ActiveWorkBook
'copy each sheet to the end of the activedocument
ws.copy
Activedoc.paste
next ws

Don't think your looking at more than 20-30 lines of code, obviously the above is a 10 second brain dump so will need modification!!

-------------------------
Regards,

Richard Good
Report this to a Moderator Report this to a Moderator
 22-Dec-2005 16:14
User is offline View Users Profile Print this message


Hazel Woodcock

Posts: 78
Joined: 6-May-2005

These sheets were all separate in Excel, is it possible that it would work to have each sheet as a separate DOORS module with links between them?

Hazel
Report this to a Moderator Report this to a Moderator
 29-Dec-2005 15:49
User is offline View Users Profile Print this message


Brenda Cornell

Posts: 29
Joined: 7-Jul-2005

Just curious why you'd want to put the excel documents in DOORS as tables?? And do you plan to link anything? We used to use tables in DOORS (using WORD tables), but found doing traceability reports of links very difficult. The wizards don't show the traceability information in the columns that normal (non-table) objects would show.

Another question would be, do you plan to maintain the excel documents and re-import updates to DOORS if any updates are done?? Or are you planning on maintaining the information in DOORS going foward?? Re-importing updates may be more difficult if using the tables. Need a key to do the updates.

-------------------------
Brenda Heiss Cornell
Report this to a Moderator Report this to a Moderator
 5-Jan-2006 18:21
User is offline View Users Profile Print this message


Jason Lutz

Posts: 13
Joined: 14-Jul-2005

The reason I did not originally just do a copy and paste from Excel to DOORS is because doing that would not allow me to have links between individual cells and anything else. I wanted it to be a DOORS table, not an Excel table, which I am pretty sure are different (correct me if I am wrong). The DOORS tables seem to be individual objects in the DOORS database clumped together as a table while the Excel tables seem to be one large object. I do not plan to update from the Excel spreadsheet once I get it in DOORS. This is a one time thing (at least for this program), and after it is in DOORS, it will be maintained there.

Thank for the help!
Jason Lutz

Edited: 17-Jan-2006 at 18:53 by Jason Lutz
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 0 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 0 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.