![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Exporting report content to spreadsheet Topic Summary: Created On: 8-Jun-2006 15:01 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
There are a couple of options you can use. Edited: 13-Jun-2006 at 16:34 by Andrea Heithoff |
|
![]() |
|
![]() |
|
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.) |
|
![]() |
|
![]() |
|
Sheri, |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Regarding the "C:\" reference: |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.