/// <summary> /// Constructor that initialize CsvModel /// </summary> /// <param name="sheet">ISheet taken from external library for processing excel</param> public SheetToCsvModel(ISheet sheet) { var internalCsvModel = new CsvModel(); // go through the all rows for (int rownum = 0; rownum <= sheet.LastRowNum; rownum++) { var row = sheet.GetRow(rownum); if (row != null) { internalCsvModel.AddRow(row); } } _csvModel = internalCsvModel; _sheetName = sheet.SheetName; }