_ShowExportSettings, CopyExternalMetadata, Export, ExportLoadSetting, ExportSaveAndCloseExcelFile, ExportSaveSetting, ExportSetExcelPos, ExportSetName, ExportSettings, ImageExportAllAvailableInfo, SetAlignmentPoints

CopyExternalMetadata

Description 

 CopyExternalMetadata(
   char *SrcFileName,
   char *DstFileName
);

Copies third party custom metadata from one nd2 file to another.

Parameters

char *SrcFileName

Path to the source file.

char *DstFileName

Path to the destination file.

Export

Description 

 Export(
   char *ExportName,
   int  ExportId
);

This function exports the selected data table to an external file according to the export settings.

Parameters

char *ExportName

List of code names can be displayed after clicking the red dot button within the Execute Command window while defining parameters of the function.

ROIStatistics	ROI Statistics
ObjectCount	Object Count
ManualMeasurement	Annotations and Measurements
AutoMeasResults	Automated Measurement Results
TimeMeasurement	Time Measurement
Colocalization	Colocalization
TimeSeries	Time Series
EDF Z-Profile	EDF Z-Profile Data
PixelClassifier	Pixel Classifier Data
JobView	Job View Data

int ExportId

Insert the ID number of the export which determines the table to be exported. The IDs can be found within the Edit > Options > Data Export window.

See Also 
ExportSettings

ImageExportAllAvailableInfo

Description 

 ImageExportAllAvailableInfo(
   int  Type,
   char *Filename
);

Exports the data of all tabs of the Image Properties dialog to the specified file.

Parameters

int Type

Exporting format.

0	Export to MS Excel
1	Export to a .txt file
2	Export to Clipboard

char *Filename

The path and the name of the file.

ExportLoadSetting

Description 

 ExportLoadSetting(
   char  ExportSettingFileName
);

This function loads previously saved export settings.

Parameters

char ExportSettingFileName

Define the complete path (including the extension) to a file which contains export settings.

ExportSaveAndCloseExcelFile

Description 

 ExportSaveAndCloseExcelFile(
   char *ExportFileName
);

This function saves data exported to the MS Excel application as a new file with specified name. In case the file already exists and is currently opened, data are saved into this file which is subsequently closed.

Parameters

char *ExportFileName

Name of the file.

ExportSaveSetting

Description 

 ExportSaveSetting(
   char  ExportSettingFileName
);

This function saves export settings to a file.

Parameters

char ExportSettingFileName

Define the complete path (including the extension) to a file which contains export settings.

ExportSetExcelPos

Description 

 ExportSetExcelPos(
   int  ExportCol,
   int  ExportRow
);

This function marks the first cell in the MS Excel application which will hold the exported data.

Parameters

int ExportCol

Index of a column in the table.

int ExportRow

Index of a row in the table.

ExportSetName

Description 

 ExportSetName(
   char  ExportName,
   int  ExportId,
   char  ExportSheetName
);

This function sets the data export options.

Parameters

char ExportName

Name of a table you would like to modify.

int ExportId

Export ID

1	Length
2	Area
3	Radius
4	SemiAxes
5	Angle
6	Length3D
7	Counts
8	Taxonomy

char ExportSheetName

Name of a sheet or a txt file to which the data are exported.

ExportSettings

Description 

 ExportSettings(
   int  ExportFormat,
   char *ExportPath,
   int  ExportAppend,
   int  ExportHeader,
   int  ExportActivate,
   int  ExportInsertEmptyLines
);

This function determines the global export settings for the whole application.

Parameters

int ExportFormat

Select whether to export to MS Excel, text file or to clipboard.

0	Export to MS Excel.
1	Export to a text file.
2	Export to clipboard.

char *ExportPath

Path to the file to be filled with the data being exported. If the destination is MS Excel and this parameter is left empty, the currently opened MS Excel file will be used or a new one will be created.

int ExportAppend

Append the data to the file or overwrite them on each export?

0	Overwrite the data each time an export is performed
1	Append to the existing data.

int ExportHeader

Export the table column headers? When the data are being appended, this parameter is ignored and the column headers are exported automatically.

int ExportActivate

0	Do not open the file, just write the data in it.
1	Open the file in a default application (MS Excel or a text editor)

int ExportInsertEmptyLines

Allow insertion of empty lines in the exported data?

Example 21. Correct exporting to MS Excel

ExportSettings(0, "C:\Images\ObjectCount_01.xls", 1, 1, 0, 1);
Export("ObjectCount", 1);
Excel_Save();
Excel_Close();

See Also 
Export

SetAlignmentPoints

Description 

 SetAlignmentPoints(
   int  PointsNumber,
   int *SeqIndices,
   int *pPosX,
   int *pPosY,
   double *pdPosX,
   double *pdPosY
);

Significant points in the sample are marked using this function. Once the sample is moved onto a different microscope system, precise calibration of the stage can be made using these points.

Parameters

int PointsNumber

Number of points in the array.

int *SeqIndices

Position of the frame in the ND2 document.

int *pPosX

Pointer to the X coordinate.

int *pPosY

Pointer to the Y coordinate.

double *pdPosX

Stage X position [µm].

double *pdPosY

Stage Y position [µm].

_ShowExportSettings

Description 

 _ShowExportSettings(
   char  ExportName,
   int  ExportId
);

This function opens the Data Export tab in the Options dialog window.

Parameters

char ExportName

Name of a table you would like to modify.

int ExportId

Export ID

1	Length
2	Area
3	Radius
4	SemiAxes
5	Angle
6	Length3D
7	Counts
8	Taxonomy