public void CreateHeader(WorksheetPart worksheetPart) { if (worksheetPart == null) { throw new ArgumentNullException("worksheetPart"); } ExcelUtility.SetStringCell(worksheetPart.Worksheet, "B", 2, ServiceOffering.Id.ToString()); ExcelUtility.SetStringCell(worksheetPart.Worksheet, "C", 2, ServiceOffering.Name); }
public void CreateErrorRows(WorksheetPart worksheetPart) { for (int rowIndex = 0; rowIndex < ErrorRows.Count; rowIndex++) { for (int i = 0; i < ErrorRows[rowIndex].RowErrors.Count; i++) { ExcelUtility.SetStringCell(worksheetPart.Worksheet, CellDictionary[i], (uint)rowIndex + 4, ErrorRows[rowIndex].RowErrors[i]); } } }