![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Excel-Export in Batch-Mode Topic Summary: Is this possible? Created On: 30-Apr-2007 09:24 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hi all,
does anybody know if it is possible to run an excel-export(build in) in batch-mode?
if yes, which changes do i have to do to make this possible? (of course, exept supressig all dialogues!)
greetings
thomas
|
|
![]() |
|
![]() |
|
We run nightly batch scripts that recreate tab delimited files which can be opened in Excel.
Basically you use a "for o in m do" loop to loop through all the objects in a module and just output each attribute you wish to a file separating attributes by tabs. Make sure to put the attribute names in the first row in each file. Then just set up a .bat file which your IT department can add as a service to run nightly. See Streams in the DXL help manual for writing to files. No rich text however will be kept. I have a file of Excel functions you can use if you wish to write a simple Excel Exporter. A good non-batch Excel exporter is Michael Sutherland's Enhanced Export to Excel (a simple search will help you find it on here). A lot of my Excel functions are modifications of his code from that tool. Feel free to email me to get it. ------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
http://www.galactic-solutions....acticDownloadExcel.htm
is where you can download the Excel Exporter by Michael Sutherland. I don't see a version for DOORS 8, but I downloaded the Version for DOORS 7 and commented out the version checking around lines 3290. It seemed to work fine. Thanks. ------------------------- Craig Forant me@craigforant.com |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Excel-Export in Batch-Mode
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.