It's all about the answers!

Ask a question

To export all the column data in particular view of a module into excel through DXL scripting

Shriraam Balasubramanian (4021026) | asked Feb 27 '13, 4:15 a.m.
edited Jul 22 '15, 12:28 a.m.

Hello All,

Can any one please help how to export all the column data in a particular view of a module into an excel through DXL scripting.

Thanks a lot in advance.

4 answers

permanent link
stuart green (261) | answered Feb 27 '13, 6:30 a.m.

The built-in Excel exporter provides this functionality, and the DXL which implements it is available unencrypted, as an example, in DOORSHOME\lib\dxl\standard\export\office\excel.dxl.

It uses OLE automation DXL, as described in the DXL manual section titled Automation Client Support.


permanent link
Shriraam Balasubramanian (4021026) | answered Feb 27 '13, 7:04 a.m.

Hey Stuart,

Thats not what I am looking for.Any ways thanks.

What I need is is to run a script in a executable module. I have already automated in such a way that my script will open a module(Exclusive edit mode) in particular view.

I got stuck up in exporting all the column data into an EXCEL Sheet.

I dont need to use OLE automation.This script (DOORSHOME\lib\dxl\standard\export\office\excel.dxl.
)when I run in Exclusive edit mode has many errors.

Please help me.


permanent link
Daniel Moul (4.7k1118) | answered Feb 27 '13, 7:36 a.m.
There is a whole forum on DeveloperWorks devoted to DXL. I suggest you ask your question there.  In fact  DOORS 9 questions are best asked there; that's where the DOORS 9 mostly hangs out.

permanent link
Raphael Calvo (6) | answered Jun 04 '14, 5:53 p.m.
 Instead of exporting directly to excel why not doing it as a tab separated value? I am currently at Innovate but when I come back to Brazil I can send you a piece of code using Buffers.

Your answer

Register or to post your answer.