Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Exporting report content to spreadsheet
Topic Summary:
Created On: 8-Jun-2006 15:01
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
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.
 8-Jun-2006 15:01
User is offline View Users Profile Print this message


Sheri Dumire-Hamilton

Posts: 5
Joined: 15-Mar-2006

I would like to direct my report output to an Excel spreadsheet.  I have edited a report to have the content I want but don't have enough skill to direct it to a spreadsheet.

If no one has directed it to an Excel file, being able to direct it to some other file would be helpful so that I can email the report to others.

Thanks.
Report this to a Moderator Report this to a Moderator
 13-Jun-2006 16:33
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

There are a couple of options you can use. 

The attached code should be saved as a stylesheet and applied to your report in html.  You can copy the generated report directly into a spreadsheet---that should help with the basics.

An option using VBA is to generate the spreadsheet directly.  There's a larger set of code that can't be attached here I use that will generate the application object and tap into Excel functions to write the data to the cells.  It requires a lot of patience to learn how to query SA using VBA, but there are a lot of complex queries that can be run very effectively this way.



Edited: 13-Jun-2006 at 16:34 by Andrea Heithoff
Report this to a Moderator Report this to a Moderator
 14-Jun-2006 16:34
User is offline View Users Profile Print this message


Sheri Dumire-Hamilton

Posts: 5
Joined: 15-Mar-2006

The reports that I'm trying to redirect were not created in the GUI report editor, but in the text editor.  (That's why I couldn't use the instructions that I found in knowledgebase to do this.)

Given that I'll be editing this report in text editor, would I add this code to the bottom?  Am I missing something?

Thanks for responding!

Report this to a Moderator Report this to a Moderator
 15-Jun-2006 15:24
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

Sheri,
I got some clarification on how the stylesheets work...  I posted only part of what you'd need.  The good news is that what I posted is roughly an out of box feature.  If you did have the regular GUI, you could pick the nested tables stylesheet that comes with SA to generate the html report.

Since you're using text editor, the code below should work--I haven't used it myself, but I lifted it from a report in the SA DoDAF install report file.  Open the report file, select the report and click Edit.  It will ask you to use Text Editor, Continue or Cancel.  Choose Text Editor, and you should see other lines labeled as SETTING.  Replace the OUTPUTFILE file name with an HTML file and add the STYLESHEET line.  This should work for you, generating a html file with nested tables.

Post your results to make sure we actually solve the problem...good luck.

Report this to a Moderator Report this to a Moderator
 10-Jul-2006 18:17
User is offline View Users Profile Print this message


Sheri Dumire-Hamilton

Posts: 5
Joined: 15-Mar-2006

Thank you for the response.

I ended up editing the report using the report editor (rather than the text editor) despite the warning about losing some things.

I selected the default.xsl stylesheet and named the output file with a ".xls" extension, and indicated
that the report type should be "html".

I will duplicate the same report and try the method that you suggest as well.

Sheri
Report this to a Moderator Report this to a Moderator
 10-Jul-2006 18:19
User is offline View Users Profile Print this message


Sheri Dumire-Hamilton

Posts: 5
Joined: 15-Mar-2006

A question:  we are running SA off of a Citrix server.  What does the C: drive reference in the code you gave?  I may need to redirect that reference.....

Sheri
Report this to a Moderator Report this to a Moderator
 17-Jul-2006 01:30
User is offline View Users Profile Print this message


Ian Souchard

Posts: 22
Joined: 28-Feb-2006

I routinely generate Excel spreadsheets using the report generator by specifying XLS as the file extension of the output file and using the NestedTables.xsl stylesheet for html generation. I have also used one of the xsl templates in BaseTemplates.xsl (LevelItemPropsTabularRowPerChild) to generate "flattened" tables to perform pivot table/chart analysis on the report in Excel.
Report this to a Moderator Report this to a Moderator
 17-Jul-2006 23:08
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

If you are running Office 2003 you can dump the contents of your report (using VBA) to an XML file using SpreadsheetML. See link below for quick tutorial on writing an XML file for Excel 2003 and over.

http://blogs.msdn.com/brian_jones/archive/2005/06/27/433152.aspx
Report this to a Moderator Report this to a Moderator
 21-Jul-2006 04:31
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

Regarding the "C:\" reference:
I think the stylesheet is one that is installed with the application, so it would refer to the drive running the application.  If you're in Citrix, you'll need to make sure that the stylesheet is someplace accessible, probably a shared drive available to all of your users.

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 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.