/// <summary>
/// parse the csv file
/// </summary>
/// <returns></returns>
private Boolean parseCsv()
{
Hashtable fContent = this.fileReader.getContent();
if (this.fileReader.lineCount > 0 && this.fileReader.maxCellCount > 0)
{
this.columnCount = this.fileReader.maxCellCount;
List <string> header = (List <string>)fContent[0];
foreach (string name in header)
{
CsvContent head = new CsvContent(name, 0, 0);
this.Header.Add(head);
}
int rowNr = 0;
for (int i = 1; i < fContent.Count; i++)
{
int columnNr = 0;
foreach (string cellText in this.fileReader.getContentAtIndex(i))
{
CsvContent row = new CsvContent(cellText, rowNr, columnNr);
this.tableMatrix.Add(this.getMatrixKey(rowNr, columnNr), row);
columnNr++;
}
rowNr++;
this.rowCount = i;
}
return(true);
}
return(false);
}
private ListView getListViewFromCsv(CsvReader csv)
{
ListView tmpList = new ListView();
List <string> header = csv.getHeader();
foreach (string headText in header)
{
tmpList.Columns.Add(headText);
}
int rowCnt = csv.getRowCount();
int colCnt = csv.getColumnCount();
for (int getRow = 0; getRow <= rowCnt; getRow++)
{
ListViewItem addThis = new ListViewItem();
for (int getCol = 0; getCol <= colCnt; getCol++)
{
CsvContent getData = csv.getContent(getRow, getCol);
string addval = "";
if (getData != null)
{
addval = getData.Text;
}
if (getCol == 0)
{
addThis.Text = addval;
}
else
{
addThis.SubItems.Add(addval);
}
}
tmpList.Items.Add(addThis);
}
return(tmpList);
}