public void MSExcel2003XmlFile_AddRow_GetRowValues()
{
//arrange
MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile();
string title = "title";
List <object> valuesA = new List <object>()
{
"abc", 123, new DateTime(1999, 3, 2)
};
List <object> valuesB = new List <object>()
{
"def", 456, new DateTime(1777, 5, 4)
};
//act
int tableIndex = xmlFile.AddWorksheet(title);
xmlFile.AddRow(tableIndex, valuesA);
xmlFile.AddRow(tableIndex, valuesB);
List <string> savedValuesA = xmlFile.GetRowValues(tableIndex, 0);
List <string> savedValuesB = xmlFile.GetRowValues(tableIndex, 1);
int savedRowCount = xmlFile.GetRowCount(tableIndex);
//assert
Assert.AreEqual(valuesA.Count, savedValuesA.Count);
for (int i = 0; i < valuesA.Count; i++)
{
if (valuesA[i] is DateTime)
{
Assert.AreEqual(MSExcel2003XmlFile.DateToString((DateTime)valuesA[i]), savedValuesA[i]);
}
else
{
Assert.AreEqual(valuesA[i].ToString(), savedValuesA[i]);
}
}
Assert.AreEqual(valuesB.Count, savedValuesB.Count);
for (int i = 0; i < valuesB.Count; i++)
{
if (valuesB[i] is DateTime)
{
Assert.AreEqual(MSExcel2003XmlFile.DateToString((DateTime)valuesB[i]), savedValuesB[i]);
}
else
{
Assert.AreEqual(valuesB[i].ToString(), savedValuesB[i]);
}
}
Assert.AreEqual(2, savedRowCount);
}
public void WriteTask(MSExcel2003XmlFile xmlFile, int tableIndex, Task task, bool isActive)
{
List <XmlNode> cellNodes = new List <XmlNode>()
{
xmlFile.GenerateNumberCell(task.Id),
xmlFile.GenerateParagraphCell(task.Description),
xmlFile.GenerateTextCell(task.Status),
xmlFile.GenerateTextCell(task.Category),
xmlFile.GenerateDateCell(task.CreateDate)
};
if (!isActive && task.DoneDate.HasValue)
{
cellNodes.Add(xmlFile.GenerateDateCell(task.DoneDate.Value));
}
xmlFile.AddRow(tableIndex, cellNodes);
}
