Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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.


1

0 votes



4 answers

Permanent link
Shiraam,

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.

Cheers,
Stuart.

0 votes


Permanent link

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.

-Shriraam

0 votes


Permanent link
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.

0 votes


Permanent link
 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.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 198

Question asked: Feb 27 '13, 4:15 a.m.

Question was seen: 11,863 times

Last updated: Jul 22 '15, 12:28 a.m.

Confirmation Cancel Confirm