public void WriteTo(MSExcel2003XmlFile xmlFile) { int tableIndex = xmlFile.AddWorksheet(SHEET_NAME); xmlFile.AddHeaderRow(tableIndex, new List <string>() { STATUS_NAME, ACTIVE_NAME, "", CATEGORY_NAME, "", ID_NAME }); List <XmlNode> statusNodes = Statuses.Select(status => xmlFile.GenerateTextCell(status.Name)).ToList(); List <XmlNode> activeNodes = Statuses.Select(status => xmlFile.GenerateTextCell((status.Active ? "Active" : "Inactive"))).ToList(); //todo: make constants, but not connected to table names List <XmlNode> categoryNodes = Categories.Select(category => xmlFile.GenerateTextCell(category)).ToList(); xmlFile.AddColumns(tableIndex, new List <List <XmlNode> >() { statusNodes, activeNodes, new List <XmlNode>(), categoryNodes, new List <XmlNode>(), new List <XmlNode>() { xmlFile.GenerateNumberCell(MaxId) } }); }
public void MSExcel2003XmlFile_GenerateNumberCell() { //arrange string comparisonFilename = "data/MSExcel2003XmlFile_NumberCell.txt"; int number = 100; MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile(); //act XmlNode node = xmlFile.GenerateNumberCell(number); string text = XmlDocumentHelper.XmlToString(node); //assert Assert.AreEqual(Utilities.LoadText(comparisonFilename), text); }
public void MSExcel2003XmlFile_GenerateCell_Integer() { //arrange int data = 123; MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile(); //act XmlNode nodeA = xmlFile.GenerateCell(data); XmlNode nodeB = xmlFile.GenerateNumberCell(data); string textA = XmlDocumentHelper.XmlToString(nodeA); string textB = XmlDocumentHelper.XmlToString(nodeB); //assert Assert.AreEqual(textA, textB); }
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); }