Exporting Worksheets and Matrices
Origin worksheet data can be exported to the following three formats: ASCII, NI TDM (TDM, TDMS), Sound (WAV). And Origin worksheet can be exported as multi-page PDF file and image file.
Origin matrix data can be exported as the following two formats: ASCII and Image.
Exporting worksheet data as ASCII file
The ASCII exportation is limited to data-only worksheets. Complex documents containing embedded information, such as report sheets, worksheets with embedded or linked graphs (including sparklines), cannot be fully exported to ASCII files. If the worksheet data to be exported has embedded images and graphs, those images and graphs will be ignored during exporting.
To export worksheet data as ASCII file:
- With the worksheet active, select Origin main menu File: Export: ASCII... to bring up the expASC dialog box.
- Specify the options for file type, path, separator, header, etc. in the dialog and click the OK button.
Key options for exporting worksheet data as ASCII file:
- Support DAT, TXT and CSV file types. If CSV is selected, quotes are inserted, as needed, to protect cell contents.
- Support exportation of selected data only. Note that selections may be non-contiguous.
- Support a user-specified data separators (not available for the CSV file type).
- Support exportation of header information.
- Support full numeric precision and missing values.
Exporting worksheet data as National Instruments TDM file
Export worksheet data as National Instrument TDM file. This exportation is limited to data-only worksheets.
To export worksheet data as National Instruments TDM file:
- With the worksheet active, select File: Export: NI TDM (TDM, TDMS)... from the Origin main menu to bring up the expNITDM dialog box.
- Specify the file name and other options in the dialog. Then click the OK button.
Exporting worksheet data as Microsoft PCM wave file
To export worksheet data as Microsoft PCM wave file:
- With the worksheet active, select File: Export: Sound (WAV)... from the Origin main menu to bring up the expWAV dialog box.
- Specify the parameters in the dialog and click the OK button.
Key options for exporting worksheet data as wave file:
- Support two channel modes: Mono and Stereo.
- Support left channel and right channel when channel mode is Stereo.
- Support partial exportation.
Exporting worksheets as PDF files
Worksheets, including those that contain images or embedded/linked graphs, can be exported as PDF files.
|
Notes:
- Report sheets cannot be exported to PDF files.
- If a worksheet is too large, it will be exported to multiple pages in a single PDF file.
|
To export worksheet as a PDF file:
- With the worksheet active, select File: Export: As Multipage PDF File... from the Origin main menu to bring up the expPDFw dialog box.
- Specify the exporting worksheet(s), file name, path and other settings. And then click the OK button.
Key options for exporting worksheet as multi-page PDF file:
- Support multi-worksheet exportation. Each worksheet will be exported as one PDF file.
- Support user-defined PDF settings, such as color translation, line mode, fill mode, data compression, fonts, cover page, etc..
- Support user-defined page settings, such as grids, header, footer, background color, frame, margin, etc..
Exporting worksheet as image file
Those worksheets, including worksheets containing images or embedded/linked graphs but not Origin report sheets, can be exported as an image file. The image types are including AI, BMP, CGM, DXF, EMF, EPS, GIF, JPG, PCX, PDF, PNG, PSD, TGA, TIF, WMF.
To export worksheet as image file:
- With the worksheet active, select File: Export: As Image File... from the Origin main menu to bring up the expWks dialog box.
- Specify the exporting worksheet(s), file name, path and other settings. And then click the OK button.
Key options for exporting worksheet as image file:
- Support multiple worksheets exportation. Each worksheet is exported as one image.
- Provide export settings such as export area, image size, etc..
Exporting matrix data as ASCII file
The data stored in a matrix object can be exported as an ASCII file.
To export matrix data as ASCII file:
- With the matrix active, select File: Export: ASCII... from the Origin main menu to bring up the expMatASC dialog box.
- Specify the options for file type, path, separator, etc. in the dialog and click the OK button.
Key options for exporting matrix data as ASCII file:
- Support DAT, TXT and CSV file types. If CSV is selected, quotes are inserted, as needed, to protect cell contents.
- Support a user-specified data separators (not available for the CSV file type).
- Support full numeric precision, missing values and XY coordinates.
Exporting matrix object as image file
The matrix object of any data type can be exported as an image file. The data type might be converted to another data type according to the settings. The image types are including BMP, GIF, JPG, PCX, PNG, PSD, TGA and TIF.
To export matrix object as image file:
- With the matrix active, select File: Export: Image... from the Origin main menu to bring up the expImage dialog box.
- Specify the image type, name, DPI resolution, color depth, etc.. And then click the OK button.