NC_ExportDataΒΆ

NC_ExportData converts UniPlot data files (.nc, .nc2) into another data format.

svExportNames = NC_ExportData(svNCNames, ssType, ssOutDir, svSep, ssMissing, bOverwrite)
svExportNames = NC_ExportData(ncid, ssType, ssOutDir, svSep, ssMissing, bOverwrite)
svExportNames = NC_ExportData(svNCNames, ssType, obj)
svExportNames = NC_ExportData(ncid, ssType, obj)

Return Value

Is a string vector of the exported files. In case of an error, the function returns an empty string.

Parameters

svNCNames

svNCNames is a string vector with NC data file names. The file name will be used to create the export file name. The file name extention depends on the export type.

ncid

ncid is a vector of ncids returned by nc_create or nc_open.

ssType

ssType is a scalar string with a value from the first column of the following table:

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 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 format.

NC-UP

.nc2

UniPlot format.

MATLAB

.mat

MATLAB Format 5

MDF4

.mf4

ASAM MDF4 format

obj

obj is a replacement for the parameters 3, 4, 5 and 6. obj is an object with the following elements:

Element

Description

obj.ssFieldSeparator

Field separator, e. g. semicolon (;). Default value is the country setting.

obj.ssDecimalSeparator

Decimal separator: . or ,. Default value is the country setting.

obj.ssMissing

Text for invalid values, Default value is "*****".

obj.bOverwriteFile

TRUE (1): Target file will be overwritten. Default value is TRUE (1).

obj.svChannel

If set to an empty string "" all channels will be exported; or a list with channel names. Channels, missing in the nc file will be created in the export file with missing values. Default value is an empty string ("").

obj.ssOutDir

Export directory. If set to an empty string, the export file will be saved in the directory of the nc file. Default value is an empty string ("").

If an element is not set in the object, the default value will be used.

ssOutDir

Is the name of a output directory or an empty string. If ssOutDir is an empty string, the exported files will be saved in the directory of the NC source files.

svSep

Is a string vector with two elements. The first element is the field separator and the second element is the decimal separator: Examples: [";", ","] or ["\t", "."] or [",", "."]. Only used with CSV export.

ssMissing

Is a text to display invalid numbers. Only used with CSV and Excel export.

bOverwrite

If bOverwrite is TRUE (1), existing export files will be replaced.

Example

def MyCSVExport()
{
   svFiles = GetOpenFileName("", "Data Files (*.nc;*.nc2)|*.nc;*nc2|", 1, 1);
   if (svFiles[1] == "") {
      return;
   }
   obj = [.]
   ssType = "XLSX";
   obj.ssOutDir = "d:/";
   obj.ssMissing = "";
   obj.ssFieldSeparator = ",";
   obj.ssDecimalSeparator = ".";
   obj.bOverwrite = TRUE;
   obj.svChannel = ["Lst", "EngPwr", "Speed", "PME"];

   ShowWaitCursor(TRUE);
   svReturn = NC_ExportData(svFiles, ssType, obj);
   ShowWaitCursor(FALSE);
   return svReturn;
}

History

Version

Description

R2014.3

Export format XLSX-NOHEADER added.

5.14.7

New parameter obj.

5.9.3

New.

id-883032