ExportData Method

Exports the data in the Enhanced Chart in text format to the clipboard or to a file.

Syntax

object.ExportData bstrDest, enuExportStyle, [blnIncludingLabels], [blnUseMaximumPrecision]]

Properties

The ExportData method syntax has these parts:

Part

Description

object

An object expression that evaluates to an object in the Applies To list.

bstrDest

String. Empty for the system clipboard. To export to a file, use the full path.

enuExportstyle

Enum/Long. Specifies various styles with which the data is exported. It can be either of type enumDataExportStyle or a corresponding numerical value, as follows:
DataExportStyle_CommaSeparatedList (0): a comma separated list of data.
DataExportStyle_TabSeparatedList (1): a tab separated list of data.
DataExportStyle_HorizontalTable (2): a table in which each row has data for one dataset.
DataExportStyle_VerticalTable (3): a table in which each column has data for one dataset.

NOTE: In order to use the enumImageFormat enumerations, you must add the type library file for object to the references of the VBA project. If the type library file is not included in the references, then only numerical values are accepted. The type libraries for objects in the Applied To list are as follows:

Object

Reference

Type Library File Name

HistogramChart

iFix 2D Histogram Chart Object v1.0 Type Library

Fix2DHistogramChartDll.tlb

LineChart

iFix 2D Line Chart Object v1.0 Type Library

Fix2DLineChartDll.tlb

SPCBarChart

iFix 2D SPC Bar Chart Object v1.0 Type Library

Fix2DSPCBarChartDll.tlb

XYChart

iFix 2D XY Chart Object v1.0 Type Library

Fix2DXYChartDll.tlb

blnIncludingLabels

Boolean. Specifies whether X-axis and Y-axis labels will be exported along with data. Defaults to True if unspecified.

blnUseMaximumPrecision

Boolean. Specifies whether the maximum precision or the current precision should be used. Defaults to False (current precision) if unspecified.

 

Example

Applies To