Reading excel files and placing the data into a .csv file

[kwood30]

Hi,

I am using c# and I am trying to read excel files, one row at a time, determining if the row is blank, a title or general data the returning it to a csv file. I have outlined code that I have been writing but I don't think I am quite there yet. I am also trying to check blank rows a number of times before finishing or/and throwing exceptions if incorrect data or empty file. I still think I have more to do, but if anyone can help, it would be appreciated.



Records = openExcelFile
List<csv> csv

Foreach (record in records)
{

rowType = ValiateRow(record);

switch (rowTYpe)
{
Case RowType.Header:
Continue;
Case RowType.Blank:
blankRows++;
if (blankRows > maxBLankRows)
return;
else
continue;
Case RowType.Valid:
CSV csv = ConvertTOCsv(record)
If (daf!= null)
Daff.add(csv);
Continue;
} // End switch

} // Foreach record

[Deadweight]

(Admin) - Think this should belong in the 'Other' section. It is C# and not ASP. Can be wrong tho.