public void Write2Rows() { using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { using (IWorksheetWriter writer = spreadsheet.WriteToWorksheet("UnitTests")) { Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A1")); writer.WriteRow(new List <string> { "One", "Two", "Three" }); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A2")); writer.WriteRow(new List <string> { "Four", "Five", "Six" }); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A3")); } } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); List <string> list = reader.ReadRow(); Assert.That(list, Is.Not.Empty); Assert.That(list, Is.EquivalentTo(new List <string> { "One", "Two", "Three" })); list = reader.ReadRow(); Assert.That(list, Is.Not.Empty); Assert.That(list, Is.EquivalentTo(new List <string> { "Four", "Five", "Six" })); } }
public void GetCurrentCellAfterMoveRowColumn() { WriteTestValues(); using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("A1")); Assert.That(reader.GetCurrentCell().Row, Is.EqualTo(1)); Assert.That(reader.GetCurrentCell().Column, Is.EqualTo(1)); Assert.That(reader.GetCurrentCell().Value, Is.EqualTo("A-1")); reader.MoveTo(2, 1); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("A2")); Assert.That(reader.GetCurrentCell().Row, Is.EqualTo(2)); Assert.That(reader.GetCurrentCell().Column, Is.EqualTo(1)); Assert.That(reader.GetCurrentCell().Value, Is.EqualTo("A-2")); reader.MoveTo(1, 3); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("C1")); Assert.That(reader.GetCurrentCell().Row, Is.EqualTo(1)); Assert.That(reader.GetCurrentCell().Column, Is.EqualTo(3)); Assert.That(reader.GetCurrentCell().Value, Is.EqualTo("C-1")); } }
public void Write() { using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { using (IWorksheetWriter writer = spreadsheet.WriteToWorksheet("UnitTests")) { Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A1")); writer.Write("One"); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("B1")); writer.MoveTo("D3"); writer.Write("New value at D3"); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("E3")); } } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); reader.MoveTo("A1"); Assert.That(reader.Read(), Is.EqualTo("One")); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("B1")); reader.MoveTo("D3"); Assert.That(reader.Read(), Is.EqualTo("New value at D3")); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("E3")); } }
public void WriteEnterpriseSiteArea() { Hierarchy hierarchy = new Hierarchy(); hierarchy.Enterprise = new Enterprise("My Company"); hierarchy.Enterprise.Site.Add(new Site("My Site")); hierarchy.Enterprise.Site[0].Area.Add(new Area("My Area")); using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { HierarchyWriterCommand command = new HierarchyWriterCommand(hierarchy, spreadsheet); command.Execute(); } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { using (IWorksheetReader reader = spreadsheet.ReadWorksheet("Hierarchy")) { reader.MoveTo("A1"); Assert.That(reader.ReadRow(), Is.EquivalentTo(expectedHeader)); CheckRow(reader, "A2", 1, "Enterprise", string.Empty, "My Company"); CheckRow(reader, "A3", 2, "Site", string.Empty, "My Site"); CheckRow(reader, "A4", 3, "Area", string.Empty, "My Area"); } } }
public void ReadRowAfterMoveUsingAddress() { WriteTestValues(); using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); reader.MoveTo("B1"); List <string> row1 = reader.ReadRow(); List <string> row2 = reader.ReadRow(); Assert.That(row1, Is.EquivalentTo(new List <string> { "B-1", "C-1" })); Assert.That(row2, Is.EquivalentTo(new List <string> { "B-2", "C-2" })); reader.MoveTo("A1"); Assert.That(reader.ReadRow(), Is.EquivalentTo(new List <string> { "A-1", "B-1", "C-1" })); Assert.That(reader.ReadRow(), Is.EquivalentTo(new List <string> { "A-2", "B-2", "C-2" })); } }
public void MoveToAddress() { WriteTestValues(); using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); reader.MoveTo("A1"); Assert.That(reader.Read(), Is.EqualTo("A-1")); reader.MoveTo("B2"); Assert.That(reader.Read(), Is.EqualTo("B-2")); } }
public void IsEndOfDataEmpty() { using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { using (spreadsheet.WriteToWorksheet("UnitTests")) { } } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { using (IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests")) { Assert.That(reader.IsEndOfData(), Is.True); } } }
public void ReadRow() { using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { IWorksheetWriter writer = spreadsheet.WriteToWorksheet("UnitTests"); List <string> list = new List <string> { "One", "Two", "Three" }; writer.WriteRow(list); } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests"); List <string> list = reader.ReadRow(); Assert.That(list, Is.Not.Empty); Assert.That(list, Is.EquivalentTo(new List <string> { "One", "Two", "Three" })); } }
public void MoveToAndWrite() { using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { using (IWorksheetWriter writer = spreadsheet.WriteToWorksheet("UnitTests")) { Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A1")); writer.MoveTo("B2"); writer.WriteRow(new List <string> { "One", "Two", "Three" }); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("B3")); writer.WriteRow(new List <string> { "Four", "Five", "Six" }); Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("B4")); } } using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { using (IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests")) { Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("A1")); Assert.That(reader.ReadRow(), Is.EquivalentTo(new List <string>())); reader.MoveTo("B2"); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("B2")); Assert.That(reader.ReadRow(), Is.EquivalentTo(new List <string> { "One", "Two", "Three" })); Assert.That(reader.GetCurrentCell().Address, Is.EqualTo("B3")); Assert.That(reader.ReadRow(), Is.EquivalentTo(new List <string> { "Four", "Five", "Six" })); } } }
public void IsEndOfData() { WriteTestValues(); using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { using (IWorksheetReader reader = spreadsheet.ReadWorksheet("UnitTests")) { string[] falseAddresses = new[] { "A1", "A2", "A3", "B1", "B2", "B3", "C1", "C2", "C3", "D1", "D2" }; string[] trueAddresses = new [] { "A4", "A5", "B4", "B5", "C4", "C5", "D3", "D4", "D5" }; foreach (string address in falseAddresses) { reader.MoveTo(address); Assert.That(reader.IsEndOfData(), Is.False, "EndOfData = false for {0}", address); } foreach (string address in trueAddresses) { reader.MoveTo(address); Assert.That(reader.IsEndOfData(), Is.True, "EndOfData = true for {0}", address); } } } }
public void ReadAndWrite() { List <string> list = new List <string> { "One", "Two", "Three" }; using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename)) { IWorksheetWriter worksheet = spreadsheet.WriteToWorksheet("New sheet"); Assert.That(worksheet, Is.Not.Null); worksheet.WriteRow(list); } List <string> result; using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.OpenReadOnly(Filename)) { IWorksheetReader worksheet = spreadsheet.ReadWorksheet("New sheet"); Assert.That(worksheet, Is.Not.Null); result = worksheet.ReadRow(); } Assert.That(result, Is.EquivalentTo(list)); }
/// <summary> /// Initializes a new instance of the <see cref="ExcelReaderCommand"/> class. /// </summary> /// <param name="spreadsheet">The spreadsheet.</param> /// <param name="name">The name.</param> protected ExcelReaderCommand(IExcelSpreadsheet spreadsheet, string name) { worksheetReader = spreadsheet.ReadWorksheet(name); }
/// <summary> /// Initializes a new instance of the <see cref="ExcelReaderCommand"/> class. /// </summary> /// <param name="spreadsheet">The spreadsheet.</param> /// <param name="name">The name.</param> protected ExcelReaderCommand(IExcelSpreadsheet spreadsheet, string name) { worksheetReader = spreadsheet.ReadWorksheet(name); }