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 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"));
}
}
private static void WriteRow(IWorksheetWriter writer, string address, params string[] values)
{
writer.MoveTo(address);
foreach (string value in values)
{
writer.Write(value);
}
}
private static void WriteRow(IWorksheetWriter writer, string address, int depth, string isa95Type, string isa95Class, string name)
{
writer.MoveTo(address);
writer.Write(depth.ToString("0"));
writer.Write(isa95Type);
writer.Write(isa95Class);
for (int i = 1; i < depth; i++)
{
writer.Write("");
}
writer.Write(name);
}
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"
}));
}
}
}
private static void WriteRow(IWorksheetWriter writer, string address, params string[] values)
{
writer.MoveTo(address);
foreach (string value in values)
{
writer.Write(value);
}
}
private static void WriteRow(IWorksheetWriter writer, string address, int depth, string isa95Type, string isa95Class, string name)
{
writer.MoveTo(address);
writer.Write(depth.ToString("0"));
writer.Write(isa95Type);
writer.Write(isa95Class);
for (int i = 1; i < depth; i++)
{
writer.Write("");
}
writer.Write(name);
}
public void MoveTo(string address)
{
writer.MoveTo(address);
}