void ImportFolder()
{
	string strPath = "C:\\test\\";
	StringArray saFiles;
	FindFiles(saFiles,strPath,"asc");
	
	for(int i=0;i<saFiles.GetSize();i++)
		ReadASCII(strPath + saFiles[i], i);

}

void ReadASCII(string strFile, int iFileNum)
{
	ASCIMP ascimp;
	if(AscImpReadFileStruct(strFile,&ascimp)!=0)
	{
		out_str("cannot read " + strFile);
		return;

	}
	// Set import mode to append cols so that data from 
	// each file is added to new columns
	// Constants are defined in OC_types.h, where the ASCIMP struct is also defined
	// iMode is the import mode which is being set to "append columns" here
	ascimp.iMode = ASCIMP_MODE_APPEND_COLS;

	// If file being imported is 2nd file or later, also set partial import so that
	// only the 2nd (Y) column is imported
	if( iFileNum > 0 )
	{
		ascimp.iPartial = ASCIMP_PARTIAL_YES;
		ascimp.iPartialC1 = 1;
		ascimp.iPartialC2 = 1;
	}

	Worksheet wks = Project.ActiveLayer();
	// no need to add columns manually - import will take care of it int colnum = wks.AddCol();
	if( !wks )
	{
		printf("Active layer is not a worksheet!\n");
		return;
	}
	wks.ImportASCII(strFile, ascimp);
} 

void DeleteAlternateColumns(string strWksName, int StartNum)
{
Worksheet Wks;
if(Wks.Attach(strWksName)
{
uint NumCols=Wks.GetNumCols();
if(StartNum<0 || StartNum>NumCols) return;
uint col=StartNum;
do
{
Wks.DeleteCol(col);
col++;
} while (col<=Wks.GetNumCols());
}
}
 

void importfolder()
{
	string strPath = "C:\\"; // change to your data path

	StringArray saFiles;
	FindFiles(saFiles, strPath, "asc");
	if( saFiles.GetSize() < 1 )
		return;

	ASCIMP ascimp;
	AscImpReadFileStruct(strPath + saFiles[0], &ascimp);

	Worksheet wks = Project.ActiveLayer();

	wks.ImportASCII(strPath + saFiles[0], ascimp);

	ascimp.iMode = ASCIMP_MODE_APPEND_COLS;
	ascimp.iPartial = ASCIMP_PARTIAL_YES;
	ascimp.iPartialC1 = 1;
	ascimp.iPartialC2 = 1;

	for(int i = 1; i < saFiles.GetSize(); i++ )
		wks.ImportASCII(strPath + saFiles[i], ascimp);
}

void test_impfolder()
{
	string strPath = "C:\\"; // change to your data path

	StringArray saFiles;
	FindFiles(saFiles, strPath, "asc");
	if( saFiles.GetSize() < 1 )
		return;

	sort_filenames(saFiles); //--------- sort file names

	ASCIMP ascimp;
	AscImpReadFileStruct(strPath + saFiles[0], &ascimp);

	Worksheet wks = Project.ActiveLayer();

	wks.ImportASCII(strPath + saFiles[0], ascimp);

	ascimp.iMode = ASCIMP_MODE_APPEND_COLS;
	ascimp.iPartial = ASCIMP_PARTIAL_YES;
	ascimp.iPartialC1 = 1;
	ascimp.iPartialC2 = 1;

	for(int i = 1; i < saFiles.GetSize(); i++ )
		wks.ImportASCII(strPath + saFiles[i], ascimp);
}

static int get_filename_num(string& strFileName)
{
	int i = strFileName.ReverseFind('#');
	if( i < 0 )
		return -1; // no number
	return atoi(strFileName.Mid(i + 1));
}

static void sort_filenames(StringArray& saFiles)
{
	string strTmp;
	
	for( int i = 0; i < saFiles.GetSize() - 1; i++ )
	{
		for( int j = i + 1; j < saFiles.GetSize(); j++ )
		{
			if( get_filename_num(saFiles[i]) > get_filename_num(saFiles[j]) )
			{
				strTmp = saFiles[i];
				saFiles[i] = saFiles[j];
				saFiles[j] = strTmp;
			}
		}
	}
}

void DoStuff()
{
	vector<string> vctString;
	vctString.RemoveAll();
	// Create a Numerically  indexed string array of MyFile_250, Myfile_249, MyFile_248 ..... MyFile_1
	// sorted in reverse order ...
	for(int i=250;i>=1;i--)
	{
		string strTemp="MyFile_"+("%d",i);
		vctString.Add(strTemp);
	}
	if(SortByIndices(vctString)==true)
	{
		// The Array FilesNames should now be sorted in ascending order and one can 
		// process the Contents in order with 
		for(i=0;i<vctString.GetSize();i++)
		{
			out_str(vctString[i]);
		}
	}
}


bool SortByIndices(vector<string> &vctMyNames)
{
	WorksheetPage wP;
	// Create a temporary WorkBook
	if(wP.Create("origin.otw",CREATE_TEMP)==true)
	{
		Worksheet Wks(wP.Layers(0));
		if(Wks.IsValid()==true)
		{
			Wks.SetSize(vctMyNames.GetSize(),2);
			Column wCol1(Wks,0);
			Column wCol2(Wks,1);
			if(wCol1.IsValid()==false || wCol2.IsValid()==false)
			{
				return (false);
			}
			// Set Column 1 as numeric and Column 2 as Text ...
			if(wCol1.SetFormat(OKCOLTYPE_NUMERIC)==false || wCol2.SetFormat(OKCOLTYPE_TEXT)==false)
			{
				return (false);
			}
			// Place the string Array into Column 2;
			if(wCol2.PutStringArray(vctMyNames)==false)
			{
				return (false);
			}
			vector<int> vctIndices;
			vctIndices.RemoveAll();
			// Parse the String Array to get the numerical Indices of the file names
			// and store these indices in a array vctIndices
			for(int i=0;i<vctMyNames.GetSize();i++)
			{
				string strTemp1=vctMyNames[i];
				string strIndex=strTemp1.GetToken(1,'_');
				vctIndices.Add(atoi(strIndex));
			}
			Dataset dS;
			if(dS.Attach(Wks,0)==false)
			{
				return (false);
			}
			// Place the contents of the array vctIndices int column 1 of the Worksheet Wks
			dS.SetSize(vctIndices.GetSize());
			dS=vctIndices;
			// Sort the Worksheet as per the contnets of Column 1 in ascending order;
			if(Wks.Sort()==false)
			{
				return (false);
			}
			// Copy the sorted array back to vctMyNames
			if(wCol2.GetStringArray(vctMyNames)==true)
			{
				return (true);
			}
		}
	}
	return(false);;
}