public void TryGetValue_Enum_BadString() { var ws = new XLWorkbook().AddWorksheet(); Assert.IsFalse(ws.FirstCell().SetValue("ABC").TryGetValue(out NumberStyles value)); Assert.IsFalse(ws.FirstCell().SetValue("ABC").TryGetValue(out NumberStyles? value2)); }
public void InsertData_with_Guids() { var ws = new XLWorkbook().Worksheets.Add("Sheet1"); ws.FirstCell().InsertData(Enumerable.Range(1, 20).Select(i => new { Guid = Guid.NewGuid() })); Assert.AreEqual(XLDataType.Text, ws.FirstCell().DataType); Assert.AreEqual(Guid.NewGuid().ToString().Length, ws.FirstCell().GetString().Length); }
public void TryGetValue_DateTime_BadString2() { IXLWorksheet ws = new XLWorkbook().Worksheets.Add("Sheet1"); var date = 5545454; ws.FirstCell().SetValue(date).DataType = XLDataType.DateTime; bool success = ws.FirstCell().TryGetValue(out DateTime outValue); Assert.IsFalse(success); }
public void TryGetValue_Enum_Good() { var ws = new XLWorkbook().AddWorksheet(); Assert.IsTrue(ws.FirstCell().SetValue(NumberStyles.AllowCurrencySymbol).TryGetValue(out NumberStyles value)); Assert.AreEqual(NumberStyles.AllowCurrencySymbol, value); // Nullable alternative Assert.IsTrue(ws.FirstCell().SetValue(NumberStyles.AllowCurrencySymbol).TryGetValue(out NumberStyles? value2)); Assert.AreEqual(NumberStyles.AllowCurrencySymbol, value2); }
public void InsertTooLargeNumberOrRowsFails() { var ws = new XLWorkbook().AddWorksheet("Sheet1"); var range = ws.FirstCell().AsRange(); Assert.Throws(typeof(ArgumentOutOfRangeException), () => range.InsertRowsAbove(1048577)); Assert.Throws(typeof(ArgumentOutOfRangeException), () => range.InsertRowsBelow(1048577)); }
public void InsertTooLargeNumberOfColumnsFails() { var ws = new XLWorkbook().AddWorksheet("Sheet1"); var range = ws.FirstCell().AsRange(); Assert.Throws(typeof(ArgumentOutOfRangeException), () => range.InsertColumnsAfter(16385)); Assert.Throws(typeof(ArgumentOutOfRangeException), () => range.InsertColumnsBefore(16385)); }
public void CanCreateInvalidSparklineWithoutSourceData() { var ws = new XLWorkbook().AddWorksheet("Sheet1"); var group = new XLSparklineGroup(ws); var sparkline = new XLSparkline(group, ws.FirstCell(), null); Assert.IsFalse(sparkline.IsValid); }
public void SetCellValueToEnum() { var ws = new XLWorkbook().AddWorksheet("Sheet1"); var dataType = XLDataType.Number; ws.FirstCell().Value = dataType; Assert.AreEqual(XLDataType.Text, ws.FirstCell().DataType); Assert.AreEqual(dataType.ToString(), ws.FirstCell().Value); Assert.AreEqual(dataType.ToString(), ws.FirstCell().GetString()); dataType = XLDataType.TimeSpan; ws.FirstCell().SetValue(dataType); Assert.AreEqual(XLDataType.Text, ws.FirstCell().DataType); Assert.AreEqual(dataType.ToString(), ws.FirstCell().Value); Assert.AreEqual(dataType.ToString(), ws.FirstCell().GetString()); }
public void SetCellValueToGuid() { var ws = new XLWorkbook().AddWorksheet("Sheet1"); var guid = Guid.NewGuid(); ws.FirstCell().Value = guid; Assert.AreEqual(XLDataType.Text, ws.FirstCell().DataType); Assert.AreEqual(guid.ToString(), ws.FirstCell().Value); Assert.AreEqual(guid.ToString(), ws.FirstCell().GetString()); guid = Guid.NewGuid(); ws.FirstCell().SetValue(guid); Assert.AreEqual(XLDataType.Text, ws.FirstCell().DataType); Assert.AreEqual(guid.ToString(), ws.FirstCell().Value); Assert.AreEqual(guid.ToString(), ws.FirstCell().GetString()); }
public void InsertData_with_Nulls_IEnumerable() { var ws = new XLWorkbook().Worksheets.Add("Sheet1"); var dateTimeList = new List <DateTime?>() { new DateTime(2000, 1, 1), new DateTime(2000, 1, 2), new DateTime(2000, 1, 3), new DateTime(2000, 1, 4), null }; ws.FirstCell().InsertData(dateTimeList); Assert.AreEqual(new DateTime(2000, 1, 1), ws.Cell("A1").GetDateTime()); Assert.AreEqual(String.Empty, ws.Cell("A5").Value); }
public void WorksheetContainsNamedRange() { IXLWorksheet ws = new XLWorkbook().AddWorksheet("Sheet1"); ws.FirstCell().AddToNamed("Name", XLScope.Worksheet); Assert.IsTrue(ws.NamedRanges.Contains("Name")); Assert.IsFalse(ws.NamedRanges.Contains("NameX")); Assert.IsNotNull(ws.NamedRange("Name")); Assert.IsNull(ws.NamedRange("NameX")); Boolean result1 = ws.NamedRanges.TryGetValue("Name", out IXLNamedRange range1); Assert.IsTrue(result1); Assert.IsNotNull(range1); Boolean result2 = ws.NamedRanges.TryGetValue("NameX", out IXLNamedRange range2); Assert.IsFalse(result2); Assert.IsNull(range2); }
public void InsertData_with_Nulls() { var ws = new XLWorkbook().Worksheets.Add("Sheet1"); var table = new DataTable(); table.TableName = "Patients"; table.Columns.Add("Dosage", typeof(int)); table.Columns.Add("Drug", typeof(string)); table.Columns.Add("Patient", typeof(string)); table.Columns.Add("Date", typeof(DateTime)); table.Rows.Add(25, "Indocin", "David", new DateTime(2000, 1, 1)); table.Rows.Add(50, "Enebrel", "Sam", new DateTime(2000, 1, 2)); table.Rows.Add(10, "Hydralazine", "Christoff", new DateTime(2000, 1, 3)); table.Rows.Add(21, "Combivent", DBNull.Value, new DateTime(2000, 1, 4)); table.Rows.Add(100, "Dilantin", "Melanie", DBNull.Value); ws.FirstCell().InsertData(table); Assert.AreEqual(25, ws.Cell("A1").Value); Assert.AreEqual("", ws.Cell("C4").Value); Assert.AreEqual("", ws.Cell("D5").Value); }