.. highlightlang:: us

.. index:: File=>Export Data

.. _fileexport-data:
.. _file-export-data:

File=>Export Data
-----------------

Command to convert netCDF files (.nc) into another format. If the selected
file is not an NC file, it will be converted to an NC file before the dialog
box is displayed.

You will find the command under **File=>Export=>NC-Export**.

.. image:: S:/uniplot-obj/images/file-export-data-en.*

.. us.dlgitem

**Export-Formats**

netCDF files can be converted into the following formats:

.. list-table::
   :header-rows: 1

   * - Type
     - Extension
     - Description
   * - CSV
     - .csv oder .txt
     - Text file without header data with one of the following field  separators (comma, semicolon, Tab)
   * - CSV-UTX
     - .utx
     - Text file with header data in the UTX format
   * - XLS
     - .xls
     - Excel file without header data with a maximum of 16384 rows and  255 channels
   * - XLS-UTX
     - .xls
     - Excel file with header data in the UTX format with a maximum of  16384 rows and 255 channels
   * - XLSX
     - .xlsx
     - Excel format with header data in Excel 2007 format
   * - XLSX-NOHEADER
     - .xlsx
     - Excel format without header data in Excel 2007 format
   * - XLSX-UTX
     - .xlsx
     - Excel format with header data in the UTX format in  Excel 2007 format
   * - TDM
     - .tdm
     - TDM format (National Instruments Format)
   * - NC
     - .nc
     - netCDF file in standard format.
   * - NC-UP
     - .nc
     - netCDF file in UniPlot format (compressed)
   * - MATLAB
     - .mat
     - MATLAB File Format, Version 5.
   * - MDF4
     - .mf4
     - ASAM MDF File Format (Measurement Data Format) Version 4.0.

.. us.dlgitem

**CSV-Text Field separator**

Field and decimal separators:

.. list-table::
   :header-rows: 1

   * - Type
     - Description
   * - Auto
     - Local setting for Field and Decimal separator, e.g. comma and point
   * - Comma/Decimal point
     - 1.0,2.0,3.0,4.0
   * - Semicolon/Decimalcomma
     - 1,0;2,0;3,0;4.0
   * - Tab/Dezimalpunk
     - 1.0<Tab>2.0<tab>3.0<tab>4.0
   * - Tab/Dezimalkomma
     - 1,0<Tab>2,0<Tab>3,0<Tab>4.0

.. us.dlgitem

**Missing-Value-Text**

Text to display invalid values for Text and Excel files.

.. us.dlgitem

**Always over write existing files**

If not checked, a message box will be displayed for each existing file.

.. us.dlgitem

**Open first converted file**

If checked, the first converted file will be opened for the registered file
extension. CSV- and NC files will be opened with UniPlot.

.. us.comment

**Comment**

If a NC file contains more than one data group (channels with different number
of points), UniPlot creates one file for each group. The file name will be
extended with _g1, _g2, etc. For XLS Excel files the number of rows is limited to
16834.

If this limitation is a problem, the data can be exported in the XLSX format.
XLSX files can be opened with Excel 2000 or Excel 2003 using the Microsoft Office
Compatibility Pack.  Up to 65000 rows can be used with this Excel Version.

Link to the Microsoft converter:
(Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File 
Formats)
http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&DisplayLang=en

For XLSX files UniPlot will create a sheet for each group.

The command :ref:`file-export-data` is written in UniScript. the source code can
be found in the file :file:`do_conv.ic`. The :ref:`NC_ExportData` function can be
used to export data in script files.

.. us.history

**History**

.. list-table::
   :header-rows: 1

   * - Version
     - Description
   * - R2014.3
     - Export format XLSX-NOHEADER added.

.. seealso::
   :ref:`file`,
   :ref:`fileimport-options`,
   :ref:`utx-data-file-format`,
   :ref:`utx-data-file-format-specification`,
   :ref:`NC_ExportData`

:sub:`id-151293`