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 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 GetCurrentCell()
{
using (IExcelSpreadsheet spreadsheet = ExcelSpreadsheet.CreateNew(Filename))
{
using (IWorksheetWriter writer = spreadsheet.WriteToWorksheet("UnitTests"))
{
Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("A1"));
writer.MoveTo("B2");
Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("B2"));
writer.MoveTo(10, 20);
Assert.That(writer.GetCurrentCell().Address, Is.EqualTo("T10"));
}
}
}
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 ICellReader GetCurrentCell()
{
return(writer.GetCurrentCell());
}