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);
}