![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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?
|
|
![]() |
|
![]() |
|
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.
|
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Copy paste from Excel to a Doors Table
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.