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: Copy paste from Excel to a Doors Table
Topic Summary:
Created On: 8-Mar-2006 01:41
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.
 8-Mar-2006 01:41
User is offline View Users Profile Print this message


Daniel Craig

Posts: 5
Joined: 8-Mar-2006

I'm trying to find a simple way to copy a portion of an Excel spreadsheet and insert it into Doors as a Doors Table (not an OLE object). Copying from Excel simply gives you a tab delimited text string for the table, so it doesn't seem like it would be very difficult to do, but I don't have any experience with DXL and am quite frustrated with it. I can make the dialog box to put paste my excel data into a buffer and I can create and modify tables, I just don't know how to parse the buffer to build the table. Any help? Thanks, Dan Craig
Report this to a Moderator Report this to a Moderator
 8-Mar-2006 17:13
User is offline View Users Profile Print this message


Shawn Stepper

Posts: 96
Joined: 6-Aug-2004

The easiest way to do this without DXL is to:
- Copy the table from Excel into Word
- Use the DOORS export from Word function (from withinin Word)

Voila, tables in DOORS.

-------------------------
Shawn Stepper
shawn.e.stepper@wellsfargo.com
Report this to a Moderator Report this to a Moderator
 8-Mar-2006 21:07
User is offline View Users Profile Print this message


Daniel Craig

Posts: 5
Joined: 8-Mar-2006

Thanks for the reply. I've almost got the direct import from a text box, and I'm stubborn enough to keep working at it. I can parse the text string now, find my delimiters, and count up rows and columns. Then I am creating a table with those dimensions. Is there a way to step through a table, for example, say I want to insert the Object Text into the cell in row 2, column 3? Or is the only way to access cells in a table by doing the "for row in table" kind of looping?
Report this to a Moderator Report this to a Moderator
 9-Mar-2006 00:35
User is offline View Users Profile Print this message


Daniel Craig

Posts: 5
Joined: 8-Mar-2006

I finally got an excel table import script working. It's clunky, but works. It's attached in case anyone else might want to use it.
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.