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: Saving Excel file from DXL
Topic Summary:
Created On: 26-Feb-2004 08:43
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.
 26-Feb-2004 08:43
User is offline View Users Profile Print this message


Pieter DE WAARD

Posts: 73
Joined: 11-Jul-2003

We make gladly use of the Excel exporter written by Galactic Solutions. When the script stops, we would like to save the Excel file automatically. We are using elements of it to generate history files automatically, which means we want to launch a script and go home. When done, the Excel files need to be saved. Is it possible to run, say, a VB script triggered by DXL to make Excel do this?

Pieter de Waard

-------------------------
Pieter de Waard
www.nhindustries.com
Report this to a Moderator Report this to a Moderator
 26-Feb-2004 16:43
User is offline View Users Profile Print this message


Robert Padilla

Posts: 13
Joined: 5-Jan-2004

When your Excel script has completed, try this:

// SAVE FILE
clear(args);
put(args, "FileName", "--- desired filename here ---");
checkRes(oleMethod(objWorkbook, "SaveAs", args));

-=[ Bob Padilla ]=-
Ciena Corporation
rpadilla@ciena.com
Report this to a Moderator Report this to a Moderator
 26-Feb-2004 16:48
User is offline View Users Profile Print this message


Pieter DE WAARD

Posts: 73
Joined: 11-Jul-2003

Thanks Bob. Do you mean when DXL script finishes, or really Excel script?

Pieter

-------------------------
Pieter de Waard
www.nhindustries.com
Report this to a Moderator Report this to a Moderator
 26-Feb-2004 16:54
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Pieter,

Thanks for the kind words about our Enhanced Export to Excel utility.

I'll think about building that feature into a future version of the utility.

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 26-Feb-2004 18:28
User is offline View Users Profile Print this message


Robert Padilla

Posts: 13
Joined: 5-Jan-2004

I've not looked at the Galatic solution, but I will in a few minutes. This would need to be included in the same script when all exporting has completed. It requires the use of the Excel 'objWorkbook' OLE autoobject created in the script to complete the process.



Report this to a Moderator Report this to a Moderator
 23-Mar-2004 14:58
User is offline View Users Profile Print this message


Ben Tooker

Posts: 13
Joined: 9-Jun-2003

Robert,

I see how these commands below work nicely in the Enhanced Export to Excel of Galatic Solution (I'm going to check on their other dxls).

// SAVE FILE
clear(args);
put(args, "FileName", "--- desired filename here ---");
checkRes(oleMethod(objWorkbook, "SaveAs", args));

But if someone is running a VERY LARGE 4 Level Matrix Report in Batch at night on a dxl, how can someone "CLOSE" the Excel file, and "EXIT" the Excel software leaving just the report in a folder? (I asked DOORS Support this question but couldn't get API advice.)

I haven't been able to find the CLOSE and EXIT commands in Microsoft API documents.

Thanks,
Ben

Ben_W_Tooker@raytheon.com



-------------------------
Ben Tooker
Report this to a Moderator Report this to a Moderator
 23-Mar-2004 22:33
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Ben,

Try the following methods (I haven't done so yet):

Close and Quit

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 24-Mar-2004 23:03
User is offline View Users Profile Print this message


Ben Tooker

Posts: 13
Joined: 9-Jun-2003

Michael,

Good point, the "Close' works:

checkRes(oleMethod(objWorkbook, "Close", args));

Now at the end, the "Save As" and "Close" works nice, only leaving the Excel software up.

I've tried oleMethod with Exits, and Quits (with and without args) along with some connectToApp and disconnectFromApp but can't seem to bring Excel down.

Any other possible functions?
Respectfully,
Ben
Ben_W_Tooker@raytheon.com


-------------------------
Ben Tooker
Report this to a Moderator Report this to a Moderator
 21-Feb-2005 15:01
User is offline View Users Profile Print this message


Pieter DE WAARD

Posts: 73
Joined: 11-Jul-2003

Ben,

Have you succeeded in solving the problem of getting Excel down?

We still have this need, and it will be nice to know how it can be done.

Thanks, Pieter

-------------------------
Pieter de Waard
www.nhindustries.com

Edited: 21-Feb-2005 at 15:03 by Pieter DE WAARD
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 0 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 0 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.