How do I get report data into a Excel spread sheet?
Continuum 1.6 thru 1.94
Microsoft Office 2003, 2007
Exporting data to Excel allows it to be used and shared in a common format.
Create a Report:
Data Source = Extended Log
Chart Type = Text
Chart Subtype= AccTextXML
Heading = %r
SubHeading = Report created at %t
Display the full path in the report = Selected
OutPut to File = Selected Select the path. = Example c:\Report.txt
Select Time interval
Add Data points.
Save: then Run Report: The file should have been created in the selected directory.
Goto the selected directory and right click on the file and Open with Microsoft Office Excel.
You will be prompted with some choices select "As an XML List"
Save to desired location as a xls file.