The Export method can export the control's DATA to a CSV or HTML format. The Export method can export a collection of columns from selected, visible, check or all items. By default, the control export all items, unless there is no filter applied on the control, where only visible items are exported. No visual appearance is saved in CSV format, instead the HTML format includes the visual appearance in CSS style.

The following file samples, shows the format the Export method can export the control's DATA:

• CSV format
• HTML format

The following screen shot shows the control's DATA in CSV format:

The following screen shot shows the control's DATA in HTML format:

The Options parameter consists a list of fields separated by | character, in the following order:

1. The first field could be all, vis, sel or chk, to export all, just visible, selected or checked items. The all option is used, if the field is missing. The all option displays all items, including the hidden or collapsed items. The vis option includes the visible items only, not including the child items of a collapsed item, or not-visible items ( item's height is 0 ). The sel options lists the items being selected. The chk option lists all check and visible items. If chk option is used, the first column in the columns list should indicate the index of the column being queried for a check box state.
2. the second field indicates the column to be exported. All visible columns are exported, if missing. The list of columns is separated by , character, and indicates the index of the column to be shown on the exported data. The first column in the list indicates the column being queried, if the option chk is used. 
3. the third field indicates the character to separate the fields inside each exported line [tab character-if missing]. This field is valid, only when exporting to a CSV format
4. the forth field could be ansi or unicode, which indicates the character-set to save the control's content to Destination. For instance, Export( Destination,"|||unicode" ) saves the control's content to destination in UNICODE format (two-bytes per character ). By default, the Export method creates an ANSI file ( one-byte character )

The Destination parameter indicates the file to be created where exported date should be saved. For instance, Export( "c:\temp\export.html") exports the control's DATA to export.html file in HTML format, or Export( "","sel|0,1|;") returns the cells from columns 0, 1 from the selected items, to a CSV format using the ; character as a field separator.

The "CSV" refers to any file that:

• CSV stands for Comma Separated Value
• is plain text using a character set such as ASCII, Unicode,
• consists of records (typically one record per line),
• with the records divided into fields separated by delimiters (typically a single reserved character such as tab, comma, or semicolon; sometimes the delimiter may include optional spaces),
• where every record has the same sequence of fields

The "HTML" refers to any file that:

• HTML stands for HyperText Markup Language.
• is plain text using a character set such as ASCII, Unicode
• It's the way web pages are encoded to handle things like bold, italics and even color text red.

You can use the Copy/CopyTo to export the control's view to clipboard/EMF/BMP/JPG/PNG/GIF or PDF format.

Currently, the /COM version allows you to use the Export method in window-less mode (no user interface). In order to use the control in window-less mode, after creation of the /COM object it is required to call any of the following methods:

• Import method, loads data from a CSV file or from specified text.
• DataSource property, assigns an ADO/DAO record set to be loaded.
• LoadXML method, loads an XML file previously saved using the SaveXML method.

Any of the following templates creates dynamically the /COM component, and uses the Export method to display the result of imported data:

CreateObject("Exontrol.Pivot")
{
	Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
	PivotRows = "0"
	PivotColumns = "avg(5)"
	print(Export())
}

or:

CreateObject("Exontrol.Pivot")
{
	Dim rs
	rs = CreateObject("ADOR.Recordset")
	{
		' Change the Path to the SAMPLE.MDB if nothing is displayed
		Open("Data","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access2007\sample.accdb", 3, 3 )
	}
	DataSource = rs
	PivotRows = "0"
	PivotColumns = "max(5)"
	print(Export())
}

or:

CreateObject("Exontrol.Pivot")
{
	LoadXML("https://www.exontrol.net/testing.xml")
	PivotRows = "1"
	PivotColumns = "max(6)"
	print(Export())
}

You can use the eXHelper tool to convert any of these templates to your programming languages. For instance, in VB6 the code shows as:

With CreateObject("Exontrol.Pivot")
	.Import "C:\Program Files\Exontrol\ExPivot\Sample\data.txt"
	.PivotRows = "0"
	.PivotColumns = "avg(5)"
	Debug.Print( .Export() )
End With

or in PowerBuilder shows as:

OleObject var_Pivot

var_Pivot = CREATE OLEObject
var_Pivot.ConnectToNewObject("Exontrol.Pivot")
	var_Pivot.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
	var_Pivot.PivotRows = "0"
	var_Pivot.PivotColumns = "avg(5)"
	MessageBox("Information",string( String(var_Pivot.Export()) ))