internal List <string> ExcelReader(string filepath, string filename,
string sheetName, UnifiedCleanser cleanser = UnifiedCleanser.Default, string delimitor = "-!-")
{
var completeFilePath = Path.Combine(filepath, filename);
List <string> readList = new List <string>();
try
{
xlWorkBook = xlApp.Workbooks.Open(completeFilePath);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Sheets.get_Item(sheetName);
xlRange = xlWorkSheet.UsedRange;
int iRowCount = xlRange.Rows.Count; //number of rows present with data
int iColCount = xlRange.Columns.Count; //numberr of colums present with data
// The logic to iterate depends on the scenario,
// it can be either [iRowCount]-Row dependent, or [iColCount]-Column Dependednt
for (int i = 1; i <= iRowCount; i++)
{
var tempString = string.Empty;
for (int k = 1; k <= iColCount; k++)
{
tempString = tempString + Convert.ToString(xlWorkSheet.Cells[i, k].Value2) + delimitor;
}
switch (cleanser)
{
case UnifiedCleanser.QuotesCleanser:
readList.Add(SpecialCharHandler.QuotesCleanser(tempString));
break;
case UnifiedCleanser.EscapeCharCleanser:
readList.Add(SpecialCharHandler.QuotesCleanser(tempString));
break;
default:
readList.Add(tempString);
break;
}
}
ExcelCleanUp();
return(readList);
}
catch (Exception ex)
{
//logging mechanism
Console.WriteLine(ex.Message);
return(null);
}
}
public List <string> ExcelReader(string filepath, string filename,
string sheetName, UnifiedCleanser cleanser = UnifiedCleanser.Default, string delimitor = "-!-")
{
excelReadWrite = new ExcelReadWrite();
return(excelReadWrite.ExcelReader(filepath, filename, sheetName, cleanser, delimitor));
}
