![]() Previous |
![]() Next |
The EXPORT (to spreadsheet) command copies an Oracle OLAP worksheet object that you have created to a spreadsheet file and automatically translate it into the appropriate format. An analytic worksheet's dimensions form the columns and rows of the spreadsheet file. The current status of these dimensions determines which part of a worksheet is exported.
You can also export an analytic worksheet to an EIF file as described in EXPORT (EIF). EXPORT (to spreadsheet) is commonly used to copy part of your Oracle OLAP workspace into a file that can be read by other software, such as Lotus 1-2-3, or Symphony.
Syntax
EXPORT worksheetname TO {WKS|WK1|WRK|WR1|DIF} FILE file-name -
[STATRANK] [NOREWRITE|REWRITE] [NLS_CHARSET charset-exp]
Parameters
An Oracle OLAP worksheet object that you have created. In any one EXPORT (to spreadsheet) command, you can export only one worksheetname to one spreadsheet file.
Indicates that you want to export an Oracle OLAP worksheet to a 1-2-3 file, version 1.
Indicates that you want to export an Oracle OLAP worksheet to a 1-2-3 file, version 2.
Indicates that you want to export an Oracle OLAP worksheet to a Symphony file, version 1.0.
Indicates that you want to export an Oracle OLAP worksheet to a Symphony file, version 1.1.
Indicates that you want to export an Oracle OLAP worksheet to a data interchange format file.
FILE specifies the file that you are creating. For file-name, specify a text expression that is the name of the file. Unless the file is in the current directory, you must include the name of the directory object in the name of the file.
Note: Directory objects are defined in the database, and they control access to directories and file in those directories. You can use the CDA command to identify and specify a current directory object. Contact your Oracle DBA for access rights to a directory object where your database user name can read and write files. |
Specifies that the row and column numbers exported with worksheet data should be the current status rankings of the WKSROW
and WKSCOL
dimensions.
(Default) Specifies that Oracle OLAP does not overwrite the target file when it already exists, but instead displays an error.
Specifies that Oracle OLAP overwrites the target file when it already exists.
Specifies the character set that Oracle OLAP uses when exporting text data to the worksheet file specified by file-name which allows Oracle OLAP to convert the data accurately into that character set.
For information about the character sets that you can specify, see Oracle Database Globalization Support Guide.
This argument must be the last one specified. When this argument is omitted, then Oracle OLAP exports the data in the database character set, which is recorded in the NLS_LANG option.
Examples