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: Enhanced Export to Excel v2.0
Topic Summary:
Created On: 3-Dec-2002 15:10
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.
 3-Dec-2002 15:10
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Galactic Solutions Group is pleased to make available the following free DOORS DXL utility:

"Enhanced Export to Excel v2.0",

which has been released and posted to the "downloads" area of our web site:

http://galactic-solutions.com

This is the first public release, so please let us have your feedback after you have evaluated it. We hope the DOORS user community finds it useful.

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 13-Jan-2003 13:31
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Galactic Solutions Group is pleased to make available an updated version of the following free DOORS DXL utility:

"Enhanced Export to Excel v2.1",

which has been released and posted to the "downloads" area of our web site:

http://galactic-solutions.com

Besides some minor bug fixes and interface improvements, the main functional improvements are:

(1) Updated to handle exporting and sizing of Windows Enhanced Metafiles in DOORS 6
(2) Updated to export Pictures





-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 14-Feb-2003 17:11
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Galactic Solutions Group is pleased to make available an updated version (v2.2) of the following free DOORS DXL utility:

Enhanced Export to Excel v2.2,

which has been released and posted to the downloads area of our web site.

The update includes the following bug fixes and improvements:

- Updated to correctly export text beginning with an "=" (equal sign) or a "-" (minus sign) or a "'" (single quote)
- Updated so that the "Object Number" is not exported for empty table cells
- Updated to export Rich Text for Layout DXL Columns
- Updated to ignore "Object Text" when in Outlining mode
- Updated Rows Tab with option to export deleted Objects in color
- Updated to export OLE Objects embedded in Layout DXL Columns (DOORS 6)

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com

Edited: 14-Feb-2003 at 17:12 by Michael Sutherland
Report this to a Moderator Report this to a Moderator
 5-Dec-2008 13:35
User is offline View Users Profile Print this message


Rich Mason

Posts: 5
Joined: 7-Nov-2008

Hi Michael

Was wondering if there was an updated version of this for 8.1. I downloaded the 7.x from you website and it didn't want to run.

thanks in advance, and thanks for these great scripts.

-------------------------
Rich Mason
DRS Optronics
Palm Bay FL
richard_mason@drsoptronics.com
Report this to a Moderator Report this to a Moderator
 5-Dec-2008 16:00
User is offline View Users Profile Print this message


Martin Hunter

Posts: 7
Joined: 24-Jul-2008

Rich,

I've used Michael's export tool with DOORS 8.x and had no problems although you will need to add the appropriate line or lines to the code as below:

const Skip EXCEL_DOORS_VERSIONS = create
put( EXCEL_DOORS_VERSIONS, 1, "DOORS 7" )
put( EXCEL_DOORS_VERSIONS, 2, "DOORS 7.0 SP1" )
put( EXCEL_DOORS_VERSIONS, 3, "DOORS 7.1" )

// added by Martin Hunter for DOORS 8.x
put( EXCEL_DOORS_VERSIONS, 4, "DOORS 8.1" )
put( EXCEL_DOORS_VERSIONS, 5, "DOORS 8.2" )
put( EXCEL_DOORS_VERSIONS, 5, "DOORS 8.2.0.1" )
put( EXCEL_DOORS_VERSIONS, 6, "DOORS 8.3.0.0" )
put( EXCEL_DOORS_VERSIONS, 7, "DOORS 8.3.0.1" )
put( EXCEL_DOORS_VERSIONS, 8, "DOORS 8.3.0.2" )

-------------------------
Martin

Edited: 5-Dec-2008 at 16:03 by Martin Hunter
Report this to a Moderator Report this to a Moderator
 5-Dec-2008 16:35
User is offline View Users Profile Print this message


Rich Mason

Posts: 5
Joined: 7-Nov-2008

works great, thanks Martin.

this is a great tool for an easy, pretty export to excel. I noticed tho that doors native tables are still exported like normal in that the table cells are exported as separate rows in excel.

is there no other way around this than making doors native tables into ole's and exporting?

thanks again

-------------------------
Rich Mason
DRS Optronics
Palm Bay FL
richard_mason@drsoptronics.com
Report this to a Moderator Report this to a Moderator
 5-Dec-2008 16:56
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 120
Joined: 16-Jan-2008

Rich,

You have the source code, hack away!

Also, I have completely removed the version check in my implementation. This ensures it works for all versions of DOORS.

-------------------------
Kevin Murphy
http://www.baselinesinc.com
Report this to a Moderator Report this to a Moderator
 5-Dec-2008 17:01
User is offline View Users Profile Print this message


Rich Mason

Posts: 5
Joined: 7-Nov-2008

pfffftttt, you obviously over-estimate me sir....actually Kevin I'm checking out your code from another thread right now on this

https://forum.telelogic.com/customer/doors/messageview.cfm?catid=58&threadid=5139&highlight_key=y&keyword1=excel%20tables

will let you know how I do

-------------------------
Rich Mason
DRS Optronics
Palm Bay FL
richard_mason@drsoptronics.com
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.