/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"unique(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"sumN","sum","sumN","Count-positive")->PutFormatValue(L"value < 0 ? value : 0");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sumN(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"sumN","dbl(pvalue) + (dbl(value) < 0 ? dbl(value) : 0)","sumN","Count-positive");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sumN(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"countP","sum","countP","Count-positive")->PutFormatValue(L"value > 0 ? 1 : 0");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"countP(5),count(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"countP","dbl(pvalue) + (dbl(value) > 0 ? 1 : 0)","countP","Count-positive");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"countP(5),count(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"uniqueEq","pvalue + ((pvalue contains (';' + value + `;`)) ? `` : (';' + value + `;`))","uniqueEq","uniqueEq")->PutFormatResult(L"(value count `;`)/2");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"unique(5),uniqueEq(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"avgEq","dbl(pvalue) + dbl(value)","avgEq","avgEq")->PutFormatResult(L"value / vcount");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"avg(5),avgEq(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"countEq","pvalue + 1","countEq","countEq");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"count(5),countEq(5)");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetAggregates()->Add(L"sumEq","dbl(pvalue) + dbl(value)","sumEq","sumEq");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5),sumEq(5)");

// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
void OnViewChangePivot1()
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXGRAPHLib' for the library: 'ExGraph 1.0 Control Library'
		#import <ExGraph.dll>
		using namespace EXGRAPHLib;
	*/
	((EXGRAPHLib::IGraphPtr)(spPivot1->GetCustomView()->GetObject()))->PutAllowStack(VARIANT_FALSE);
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)/12");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
spPivot1->GetCustomView()->PutControlID(L"exontrol.graph");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)/12");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
	var_CustomView->PutLicense(L"XXXXXXXX");
	var_CustomView->PutControlID(L"exontrol.graph");
	/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXGRAPHLib' for the library: 'ExGraph 1.0 Control Library'

	#import <ExGraph.dll>
	using namespace EXGRAPHLib;
*/
	((EXGRAPHLib::IGraphPtr)(var_CustomView->GetObject()))->GetCursor()->PutVisible(VARIANT_FALSE);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutDescription(EXPIVOTLib::exColumnEmptyPivotRows,L"<c>\\");
spPivot1->PutDescription(EXPIVOTLib::exRowEmptyPivotRows,L"Total");
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutPivotColumns(L"sum(5)[content=numeric]");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutDrawGridLines(EXPIVOTLib::exRowLines);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesSolid);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutBackground(EXPIVOTLib::exHSplitBar,RGB(240,240,240));
spPivot1->PutBackground(EXPIVOTLib::exCSplitBar,RGB(240,240,240));
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)/12");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
spPivot1->PutDrawGridLines(EXPIVOTLib::exVLines);
spPivot1->EndUpdate();

// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
void OnViewChangePivot1()
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	OutputDebugStringW( spPivot1->GetCustomView()->GetColumns() );
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumns(L"sum(5)/12");

// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
void OnViewChangePivot1()
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
		OutputDebugStringW( L"Columns" );
		OutputDebugStringW( var_CustomView->GetColumns() );
		OutputDebugStringW( L"Items" );
		OutputDebugStringW( _bstr_t(var_CustomView->GetItems()) );
		OutputDebugStringW( L"Categories" );
		OutputDebugStringW( _bstr_t(var_CustomView->GetCategories()) );
		OutputDebugStringW( L"Series" );
		OutputDebugStringW( _bstr_t(var_CustomView->GetSeries()) );
		OutputDebugStringW( L"Data" );
		OutputDebugStringW( _bstr_t(var_CustomView->GetData()) );
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
	var_CustomView->PutControlID(L"exontrol.graph");
	/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXGRAPHLib' for the library: 'ExGraph 1.0 Control Library'

	#import <ExGraph.dll>
	using namespace EXGRAPHLib;
*/
	((EXGRAPHLib::IGraphPtr)(var_CustomView->GetObject()))->PutForeColor(RGB(128,128,128));
spPivot1->EndUpdate();

// OleEvent event - Occurs whenever the custom view fires an event.
void OnOleEventPivot1(LPDISPATCH   Ev)
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	spPivot1->GetCustomView()->PutVisible(VARIANT_FALSE);
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
spPivot1->GetCustomView()->PutControlID(L"exontrol.graph");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)/12");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
	var_CustomView->PutLicense(L"XXXXXXXX");
	var_CustomView->PutControlID(L"exontrol.graph");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)/12");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
EXPIVOTLib::ICustomViewPtr var_CustomView = spPivot1->GetCustomView();
	var_CustomView->PutControlID(L"exontrol.graph");
	/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXGRAPHLib' for the library: 'ExGraph 1.0 Control Library'

	#import <ExGraph.dll>
	using namespace EXGRAPHLib;
*/
	((EXGRAPHLib::IGraphPtr)(var_CustomView->GetObject()))->PutSerieType(L"line");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarSingleAggregate | EXPIVOTLib::exPivotBarDefault));
spPivot1->PutShowDataOnDblClick(VARIANT_TRUE);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->GetCustomView()->PutControlID(L"exontrol.graph");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotTotals(L"/sum[bold]");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutFormatPivotTotal(L"( iaggregate = 5 ? (ilevel = 0 ? 'Overall amount' : 'Sectional sum') : caggregate )");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarRect(L",,96");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->GetVisualAppearance()->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABRsIQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFICQTIcBhaGIZRiAKCRTDmHwyRCNIwCLD8QxtDqBY4gOZZX") +
"hal4cJTgMaBYi+Pw3DZHcbvBRkewzHQAKgnSjoDhEMg1CTVVYTDKdOSzDyEX7sIAACpOIZQVJVEY1VT8cyxIyEZimSypWqiYJ0Ty6cQwTAIgI");
spPivot1->PutBackground(EXPIVOTLib::exColumnsFloatBackColor,0x1000000);
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->GetVisualAppearance()->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT") +
"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
spPivot1->PutBackground(EXPIVOTLib::exColumnsFloatBackColor,0x1000000);
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->PutBackground(EXPIVOTLib::exColumnsFloatBackColor,RGB(240,240,240));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->GetVisualAppearance()->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT") +
"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
spPivot1->PutBackground(EXPIVOTLib::exColumnsFloatAppearance,0x1000000);
spPivot1->PutBackground(EXPIVOTLib::exColumnsFloatCaptionBackColor,RGB(246,246,246));
spPivot1->PutBackColorHeader(0x1000000);
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelAsChild);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderHeight(24);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotColumnsFloatBarVisible(EXPIVOTLib::exPanelVisible);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0[bold],2");
spPivot1->PutPivotColumns(L"sum(5)[content=currency],sum(5)[content=currency]/12:A");
spPivot1->PutPivotTotals(L"/sum[bold,content=currency]");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->PutShowIdem(L"<fgcolor lightgray>〃");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0[bold],2");
spPivot1->PutPivotColumns(L"sum(5)[content=currency],sum(5)[content=currency]/12:A");
spPivot1->PutPivotTotals(L"/sum[bold,content=currency]");
spPivot1->PutShowBranchRows(EXPIVOTLib::ShowBranchRowsEnum(EXPIVOTLib::exBranchIncludeAggregate | EXPIVOTLib::exBranchRowDivider | EXPIVOTLib::exBranchColumns));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0[bold],2");
spPivot1->PutPivotColumns(L"sum(5)[content=currency],sum(5)[content=currency]/12:A");
spPivot1->PutPivotTotals(L"/sum[bold,content=currency]");
spPivot1->PutShowBranchRows(EXPIVOTLib::ShowBranchRowsEnum(EXPIVOTLib::exBranchIncludeAggregate | EXPIVOTLib::exBranchColumns));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0[bold],2");
spPivot1->PutPivotColumns(L"sum(5)[content=currency],sum(5)[content=currency]/12:A");
spPivot1->PutPivotTotals(L"/sum[bold,content=currency]");
spPivot1->PutShowBranchRows(EXPIVOTLib::exBranchColumns);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->PutRenderType(-1);
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABa8IQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFMbxCKQahLEiTIhGUYJHgmK4tRiAUgxVDkBxrECZYqjcBZO") +
"iwLQ2TxDM7DNKUCBnIoABhGOaYDh+IQNQjUFKwTRFGRxK4EIRKAyTDLQdRyGSMMbjdQpBCbMiMRqhESKRq2UwYRYCFS1NalaztO6BUAvK67YrWez/YBfF+SfwGeqDYRe" +
"WAPfgWERnQrGMLxbD8KwZAKTRjkGJ4XhuB41TbQMqufL9ByXHKSSDpGjaXjeO5VVjYNAvS69UzXNq3bhtQAOXCMEwCgI=");
	var_Appearance->Add(2,"CP:1 -2 0 0 0");
spPivot1->PutHeaderHeight(28);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarButton,0x2000000);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarActive,0x2000001);
spPivot1->PutBackground(EXPIVOTLib::exCursorHoverColumn,-1);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
EXPIVOTLib::IPivotPtr var_Pivot = ::CreateObject(L"Exontrol.Pivot");
	var_Pivot->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
	var_Pivot->PutPivotRows(L"0");
	var_Pivot->PutPivotColumns(L"sum(5)[caption=<fgcolor red><b>Total]");
	_variant_t d = var_Pivot->Export(vtMissing,vtMissing);
spPivot1->Import(d,vtMissing);

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
EXPIVOTLib::IPivotPtr var_Pivot = ::CreateObject(L"Exontrol.Pivot");
	/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'ADODB' for the library: 'Microsoft ActiveX Data Objects 6.1 Library'

	#import <msado15.dll> rename("EOF","REOF")
*/
	ADODB::_RecordsetPtr rs = ::CreateObject(L"ADODB.Recordset");
		ADODB::FieldsPtr var_Fields = rs->GetFields();
			var_Fields->Append(L"Code",ADODB::adBSTR,0,vtMissing,vtMissing);
			var_Fields->Append(L"Customer",ADODB::adBSTR,0,vtMissing,vtMissing);
			var_Fields->Append(L"Sales",ADODB::adDouble,0,vtMissing,vtMissing);
		rs->Open(vtMissing,vtMissing,vtMissing,vtMissing,0);
		rs->AddNew(vtMissing,vtMissing);
		rs->GetFields()->GetItem("Code")->PutValue("M");
		rs->GetFields()->GetItem("Customer")->PutValue("Jhon Doe");
		rs->GetFields()->GetItem("Sales")->PutValue(long(1234));
		rs->Update(vtMissing,vtMissing);
		rs->AddNew(vtMissing,vtMissing);
		rs->GetFields()->GetItem("Code")->PutValue("M");
		rs->GetFields()->GetItem("Customer")->PutValue("Jhon Doe");
		rs->GetFields()->GetItem("Sales")->PutValue(long(4567));
		rs->Update(vtMissing,vtMissing);
		rs->AddNew(vtMissing,vtMissing);
		rs->GetFields()->GetItem("Code")->PutValue("F");
		rs->GetFields()->GetItem("Customer")->PutValue("Jane Doe");
		rs->GetFields()->GetItem("Sales")->PutValue(long(9876));
		rs->Update(vtMissing,vtMissing);
		rs->AddNew(vtMissing,vtMissing);
		rs->GetFields()->GetItem("Code")->PutValue("F");
		rs->GetFields()->GetItem("Customer")->PutValue("Jane Doe");
		rs->GetFields()->GetItem("Sales")->PutValue(long(5432));
		rs->Update(vtMissing,vtMissing);
	var_Pivot->PutDataSource(((ADODB::_RecordsetPtr)(rs)));
	var_Pivot->PutPivotRows(L"1");
	var_Pivot->PutPivotColumns(L"sum(2)");
	_variant_t d = var_Pivot->Export(vtMissing,vtMissing);
spPivot1->Import(d,vtMissing);

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutImageSize(16);
spPivot1->ReplaceIcon(_bstr_t("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+O") +
"kYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==",vtMissing);
spPivot1->ReplaceIcon("C:\\images\\favicon.ico",long(0));
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(4,_bstr_t("gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH") +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" +
"UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" +
"3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" +
"YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" +
"mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" +
"oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" +
"Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" +
"FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==");
spPivot1->PutBackColorHeader(0x4c6c6c6);
spPivot1->PutSelBackColor(0x4000000);
spPivot1->PutSelForeColor(RGB(0,0,1));
spPivot1->PutBackground(EXPIVOTLib::exSelBackColorFilter,spPivot1->GetSelBackColor());
spPivot1->PutBackground(EXPIVOTLib::exSelForeColorFilter,spPivot1->GetSelForeColor());
spPivot1->PutBackground(EXPIVOTLib::exBackColorFilter,spPivot1->GetBackColor());
spPivot1->PutBackground(EXPIVOTLib::exForeColorFilter,spPivot1->GetForeColor());
spPivot1->PutBackground(EXPIVOTLib::exCursorHoverColumn,-1);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarButton,0x4000000);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarActive,0x4010101);
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,0x40000ff);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"12,0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotTotals(L"/sum");
spPivot1->GetDataColumns()->Getitem(long(0))->PutFormatImage(L"1");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutHeaderHeight(24);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)[caption=<fgcolor red><b>Total]");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutHeaderHeight(24);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutBackground(EXPIVOTLib::exColumnIndexColor,RGB(128,128,128));
spPivot1->GetFormatContents()->Add(L"Cptd",L"(%1/%2) format `` replace `.00` with ``",vtMissing)->PutVisible(VARIANT_FALSE);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5),count(0),count(0)[content=Cptd,caption=<b>Computed(=1/2),bold]");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutHeaderHeight(24);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutBackground(EXPIVOTLib::exColumnIndexColor,RGB(255,0,0));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->EndUpdate();

// MouseMove event - Occurs when the user moves the mouse.
void OnMouseMovePivot1(short   Button,short   Shift,long   X,long   Y)
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	spPivot1->ShowToolTip(L"new content","",vtMissing,"+8","+8");
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->PutToolTipMargin(L"16,8");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0[bold]");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->GetDataColumns()->Getitem("Freight")->PutSortType(EXPIVOTLib::SortNumeric);
spPivot1->PutLayout(L"singlesort=\"C1:2\"");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->PutBackground(EXPIVOTLib::exScrollHoverAll,-1);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->PutBackground(EXPIVOTLib::exScrollHoverAll,RGB(1,0,0));
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);

// MouseMove event - Occurs when the user moves the mouse.
void OnMouseMovePivot1(short   Button,short   Shift,long   X,long   Y)
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	spPivot1->ShowToolTip(L"new content","",vtMissing,"+8","+8");
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);

// MouseMove event - Occurs when the user moves the mouse.
void OnMouseMovePivot1(short   Button,short   Shift,long   X,long   Y)
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	spPivot1->ShowToolTip(L"<null>","<null>",vtMissing,"+8","+8");
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'ADODB' for the library: 'Microsoft ActiveX Data Objects 6.1 Library'

	#import <msado15.dll> rename("EOF","REOF")
*/
ADODB::_RecordsetPtr rs = ::CreateObject(L"ADOR.Recordset");
	rs->Open("Data","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.mdb",ADODB::adOpenStatic,ADODB::adLockOptimistic,0);
spPivot1->PutDataSource(((ADODB::_RecordsetPtr)(rs)));

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutImageSize(32);
spPivot1->PutDefaultItemHeight(36);
spPivot1->PutHeaderHeight(spPivot1->GetDefaultItemHeight());
spPivot1->GetFont()->PutSize(_variant_t(long(16)));
spPivot1->GetFilterBarFont()->PutSize(_variant_t(spPivot1->GetFont()->GetSize()));
spPivot1->GetToolTipFont()->PutSize(_variant_t(spPivot1->GetFont()->GetSize()));
spPivot1->PutIndent(26);
spPivot1->Images(_bstr_t("gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOq") +
"NUqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlw" +
"yV21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+C" +
"MPo9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9" +
"FEKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5" +
"y7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIk" +
"FgTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMt" +
"NhCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xi" +
"oW5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X" +
"4VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT" +
"6/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUV" +
"DNKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJy" +
"T8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlf" +
"fEkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC" +
"6I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8R" +
"gH5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVW" +
"RJNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==");
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj") +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDx" +
"RDWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFY" +
"FoFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4U" +
"kmCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqA" +
"ochqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A" +
"0ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh" +
"8CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2" +
"UgJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==");
	var_Appearance->Add(2,_bstr_t("gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj") +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" +
"nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnS" +
"cg1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBp" +
"AoPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaD" +
"RDFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+l" +
"GNAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQB" +
"gk0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwyku" +
"XpMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2C" +
"yA4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8R" +
"pBzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8" +
"TI7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAe" +
"HGFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAu" +
"hoiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwM" +
"sCwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4g" +
"aBEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAg" +
"swOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBt" +
"YQGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGB" +
"hYDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0M" +
"gRBCCQAgQEA==");
	var_Appearance->Add(3,_bstr_t("gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj") +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" +
"nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnS" +
"eQ7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJj" +
"nOIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMa" +
"J9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTG" +
"SUwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4" +
"ymkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgk" +
"XI/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD" +
"6BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BR" +
"AjDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBE" +
"BwpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQ" +
"HoFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgR" +
"hcDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOC" +
"QAA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYj" +
"VHiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4" +
"zxW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBs" +
"H0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=");
	var_Appearance->Add(4,_bstr_t("gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH") +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" +
"UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" +
"3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" +
"YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" +
"mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" +
"oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" +
"Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" +
"FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==");
spPivot1->PutBackColorHeader(0x4c6c6c6);
spPivot1->PutSelBackColor(0x4000000);
spPivot1->PutSelForeColor(RGB(0,0,1));
spPivot1->PutCheckImage(EXPIVOTLib::Unchecked,16777216);
spPivot1->PutCheckImage(EXPIVOTLib::Checked,33554432);
spPivot1->PutCheckImage(EXPIVOTLib::PartialChecked,50331648);
spPivot1->PutBackground(EXPIVOTLib::exSelBackColorFilter,spPivot1->GetSelBackColor());
spPivot1->PutBackground(EXPIVOTLib::exSelForeColorFilter,spPivot1->GetSelForeColor());
spPivot1->PutBackground(EXPIVOTLib::exBackColorFilter,spPivot1->GetBackColor());
spPivot1->PutBackground(EXPIVOTLib::exForeColorFilter,spPivot1->GetForeColor());
spPivot1->PutBackground(EXPIVOTLib::exCursorHoverColumn,-1);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarButton,0x4000000);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarActive,0x4010101);
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,0x40000ff);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"12,0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotTotals(L"/sum");
spPivot1->GetDataColumns()->Getitem(long(0))->PutFormatImage(L"value case (default: -1;'Germany': 1;'USA': 2;'Mexico': 3)");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutImageSize(16);
spPivot1->Images(_bstr_t("gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOq") +
"dSqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVt" +
"tmp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8a" +
"cvQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtT" +
"GsbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgP" +
"nwD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==");
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(4,_bstr_t("gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH") +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" +
"UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" +
"3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" +
"YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" +
"mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" +
"oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" +
"Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" +
"FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==");
spPivot1->PutBackColorHeader(0x4c6c6c6);
spPivot1->PutSelBackColor(0x4000000);
spPivot1->PutSelForeColor(RGB(0,0,1));
spPivot1->PutBackground(EXPIVOTLib::exSelBackColorFilter,spPivot1->GetSelBackColor());
spPivot1->PutBackground(EXPIVOTLib::exSelForeColorFilter,spPivot1->GetSelForeColor());
spPivot1->PutBackground(EXPIVOTLib::exBackColorFilter,spPivot1->GetBackColor());
spPivot1->PutBackground(EXPIVOTLib::exForeColorFilter,spPivot1->GetForeColor());
spPivot1->PutBackground(EXPIVOTLib::exCursorHoverColumn,-1);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarButton,0x4000000);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarActive,0x4010101);
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,0x40000ff);
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutGridLineStyle(EXPIVOTLib::exGridLinesGeometric);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"12,0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotTotals(L"/sum");
spPivot1->GetDataColumns()->Getitem(long(0))->PutFormatImage(L"value case (default: -1;'Germany': 1;'USA': 2;'Mexico': 3)");
spPivot1->EndUpdate();

// Event event - Notifies the application once the control fires an event.
void OnEventPivot1(long   EventID)
{
	/*
		Copy and paste the following directives to your header file as
		it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'
		#import <ExPivot.dll>
		using namespace EXPIVOTLib;
	*/
	EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
	OutputDebugStringW( _bstr_t(spPivot1->GetEventParam(-2)) );
}

EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarAllowFormatConditionalAppearance | EXPIVOTLib::exPivotBarAllowResizeColumns | EXPIVOTLib::exPivotBarAllowUndoRedo | EXPIVOTLib::exPivotBarAllowFormatContent | EXPIVOTLib::exPivotBarAllowFormatAppearance | EXPIVOTLib::exPivotBarAllowValues | EXPIVOTLib::exPivotBarShowTotals | EXPIVOTLib::exPivotBarAutoFit | EXPIVOTLib::exPivotBarSizable | EXPIVOTLib::exPivotBarVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetDataColumns()->Getitem(long(0))->PutFormatImage(L"value case (default: -1;'Germany': 1;'USA': 2;'Mexico': 3)");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
spPivot1->PutHeaderHeight(24);
spPivot1->Import("Item;1;2;3#A;10;20;30#A;20;40;50#A;20;30;20#B;10;10;10#B;20;50;30","str=`'` eor='#' eof=';' hdr=1");
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(1),sum(2),sum(3)");
spPivot1->PutFormatPivotHeader(_bstr_t("(iaggregate ? (proper(aggregate) + ` <off -4>` + (caption case (default:`None`; 1:`Sunday`; 2:`Monday`; 3:`Tuesday`; 4:`Wednesd") +
"ay`; 5:`Thursday`; 6:`Friday`; 7:`Saturday`))  + `</b>`) : caption)");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->AppendData("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetDataColumns()->Getitem(long(0))->PutCaption(L"<b>Nation");
spPivot1->Refresh();
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->AppendData("Def",vtMissing);
spPivot1->AppendData("A",vtMissing);
spPivot1->AppendData("A",vtMissing);
spPivot1->AppendData("A",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"count(0)");
_bstr_t s = spPivot1->GetLayout();
spPivot1->AppendData("B",vtMissing);
spPivot1->AppendData("B",vtMissing);
spPivot1->PutLayout(L"s");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->AppendData("Column",vtMissing);
spPivot1->AppendData("1",vtMissing);
spPivot1->AppendData("2",vtMissing);
spPivot1->AppendData("3",vtMissing);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(2,_bstr_t("gBFLBCJwBAEHhEJAAEhABAoCg6AADACAxRDgMQBQKAAzQFAcDBvBgABoGEZIJhUAIIRZGMIjFDcEwxC6NIpjeIBSDUJYkSZEAyjBI8ExXFqMQCkGKocgONYgQLHcgxe") +
"A0XRYFoYRinWA5PoAMoyTYMdIAnTOM4eU6AATwTSccw0fisAAfeq4Wh+HwIQiUBomGahajkMqDYRVagyCI2a4ZDZCIoVJalLAxCw8KDqGJnMr1R5/MDgOBYogXBqHYhi" +
"OAsdhjSYdBK/WLeHI6Y1GS7MMxzLK8cxVaqfMpoMI4FjuS5NU7TMC0PAXdy3LqvbBsOxbHqma5nVSBcC2ba9cz3PK4ABuW7bM6TRKNYbkOA4LiNQaxVSrNKmIwPI5DJ5" +
"Ml2co1h0d5vBWDJQEkCI7mIJpykyTZblqdhYDyR5TlmX5RBgeI+D4BxLDkO5nlieh5g2FQ5DOZAiDkDASAmYh7l0RxZncPxfhadZkBmH5jvKLhamMcItBYXgoC4B4CBg" +
"FoskEP4hkgdgegcD4zlycA1goAJ5mIc4KjgfJ+D0ToTFGbx4h8Qh2CqDJjEeJg0gyT4DkCYg5kyAhCDeBxjkIQgDHSIgTkIP4NGGFplgGEZkkifhFgSIRHgCXwtAYeQ2" +
"B+DYlGkZgqgsIpnEoJxzmWGRiFqGJhmkBhDAwJBZDIYoZCYSQ+BOFAmBkJZBhKZpJlYHIXCYR4lFuHpnkmdh+h+aAKAaAogF6FhWgOIZogoJh/GuHoTl6DojmkChGhKJ" +
"JpEoVoWiUHAGDCTg6CmSheh6J5qAoTJriiWQUCSb4ploEwpgq4BKjWBomhmc4pAkOpRAQJQBICA==");
	var_Appearance->Add(1,"CP:2 -10 -6 8 8");
spPivot1->PutBackground(EXPIVOTLib::exPivotBarTotal,0x1000000);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(2,_bstr_t("gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN") +
"J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" +
"NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" +
"hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" +
"bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" +
"BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=");
	var_Appearance->Add(1,"CP:2 -8 -4 2 4");
spPivot1->PutHeaderHeight(28);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarButton,0x1fefefe);
spPivot1->PutBackground(EXPIVOTLib::exHeaderFilterBarActive,0x1010101);
spPivot1->PutBackground(EXPIVOTLib::exCursorHoverColumn,-1);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->GetFormatContents()->Add(L"notime",L"value replace `0:00:00` with ``",vtMissing);
spPivot1->PutPivotRows(L"9[content=notime]");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarTop | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
EXPIVOTLib::IPivotPtr var_Pivot = ::CreateObject(L"Exontrol.Pivot");
	var_Pivot->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
	var_Pivot->PutPivotRows(L"0");
	var_Pivot->PutPivotColumns(L"avg(5)");
	OutputDebugStringW( _bstr_t(var_Pivot->Export(vtMissing,vtMissing)) );

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
EXPIVOTLib::IPivotPtr var_Pivot = ::CreateObject(L"Exontrol.Pivot");
	/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'ADODB' for the library: 'Microsoft ActiveX Data Objects 6.1 Library'

	#import <msado15.dll> rename("EOF","REOF")
*/
	ADODB::_RecordsetPtr rs = ::CreateObject(L"ADOR.Recordset");
		rs->Open("Data","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.accdb",ADODB::adOpenStatic,ADODB::adLockOptimistic,0);
	var_Pivot->PutDataSource(((ADODB::_RecordsetPtr)(rs)));
	var_Pivot->PutPivotRows(L"0");
	var_Pivot->PutPivotColumns(L"max(5)");
	OutputDebugStringW( _bstr_t(var_Pivot->Export(vtMissing,vtMissing)) );

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
EXPIVOTLib::IPivotPtr var_Pivot = ::CreateObject(L"Exontrol.Pivot");
	var_Pivot->LoadXML("http://www.exontrol.net/testing.xml");
	var_Pivot->PutPivotRows(L"1");
	var_Pivot->PutPivotColumns(L"max(6)");
	OutputDebugStringW( _bstr_t(var_Pivot->Export(vtMissing,vtMissing)) );

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'ADODB' for the library: 'Microsoft ActiveX Data Objects 6.1 Library'

	#import <msado15.dll> rename("EOF","REOF")
*/
ADODB::_RecordsetPtr rs = ::CreateObject(L"ADODB.Recordset");
	rs->Open("Select * From foxcode.DBF","Provider=vfpoledb;Data Source=C:\\Program Files\\Microsoft Visual FoxPro 9\\",ADODB::adOpenStatic,ADODB::adLockOptimistic,0);
spPivot1->PutDataSource(((ADODB::_RecordsetPtr)(rs)));
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"count(0)[content=numeric],avg(7)[negative,content=numeric]");
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
EXPIVOTLib::IFormatConditionalAppearancesPtr var_FormatConditionalAppearances = spPivot1->GetFormatConditionalAppearances();
	var_FormatConditionalAppearances->Add(L"G1000","> 1000","value > 1000")->PutForeColor(RGB(0,0,255));
	var_FormatConditionalAppearances->Add(L"L1000","< 1000","value < 1000")->PutForeColor(RGB(255,0,0));
	var_FormatConditionalAppearances->Add(L"Zero","zero","value = 0")->PutBackColor(RGB(224,224,224));
EXPIVOTLib::IFormatAppearancesPtr var_FormatAppearances = spPivot1->GetFormatAppearances();
	var_FormatAppearances->Add(L"grayed",vtMissing)->PutForeColor(RGB(128,128,128));
	var_FormatAppearances->Add(L"red",vtMissing)->PutForeColor(RGB(255,0,0));
	var_FormatAppearances->Add(L"green",vtMissing)->PutForeColor(RGB(0,255,0));
	var_FormatAppearances->Add(L"blue",vtMissing)->PutForeColor(RGB(0,0,255));
	var_FormatAppearances->Add(L"bgrayed",vtMissing)->PutBackColor(RGB(128,128,128));
	var_FormatAppearances->Add(L"bred",vtMissing)->PutBackColor(RGB(255,0,0));
	var_FormatAppearances->Add(L"bgreen",vtMissing)->PutBackColor(RGB(0,255,0));
	var_FormatAppearances->Add(L"bblue",vtMissing)->PutBackColor(RGB(0,0,255));
spPivot1->PutPivotRows(L"0[bold],2[grayed]");
spPivot1->PutPivotColumns(L"sum(5)[L1000],sum(5)[G1000]/12:A");
spPivot1->PutPivotTotals(L"sum[bold,content=currency,bgrayed]");
spPivot1->PutAutoDrag(EXPIVOTLib::exAutoDragScroll);
spPivot1->PutBackColorAlternate(RGB(240,240,240));
spPivot1->PutFilterBarPromptType(EXPIVOTLib::exFilterPromptContainsAny);
spPivot1->PutFilterBarPromptPattern(L"France Germany");
spPivot1->EndUpdate();
OutputDebugStringW( _bstr_t(spPivot1->Export("htm",vtMissing)) );

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
EXPIVOTLib::IFormatConditionalAppearancesPtr var_FormatConditionalAppearances = spPivot1->GetFormatConditionalAppearances();
	var_FormatConditionalAppearances->Add(L"G1000","> 1000","value > 1000")->PutForeColor(RGB(0,0,255));
	var_FormatConditionalAppearances->Add(L"L1000","< 1000","value < 1000")->PutForeColor(RGB(255,0,0));
	var_FormatConditionalAppearances->Add(L"Zero","zero","value = 0")->PutBackColor(RGB(224,224,224));
EXPIVOTLib::IFormatAppearancesPtr var_FormatAppearances = spPivot1->GetFormatAppearances();
	var_FormatAppearances->Add(L"grayed",vtMissing)->PutForeColor(RGB(128,128,128));
	var_FormatAppearances->Add(L"red",vtMissing)->PutForeColor(RGB(255,0,0));
	var_FormatAppearances->Add(L"green",vtMissing)->PutForeColor(RGB(0,255,0));
	var_FormatAppearances->Add(L"blue",vtMissing)->PutForeColor(RGB(0,0,255));
	var_FormatAppearances->Add(L"bgrayed",vtMissing)->PutBackColor(RGB(128,128,128));
	var_FormatAppearances->Add(L"bred",vtMissing)->PutBackColor(RGB(255,0,0));
	var_FormatAppearances->Add(L"bgreen",vtMissing)->PutBackColor(RGB(0,255,0));
	var_FormatAppearances->Add(L"bblue",vtMissing)->PutBackColor(RGB(0,0,255));
spPivot1->PutShowBranchRows(EXPIVOTLib::ShowBranchRowsEnum(EXPIVOTLib::exBranchIncludeAggregate | EXPIVOTLib::exBranchTree));
spPivot1->PutPivotRows(L"0[bold],2[grayed]");
spPivot1->PutPivotColumns(L"sum(5)[L1000],sum(5)[G1000]/12:A");
spPivot1->PutPivotTotals(L"/sum[bold,content=currency,bgrayed]");
spPivot1->PutAutoDrag(EXPIVOTLib::exAutoDragScroll);
spPivot1->PutBackColorAlternate(RGB(240,240,240));
spPivot1->PutFilterBarPromptType(EXPIVOTLib::exFilterPromptContainsAny);
spPivot1->PutFilterBarPromptPattern(L"France Germany");
spPivot1->EndUpdate();
_bstr_t sFile = "c:/temp/export.htm";
spPivot1->Export(sFile,"vis");
/*
	Includes the definition for CreateObject function like follows:

	#include <comdef.h>
	IUnknownPtr CreateObject( BSTR Object )
	{
		IUnknownPtr spResult;
		spResult.CreateInstance( Object );
		return spResult;
	};

*/
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'SHDocVw' for the library: 'Microsoft Internet Controls'

	#import <ieframe.dll>
*/
SHDocVw::IWebBrowser2Ptr var_ShellBrowserWindow = ::CreateObject(L"InternetExplorer.Application");
	var_ShellBrowserWindow->Navigate2(sFile,vtMissing,vtMissing,vtMissing,vtMissing);

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5),sum(5)/12:A");
spPivot1->PutPivotTotals(L"sum[bold,content=currency]");
spPivot1->PutAutoDrag(EXPIVOTLib::exAutoDragScroll);
spPivot1->PutBackColorAlternate(RGB(240,240,240));
spPivot1->EndUpdate();
OutputDebugStringW( _bstr_t(spPivot1->Export(vtMissing,vtMissing)) );

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABMsGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwCgkBYJDSMAiiaLETwHFKVRwkWBBWjMAAxDZFcggA") +
"77fwxHaOAghGgobjaPY+UbGERAAKQahLJamablCSqLjCS4kSLHEbQHTcRSzLKQZBBCCSQKkYx0HScRiwPBIbQkIQmbajOaYDCiQ53QLCAYRXS9PwvI7AMBwLA8EwXBo9" +
"DZiIy4WyuGj3R4WchAbIwIxUK6XHhmLjZXg+Bz9T6LQZ0JStEx2SYjAJqOiKU62W9xbAUOxQTpIBJXW7Oc7GTa8dQfPoJaIDLicHgoZ6NLIcOR0abSO42CRrdByfRYMw" +
"visCQKnYOh9i4LwbBINpBHeBxeC6X4TAIEpzkIWgei8L4Qk2boEhWPg9C4SJijIOZ7mEXA/iAX5yBKDx/lmVhEC0Z5ZlKHgGAAYIHkGcQxiCQ5eA4PghAKNgSG0VYXEi" +
"JYFl+QAtiCBpdjcDJkB0IgAiYIgBmIQAWCYCoigYZB4DQYpAjoLh3h6SJFgcOpXlAAQBICA==");
spPivot1->PutBackground(EXPIVOTLib::exPivotBarReload,0x1000000);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotBarVisible(EXPIVOTLib::PivotBarVisibleEnum(EXPIVOTLib::exPivotBarAllowFormatConditionalAppearance | EXPIVOTLib::exPivotBarAllowResizeColumns | EXPIVOTLib::exPivotBarAllowUndoRedo | EXPIVOTLib::exPivotBarAllowFormatContent | EXPIVOTLib::exPivotBarAllowFormatAppearance | EXPIVOTLib::exPivotBarAllowValues | EXPIVOTLib::exPivotBarShowTotals | EXPIVOTLib::exPivotBarAutoFit | EXPIVOTLib::exPivotBarSizable | EXPIVOTLib::exPivotBarVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS") +
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" +
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" +
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" +
"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" +
"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" +
"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=");
spPivot1->PutBackground(EXPIVOTLib::exPivotBarAddNew,0x1000000);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->PutHeaderAppearance(EXPIVOTLib::Etched);
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV") +
"IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" +
"aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" +
"eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" +
"BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" +
"GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=");
	var_Appearance->Add(2,"CP:1 0 -36 0 0");
spPivot1->PutBackground(EXPIVOTLib::exColumnsPositionSign,0x2000000);
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(L"all");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace ") +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(L"allui");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( ava") +
"ilable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with `" +
"` replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount" +
" + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080> ` + value + ` </fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(L"value + ` ` + available");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080>` + value + `</fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) +") +
" ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replac" +
"e `]` with ` </b></bgcolor></fgcolor>`");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::exFilterBarToggle);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080>` + value + `</fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(L"value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::exFilterBarToggle);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutDescription(EXPIVOTLib::exFilterBarAnd,_bstr_t(spPivot1->FormatABC(L"`<fgcolor=808080>` + value + `</fgcolor>`",spPivot1->GetDescription(EXPIVOTLib::exFilterBarAnd),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(L"value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::exFilterBarToggle);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarCaption(L"`<r>` + value");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarShowCloseOnRight | EXPIVOTLib::exFilterBarToggle));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarPrompt(_bstr_t(spPivot1->FormatABC(L"`<b>` + value",spPivot1->GetFilterBarPrompt(),vtMissing,vtMissing)));
spPivot1->PutFilterBarCaption(_bstr_t("`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount ") +
"+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarShowCloseOnRight | EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarCaption(_bstr_t("`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount ") +
"+ 1) + ` result(s)` ) : ``)");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarCaption(L"`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarCaption(L"`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutLinesAtRoot(EXPIVOTLib::exLinesAtRoot);
spPivot1->PutFilterInclude(EXPIVOTLib::exItemsWithChilds);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarCaption(_bstr_t("`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</") +
"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" +
": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" +
"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" +
"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" +
"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" +
" `</fgcolor>`");
spPivot1->PutFilterBarPromptPattern(L"USA");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCaptionVisible | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'stdole' for the library: 'OLE Automation'

	#import <stdole2.tlb>
*/
spPivot1->PutFilterBarFont(IFontDispPtr(((stdole::FontPtr)(spPivot1->GetFont()))));
spPivot1->PutFilterBarCaption(L"`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value");
spPivot1->PutFilterBarPromptPattern(L"USA");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarShowCloseOnRight | EXPIVOTLib::exFilterBarToggle | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->PutFilterBarPrompt(_bstr_t(spPivot1->FormatABC(L"`<r>` + value",spPivot1->GetFilterBarPrompt(),vtMissing,vtMissing)));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
EXPIVOTLib::IAppearancePtr var_Appearance = spPivot1->GetVisualAppearance();
	var_Appearance->Add(1,_bstr_t("gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ") +
"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" +
"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" +
"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" +
"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" +
"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" +
"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" +
"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" +
"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" +
"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" +
"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ");
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarToggle | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,0x1000000);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::exFilterBarPromptVisible);
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,RGB(255,0,0));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::exFilterBarPromptVisible);
spPivot1->PutBackground(EXPIVOTLib::exFooterFilterBarButton,-1);
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarShowCloseIfRequired | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarCaption(L"`<r><fgcolor=808080>` + value");
spPivot1->PutFilterBarPromptPattern(L"USA");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarToggle | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarCaption(L"len(value) ? `filter for: <fgcolor 808080>` + value  : `<fgcolor 808080>no filter`");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarVisible));
spPivot1->EndUpdate();

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->BeginUpdate();
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutFilterBarCaption(L"`<r>` + value");
spPivot1->PutFilterBarPromptVisible(EXPIVOTLib::FilterBarVisibleEnum(EXPIVOTLib::exFilterBarCompact | EXPIVOTLib::exFilterBarSingleLine | EXPIVOTLib::exFilterBarVisible | EXPIVOTLib::exFilterBarPromptVisible));
spPivot1->EndUpdate();