public void TestParseColumnsHeaders() { MockObjectRepository repo = new MockObjectRepository(); BulkCopyController controller = new BulkCopyController(repo); ExcelUpload uploadModel = new ExcelUpload() { ExcelFile = this.exampleContent, FirstRowIsHeader = true }; List <ExcelSheet> sheets = controller.Parse(uploadModel); Assert.IsNotNull(sheets); Assert.AreEqual(2, sheets.Count); var firstSheet = sheets[0]; var secondSheet = sheets[1]; Assert.IsNotNull(firstSheet.Columns); Assert.AreEqual(4, firstSheet.Columns.Count); Assert.AreEqual("A", firstSheet.Columns[0].Letter); Assert.AreEqual("Name", firstSheet.Columns[0].Name); Assert.AreEqual("B", firstSheet.Columns[1].Letter); Assert.AreEqual("OID", firstSheet.Columns[1].Name); Assert.IsNotNull(secondSheet.Columns); Assert.AreEqual(15, secondSheet.Columns.Count); Assert.AreEqual("A", secondSheet.Columns[0].Letter); Assert.AreEqual("Template", secondSheet.Columns[0].Name); Assert.AreEqual("B", secondSheet.Columns[1].Letter); Assert.AreEqual("Number", secondSheet.Columns[1].Name); }
public void TestParseRowsWithHeaders() { MockObjectRepository repo = new MockObjectRepository(); BulkCopyController controller = new BulkCopyController(repo); ExcelUpload uploadModel = new ExcelUpload() { ExcelFile = this.exampleContent, FirstRowIsHeader = true }; List <ExcelSheet> sheets = controller.Parse(uploadModel); Assert.IsNotNull(sheets); Assert.AreEqual(2, sheets.Count); var firstSheet = sheets[0]; Assert.IsNotNull(firstSheet.Rows); Assert.AreEqual(3, firstSheet.Rows.Count); var firstSheetFirstRow = firstSheet.Rows[0]; Assert.IsNotNull(firstSheetFirstRow.Cells); Assert.AreEqual(4, firstSheetFirstRow.Cells.Count); Assert.AreEqual("A", firstSheetFirstRow.Cells[0].Letter); Assert.AreEqual("Template 1", firstSheetFirstRow.Cells[0].Value); Assert.AreEqual("B", firstSheetFirstRow.Cells[1].Letter); Assert.AreEqual("1.2.3.4", firstSheetFirstRow.Cells[1].Value); Assert.AreEqual("B", firstSheetFirstRow.Cells[1].Letter); Assert.AreEqual("1.2.3.4", firstSheetFirstRow.Cells[1].Value); var secondSheet = sheets[1]; }