void dd()
{	
	ASCIMP	ai;
	string strFile = GetOpenBox("*.txt");
	if(strFile.IsEmpty())
		return;// user cancel
	
	if(AscImpReadFileStruct(strFile, &ai)==0)
	{
		ai.iRenameCols =1; // use 1st line of header block to rename col
		ai.iLabels = 3;    // header block has 3 lines
		ai.iMaxLabels = 1; // comments has only one line
		ai.nUnits=2;       // use 2nd line of header block to set Units
		
		ASCIMPRESULT air;
		Worksheet wks;
		wks.Create();
		int nRet =  wks.ImportASCII(strFile, ai, &air);
		out_int("nRet = ", nRet);
	}
	else
		out_str("failed to read ascii file");
}

 
// This example to show how to set each sub headers to specified column label including uer defined parameter labels
void Datasheet_ImportASCII_Ex3()
{
	ASCIMP	ai;
	string 	strFile = GetOpenBox("*.dat"); // or "*.txt"
	if(strFile.IsEmpty())
		return;// user cancel
	
	if(AscImpReadFileStruct(strFile, &ai)==0)
	{
		ai.iAutoSubHeaderLines = 0; //set auto detected to false since will set sub header to col label by below codes
		
		ai.iSubHeaderLines = 4; // 1. LongName 2. Units	3. Expanded Discription(User defined)	4. Type Indication(User defined)
		
		// Notice when iAutoSubHeaderLines is 0, the index of ai.nLongName, ai.nUnits and ai.nFirstUserParams are begin from Main Header
		ai.nLongNames = ai.iHeaderLines; 
		ai.nUnits = ai.iHeaderLines + 1;  
		ai.nFirstUserParams = ai.iHeaderLines + 2;
		ai.nNumUserParams = 2;
		
		ai.iMaxLabels = 0; // Not set any header line to Comments label		
		
		Worksheet wks;
		wks.Create();
		if(0 == wks.ImportASCII(strFile, ai))
		{
			// Set user parameter labels to specified names
			Grid grid;
			grid.Attach(wks);
			vector<string> vsUserLabels = {"Expanded Discription", "Type Indication"};
			grid.SetUserDefinedLabelNames(vsUserLabels);
			
			wks.AutoSize(); // to resize worksheet. This method is very useful when data/text is longer than the width of cell
		}
	}
	else
		out_str("failed to read ascii file");
}

#include <..\Originlab\okThemeID.h>
TreeNode find_style_nodes_by_name(TreeNode trRoot, LPCSTR lpcszName)
{
	TreeNode trProp;
	TreeNode trNameStyles;
	bool bRet = octree_theme_tree_get_node_by_id(&trNameStyles, &trRoot, OTID_NAMESTYLES, 3, true);	
	
	if(trNameStyles)
	{
		foreach(TreeNode trNode in trNameStyles.Children)
		{
			TreeNode trName;
			bRet = octree_theme_tree_get_node_by_id(&trName, &trNode, OTID_NAMESTYLE_NAME, 3, true);
			if(trName && 0 == trName.strVal.CompareNoCase(lpcszName))
			{
				trProp = trName.Parent();
				break;
			}
		}
	}
	return trProp;
}


void test_wks_merge(string strStyleName = "ogUnit", int nMergeFormat = GMC_NONE)
{
	Worksheet wks = Project.ActiveLayer();
	if(!wks)
		return;
	
	Tree tr;
	tr = wks.GetFormat(FPB_ALL, FOB_ALL, true, true);
	TreeNode trUnitFormat = find_style_nodes_by_name(tr, strStyleName); //ogLongName, ogComment, ogUDL(User Defined Labels), ogData(for Data Area) 
	if(trUnitFormat)
	{	
		trUnitFormat.Style.Merge.nVal = nMergeFormat;
		
		if(0 == wks.UpdateThemeIDs(tr.Root, "Error", "Unknown tag")) //no error
		{
			if(wks.ApplyFormat(tr, TRUE, TRUE, TRUE))
				wks.GetPage().Refresh();
		}
	}
}