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 (4031339) | 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 (661) | 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 (4031339) | 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.9k1318) | 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.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.