Exporting Data to a Spreadsheet
This operation creates a delimited text file from the data in the desired analysis panel and launches the spreadsheet program specified in the relevant preference. The text file, stored in the op_admin/tmp directory, can then be imported by any spreadsheet program and further manipulated. If the spreadsheet program is Microsoft Excel, this operation automatically launches the program, imports the text file, and displays the data in a spreadsheet.
Procedure 166: Exporting Data
-
Verify that the "spreadsheet_prog" preference displays the path name where the spreadsheet program is located.
For details on this attribute, see "Program Descriptions" on page 145.
-
Display the graph or graphs you wish to export. If you want to export multiple graphs, it is most efficient to display them all in a single panel, using the Statistics Stacked option.
For details on display options, see View Results.
-
Do one of the following:
- If you displayed a single graph in the panel, right-click on the graph and choose Export Graph Data to Spreadsheet.
- If you displayed multiple graphs in the panel, right-click on the panel and choose Export All Graph Data to Spreadsheet.
In the case of Microsoft Excel, the program launches and displays the data automatically. Other programs will launch, but you may need to import the data manually.