public virtual void ExcelService_AddValidations_LotsOfItems() { var oldNames = new[] { new NamedRange { Name = "testName3", Range = new Range(0, 99, 0, 0, "testName4") } }; var oldValidations = new[] { new DataValidation { Name = "testName3", Type = DataValidationType.Formula, Range = new Range() } }; ExcelService.AddNames(MemoryToDiskObject, _version, oldNames); ExcelService.AddValidations(MemoryToDiskObject, "testSheet5", _version, oldValidations); ExcelService.SaveWorkbook(MemoryToDiskObject, _newFileName); var newWorkbook = ExcelService.ReadWorkbook(_newFileName); var newNames = newWorkbook.Names; var newValidations = newWorkbook.Worksheets.First().Validations; AssertHelper.AreDeeplyEqual(oldNames, newNames); AssertHelper.AreDeeplyEqual(oldValidations, newValidations); }
public void ExcelHelper_ParseRange_Max_Xlsx() { var expected = new Range(2, null, 5, null, "testSheet34"); var actual = ExcelHelper.ParseRange("testSheet34!$F$3:$XFD$1048576", ExcelVersion.Xlsx); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_DetectAllColumns_Xlsx() { var expected = new Range(64, 343, null, null, "testSheet34"); var actual = ExcelHelper.ParseRange("testSheet34!$A$65:$XFD$344", ExcelVersion.Xlsx); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_DetectAllRows_Xlsx() { var expected = new Range(null, null, 2, 7, "testSheet34"); var actual = ExcelHelper.ParseRange("testSheet34!$C1:$H1048576", ExcelVersion.Xlsx); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_NoRows() { var expected = new Range(null, null, 2, 7, "testSheet34"); var actual = ExcelHelper.ParseRange("testSheet34!$C:$H", ExcelVersion.Xls); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_NoColumn() { var expected = new Range(6, 6, null, null); var actual = ExcelHelper.ParseRange("7", ExcelVersion.Xlsx); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_NoRow() { var expected = new Range(null, null, 24, 24); var actual = ExcelHelper.ParseRange("Y", ExcelVersion.Xls); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange_IncludingSheetName() { var expected = new Range(33, 37, 2, 7, "testSheet34"); var actual = ExcelHelper.ParseRange("testSheet34!$C$34:$H$38", ExcelVersion.Xls); AssertHelper.AreDeeplyEqual(expected, actual); }
public virtual void ExcelService_AddValidations_Hack() { ExcelService.AddValidations(MemoryToDiskObject, "testSheet5", _version, _validations); ExcelService.SaveWorkbook(MemoryToDiskObject, _newFileName); var newWorkbook = ExcelService.ReadWorkbook(_newFileName); var newValidations = newWorkbook.Worksheets.First().Validations; AssertHelper.AreDeeplyEqual(_validations, newValidations); }
public void ExcelHelper_ParseRange_SingleCell() { var expected = new Range { RowStart = 33, RowEnd = 33, ColumnStart = 2, ColumnEnd = 2 }; var actual = ExcelHelper.ParseRange("C34", ExcelVersion.Xlsx); AssertHelper.AreDeeplyEqual(expected, actual); }
public void ExcelHelper_ParseRange() { var expected = new Range { RowStart = 33, RowEnd = 37, ColumnStart = 0, ColumnEnd = 7 }; var actual = ExcelHelper.ParseRange("A34:H38", ExcelVersion.Xls); AssertHelper.AreDeeplyEqual(expected, actual); }
public virtual void ExcelService_AddValidations() { var oldValidations = MemoryWorkbook.Worksheets.First().Validations; foreach (var validation in _validations) { oldValidations.Add(validation); } ExcelService.WriteWorkbook(MemoryWorkbook, _version, _newFileName); var newWorkbook = ExcelService.ReadWorkbook(_newFileName); var newValidations = newWorkbook.Worksheets.First().Validations; AssertHelper.AreDeeplyEqual(oldValidations, newValidations); }