The LoadXML method uses the MSXML ( MSXML.DOMDocument, XML DOM Document ) parser to load XML documents, previously saved using the SaveXML method. The control is emptied when the LoadXML method is called, and so the columns and items collection are emptied before loading the XML document. The DataColumns property accesses the control's Columns collection, so you can rename or specify the column's type once the control's data is loaded. The PivotColumnsFloatBarVisible property specifies whether the Columns collection is displayed to a floating bar, so user can drag and drop columns to the control's pivot bar so it gets data summarized. The ClearData method clears the control's data. Use the DisplayPivotData property to specify the number of rows to be displayed on the control's list.

The control can load data using one 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
• The user can drag and drop any TXT or XML files to the control.

The AppendData method appends data to the control (prevents clearing data already loaded).

The following properties may be used to group and summarize the data, once it is loaded:

• PivotRows property specifies the list of DATA columns that determines the first column in the control's list. In other words, the Group-By columns
• PivotColumns property specifies the  list of DATA columns that determines the rest of the columns to be displayed on the control's list
• PivotTotals property specifies the list of total/sub-total functions to be displayed on the control's list.