![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.