Generate XLSX file using C# and OpenXml package

The Following features are implemented:

• Cell formatting
• Cell colouring
• Borders
• Columns custom width
• Formulas
• IgnoredErrors

The resulting xlsx file looks like this:

First of all, we hve to install the following NuGet package: DocumentFormat.OpenXml.

The code:

// Data example used to generate xlsx file
string csv = @"Program Name,Start Date,Start Time,End Date,End Time,Series Number,Run
WEEKEND TODAY,01/12/19,07:00,01/12/19,10:00,19,1
SPORTS SUNDAY,01/12/19,10:00,01/12/19,11:00,19,1
CROSS COURT,01/12/19,11:00,01/12/19,11:30,19,1
THE HOLD DOWN,01/12/19,11:30,01/12/19,12:00,5,1
EXPLORE TV-VIKING,01/12/19,16:30,01/12/19,17:00,1,1
NINE NEWS: FIRST AT FIVE,01/12/19,17:00,01/12/19,17:25,19,1
NINE NEWS SUNDAY,01/12/19,17:59,01/12/19,19:00,19,1
A CURRENT AFFAIR,10/12/19,19:00,10/12/19,19:38,19,1
TODAY,11/12/19,06:00,11/12/19,09:00,19,1
TODAY EXTRA,11/12/19,09:00,11/12/19,11:30,19,1
NINE'S MORNING NEWS,11/12/19,11:30,11/12/19,12:00,19,1
DESTINATION HAPPINESS,11/12/19,12:59,11/12/19,13:31,3,2
GIVING LIFE,11/12/19,13:31,11/12/19,14:02,1,3
NINE'S AFTERNOON NEWS,11/12/19,16:00,11/12/19,17:00,19,1
MILLIONAIRE HOT SEAT,11/12/19,17:00,11/12/19,17:59,19,2
,,,,,,";
            
GenerateXlsx(csv, "D:\\text.xlsx");

public GenerateXlsx(string csv, string path)
{
    string[] lines = csv.Replace("\r", "").Split('\n');
    //Creating XLSX document and filling it with the data
    using (SpreadsheetDocument document = SpreadsheetDocument.Create(path, SpreadsheetDocumentType.Workbook))
    {
        // Add a WorkbookPart to the document.
        WorkbookPart workbookPart = document.AddWorkbookPart();
        //Initialize a SheetData
        SheetData sheetData = InitializeSheetData(workbookPart, lines.Length);
        //Add the headers row
        AddHeadersRow(lines[0].Split(','), sheetData);
        //Add data rows
        for (int i = 1; i < lines.Length; i++)
        {
            if (String.IsNullOrEmpty(lines[i])) continue;
            String[] columnData = lines[i].Split(',');
            //Add row to the sheet
            AddDataRow(columnData, i + 1, sheetData, i == lines.Length - 2);
        }
        //Add the totals row
        AddTotalsRow(lines, sheetData);
        workbookPart.Workbook.Save();
    }
}

/// 

/// Processes whole the routines to create the workbook, sheet parts, sheets, data
/// 
/// 
/// 
/// 
private SheetData InitializeSheetData(WorkbookPart workbookPart, int rowsNumber)
{
    workbookPart.Workbook = new Workbook();
    // Add a WorksheetPart to the WorkbookPart.
    WorksheetPart worksheetPart = workbookPart.AddNewPart();
    worksheetPart.Worksheet = new Worksheet(new SheetData());
    
    //Create a new sheet
    Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
    Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Report" };
    sheets.Append(sheet);
    // Get the sheetData cell table.
    SheetData sheetData = worksheetPart.Worksheet.GetFirstChild();
    //Add columns scheme
    worksheetPart.Worksheet.InsertBefore(GenerateColumnsScheme(), sheetData);
    // Add styles to the sheet
    WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart();
    workbookStylesPart.Stylesheet = CreateStylesheet();
    workbookStylesPart.Stylesheet.Save();
    //Add IgnoredErrors Element
    var ignoredErrorsElement = new IgnoredErrors();
    ignoredErrorsElement.AppendChild(new IgnoredError()
    {
        SequenceOfReferences = new ListValue()
        {
            InnerText = $"B2:B{rowsNumber} D2:D{rowsNumber}"
        },
        TwoDigitTextYear = true
    });
    worksheetPart.Worksheet.AppendChild(ignoredErrorsElement);
    //Add Totals
    
    return sheetData;
}

/// 

/// Generates columns with custom widths
/// 
/// 
private Columns GenerateColumnsScheme()
{
    Columns columns = new Columns();
    columns.AppendChild(new Column() { Min = 1, Max = 1, Width = 34, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 2, Max = 2, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 3, Max = 3, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 4, Max = 4, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 5, Max = 5, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 6, Max = 6, Width = 17, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 7, Max = 7, Width = 8, CustomWidth = true });
    
    return columns;
}

/// 

/// Add headers row to the sheet
/// 
/// 
/// 
private void AddHeadersRow(string[] headers, SheetData sheetData)
{
    Row row = new Row() { RowIndex = 1 };
    foreach (string header in headers)
    {
        row.AppendChild(new Cell()
        {
            CellValue = new CellValue(header),
            DataType = new EnumValue(CellValues.String),
            StyleIndex = 1
        });
    }
    sheetData.AppendChild(row);
}

private void AddDataRow(String[] rowData, int rowNumber, SheetData sheetData, bool isLastRow)
{
    Row row = new Row() { RowIndex = (UInt32)rowNumber };
    for (int columnIndex = 0; columnIndex < rowData.Length; columnIndex++)
    {
        string cellData = rowData[columnIndex];
        CellValues cellType = CellValues.String;
        TimeSpan timeSpanCellData = TimeSpan.Zero;
        if (columnIndex == 2 || columnIndex == 4)
        {
            TimeSpan.TryParse(cellData, out timeSpanCellData);
        }
        switch (columnIndex)
        {
            case 5: //Series Number
            case 6: //Run
            cellType = CellValues.Number;
                break;
        }
        Cell cell = new Cell()
        {
            CellValue = new CellValue(cellData),
            DataType = new EnumValue(cellType)
        };
        //Add bottom line under the last row
        if (isLastRow) cell.StyleIndex = 2;
        row.AppendChild(cell);
    }
    sheetData.AppendChild(row);
}

/// 

/// Add totals row to the sheet
/// 
/// 
/// 
private void AddTotalsRow(string[] lines, SheetData sheetData)
{
    Row row = new Row() {RowIndex = (UInt32Value) (lines.Length + 1U)};
    for (int columnIndex = 0; columnIndex < 7; columnIndex++)
    {
        Cell cell = new Cell()
        {
            StyleIndex = 3,
            DataType = new EnumValue(CellValues.String)
        };
        switch (columnIndex)
        {
            case 0:
                cell.CellValue = new CellValue("Totals");
                break;
            case 6:
                cell.DataType = new EnumValue(CellValues.Number);
                cell.CellFormula = new CellFormula($"SUM(G2:G{lines.Length - 1})");
                break;
        }
        row.AppendChild(cell);
    }
    
    sheetData.AppendChild(row);
}

/// 

/// Creates the stylesheet
/// 
/// 
private static Stylesheet CreateStylesheet()
{
    //Fonts
    Font font0 = new Font();
    Font font1 = new Font(new FontSize() {Val = 10}, new Bold(), new Color() {Rgb = "FF000000"});
    Font font2 = new Font(new FontSize() { Val = 12 }, new Bold());
    Fonts fonts = new Fonts(font0, font1, font2);
    //Fills
    Fill fill0 = new Fill();
    Fill fill1 = new Fill();
    Fill fill2 = new Fill(new PatternFill()
    {
        PatternType = PatternValues.Solid,
        ForegroundColor = new ForegroundColor {Rgb = "FFA9CEE8"},
        BackgroundColor = new BackgroundColor() {Indexed = 64}
    });
    Fill fill3 = new Fill(new PatternFill()
    {
        PatternType = PatternValues.Solid,
        ForegroundColor = new ForegroundColor {Rgb = "FFC6EFCE"},
        BackgroundColor = new BackgroundColor() {Indexed = 64}
    });
    Fills fills = new Fills(fill0, fill1, fill2, fill3);
    //Borders
    Border border0 = new Border();
    Border border1 = new Border(new BottomBorder(new Color() {Auto = true}) {Style = BorderStyleValues.Double});
    Borders borders = new Borders(border0, border1);
    
    //CellFormats
    CellFormat cellFormat0 = new CellFormat {FontId = 0, FillId = 0};
    CellFormat cellFormat1 = new CellFormat {FontId = 1, FillId = 2, Alignment = new Alignment() {Horizontal = HorizontalAlignmentValues.Center}};
    CellFormat cellFormat2 = new CellFormat { FontId = 0, FillId = 0, BorderId = 1};
    CellFormat cellFormat3 = new CellFormat { FontId = 2, FillId = 3 };
    CellFormats cellFormats = new CellFormats(cellFormat0, cellFormat1, cellFormat2, cellFormat3);
    //Compose the Style Sheet
    Stylesheet styleSheet = new Stylesheet(fonts, fills, borders, cellFormats);
    return styleSheet;
}

1. // Data example used to generate xlsx file
2. string csv = @"Program Name,Start Date,Start Time,End Date,End Time,Series Number,Run
3. WEEKEND TODAY,01/12/19,07:00,01/12/19,10:00,19,1
4. SPORTS SUNDAY,01/12/19,10:00,01/12/19,11:00,19,1
5. CROSS COURT,01/12/19,11:00,01/12/19,11:30,19,1
6. THE HOLD DOWN,01/12/19,11:30,01/12/19,12:00,5,1
7. EXPLORE TV-VIKING,01/12/19,16:30,01/12/19,17:00,1,1
8. NINE NEWS: FIRST AT FIVE,01/12/19,17:00,01/12/19,17:25,19,1
9. NINE NEWS SUNDAY,01/12/19,17:59,01/12/19,19:00,19,1
10. A CURRENT AFFAIR,10/12/19,19:00,10/12/19,19:38,19,1
11. TODAY,11/12/19,06:00,11/12/19,09:00,19,1
12. TODAY EXTRA,11/12/19,09:00,11/12/19,11:30,19,1
13. NINE'S MORNING NEWS,11/12/19,11:30,11/12/19,12:00,19,1
14. DESTINATION HAPPINESS,11/12/19,12:59,11/12/19,13:31,3,2
15. GIVING LIFE,11/12/19,13:31,11/12/19,14:02,1,3
16. NINE'S AFTERNOON NEWS,11/12/19,16:00,11/12/19,17:00,19,1
17. MILLIONAIRE HOT SEAT,11/12/19,17:00,11/12/19,17:59,19,2
18. ,,,,,,";
20. GenerateXlsx(csv, "D:\\text.xlsx");
22. public GenerateXlsx(string csv, string path)
23. {
24. string[] lines = csv.Replace("\r", "").Split('\n');
25. //Creating XLSX document and filling it with the data
26. using (SpreadsheetDocument document = SpreadsheetDocument.Create(path, SpreadsheetDocumentType.Workbook))
27. {
28. // Add a WorkbookPart to the document.
29. WorkbookPart workbookPart = document.AddWorkbookPart();
30. //Initialize a SheetData
31. SheetData sheetData = InitializeSheetData(workbookPart, lines.Length);
32. //Add the headers row
33. AddHeadersRow(lines[0].Split(','), sheetData);
34. //Add data rows
35. for (int i = 1; i < lines.Length; i++)
36. {
37. if (String.IsNullOrEmpty(lines[i])) continue;
38. String[] columnData = lines[i].Split(',');
39. //Add row to the sheet
40. AddDataRow(columnData, i + 1, sheetData, i == lines.Length - 2);
41. }
42. //Add the totals row
43. AddTotalsRow(lines, sheetData);
44. workbookPart.Workbook.Save();
45. }
46. }
48. /// <summary>
49. /// Processes whole the routines to create the workbook, sheet parts, sheets, data
50. /// </summary>
51. /// <param name="workbookPart">
52. /// <param name="rowsNumber">
53. /// <returns></returns>
54. private SheetData InitializeSheetData(WorkbookPart workbookPart, int rowsNumber)
55. {
56. workbookPart.Workbook = new Workbook();
57. // Add a WorksheetPart to the WorkbookPart.
58. WorksheetPart worksheetPart = workbookPart.AddNewPart<worksheetpart>();
59. worksheetPart.Worksheet = new Worksheet(new SheetData());
61. //Create a new sheet
62. Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
63. Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Report" };
64. sheets.Append(sheet);
65. // Get the sheetData cell table.
66. SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<sheetdata>();
67. //Add columns scheme
68. worksheetPart.Worksheet.InsertBefore(GenerateColumnsScheme(), sheetData);
69. // Add styles to the sheet
70. WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart<workbookstylespart>();
71. workbookStylesPart.Stylesheet = CreateStylesheet();
72. workbookStylesPart.Stylesheet.Save();
73. //Add IgnoredErrors Element
74. var ignoredErrorsElement = new IgnoredErrors();
75. ignoredErrorsElement.AppendChild(new IgnoredError()
76. {
77. SequenceOfReferences = new ListValue<stringvalue>()
78. {
79. InnerText = $"B2:B{rowsNumber} D2:D{rowsNumber}"
80. },
81. TwoDigitTextYear = true
82. });
83. worksheetPart.Worksheet.AppendChild(ignoredErrorsElement);
84. //Add Totals
86. return sheetData;
87. }
89. /// <summary>
90. /// Generates columns with custom widths
91. /// </summary>
92. /// <returns></returns>
93. private Columns GenerateColumnsScheme()
94. {
95. Columns columns = new Columns();
96. columns.AppendChild(new Column() { Min = 1, Max = 1, Width = 34, CustomWidth = true });
97. columns.AppendChild(new Column() { Min = 2, Max = 2, Width = 10, CustomWidth = true });
98. columns.AppendChild(new Column() { Min = 3, Max = 3, Width = 10, CustomWidth = true });
99. columns.AppendChild(new Column() { Min = 4, Max = 4, Width = 10, CustomWidth = true });
100. columns.AppendChild(new Column() { Min = 5, Max = 5, Width = 10, CustomWidth = true });
101. columns.AppendChild(new Column() { Min = 6, Max = 6, Width = 17, CustomWidth = true });
102. columns.AppendChild(new Column() { Min = 7, Max = 7, Width = 8, CustomWidth = true });
104. return columns;
105. }
107. /// <summary>
108. /// Add headers row to the sheet
109. /// </summary>
110. /// <param name="headers">
111. /// <param name="sheetData">
112. private void AddHeadersRow(string[] headers, SheetData sheetData)
113. {
114. Row row = new Row() { RowIndex = 1 };
115. foreach (string header in headers)
116. {
117. row.AppendChild(new Cell()
118. {
119. CellValue = new CellValue(header),
120. DataType = new EnumValue<cellvalues>(CellValues.String),
121. StyleIndex = 1
122. });
123. }
124. sheetData.AppendChild(row);
125. }
127. private void AddDataRow(String[] rowData, int rowNumber, SheetData sheetData, bool isLastRow)
128. {
129. Row row = new Row() { RowIndex = (UInt32)rowNumber };
130. for (int columnIndex = 0; columnIndex < rowData.Length; columnIndex++)
131. {
132. string cellData = rowData[columnIndex];
133. CellValues cellType = CellValues.String;
134. TimeSpan timeSpanCellData = TimeSpan.Zero;
135. if (columnIndex == 2 || columnIndex == 4)
136. {
137. TimeSpan.TryParse(cellData, out timeSpanCellData);
138. }
139. switch (columnIndex)
140. {
141. case 5: //Series Number
142. case 6: //Run
143. cellType = CellValues.Number;
144. break;
145. }
146. Cell cell = new Cell()
147. {
148. CellValue = new CellValue(cellData),
149. DataType = new EnumValue<cellvalues>(cellType)
150. };
151. //Add bottom line under the last row
152. if (isLastRow) cell.StyleIndex = 2;
153. row.AppendChild(cell);
154. }
155. sheetData.AppendChild(row);
156. }
158. /// <summary>
159. /// Add totals row to the sheet
160. /// </summary>
161. /// <param name="lines">
162. /// <param name="sheetData">
163. private void AddTotalsRow(string[] lines, SheetData sheetData)
164. {
165. Row row = new Row() {RowIndex = (UInt32Value) (lines.Length + 1U)};
166. for (int columnIndex = 0; columnIndex < 7; columnIndex++)
167. {
168. Cell cell = new Cell()
169. {
170. StyleIndex = 3,
171. DataType = new EnumValue<cellvalues>(CellValues.String)
172. };
173. switch (columnIndex)
174. {
175. case 0:
176. cell.CellValue = new CellValue("Totals");
177. break;
178. case 6:
179. cell.DataType = new EnumValue<cellvalues>(CellValues.Number);
180. cell.CellFormula = new CellFormula($"SUM(G2:G{lines.Length - 1})");
181. break;
182. }
183. row.AppendChild(cell);
184. }
186. sheetData.AppendChild(row);
187. }
189. /// <summary>
190. /// Creates the stylesheet
191. /// </summary>
192. /// <returns></returns>
193. private static Stylesheet CreateStylesheet()
194. {
195. //Fonts
196. Font font0 = new Font();
197. Font font1 = new Font(new FontSize() {Val = 10}, new Bold(), new Color() {Rgb = "FF000000"});
198. Font font2 = new Font(new FontSize() { Val = 12 }, new Bold());
199. Fonts fonts = new Fonts(font0, font1, font2);
200. //Fills
201. Fill fill0 = new Fill();
202. Fill fill1 = new Fill();
203. Fill fill2 = new Fill(new PatternFill()
204. {
205. PatternType = PatternValues.Solid,
206. ForegroundColor = new ForegroundColor {Rgb = "FFA9CEE8"},
207. BackgroundColor = new BackgroundColor() {Indexed = 64}
208. });
209. Fill fill3 = new Fill(new PatternFill()
210. {
211. PatternType = PatternValues.Solid,
212. ForegroundColor = new ForegroundColor {Rgb = "FFC6EFCE"},
213. BackgroundColor = new BackgroundColor() {Indexed = 64}
214. });
215. Fills fills = new Fills(fill0, fill1, fill2, fill3);
216. //Borders
217. Border border0 = new Border();
218. Border border1 = new Border(new BottomBorder(new Color() {Auto = true}) {Style = BorderStyleValues.Double});
219. Borders borders = new Borders(border0, border1);
221. //CellFormats
222. CellFormat cellFormat0 = new CellFormat {FontId = 0, FillId = 0};
223. CellFormat cellFormat1 = new CellFormat {FontId = 1, FillId = 2, Alignment = new Alignment() {Horizontal = HorizontalAlignmentValues.Center}};
224. CellFormat cellFormat2 = new CellFormat { FontId = 0, FillId = 0, BorderId = 1};
225. CellFormat cellFormat3 = new CellFormat { FontId = 2, FillId = 3 };
226. CellFormats cellFormats = new CellFormats(cellFormat0, cellFormat1, cellFormat2, cellFormat3);
227. //Compose the Style Sheet
228. Stylesheet styleSheet = new Stylesheet(fonts, fills, borders, cellFormats);
229. return styleSheet;
230. }
232. </cellvalues></cellvalues></cellvalues></cellvalues></stringvalue></workbookstylespart></sheetdata></worksheetpart>

// Data example used to generate xlsx file
string csv = @"Program Name,Start Date,Start Time,End Date,End Time,Series Number,Run
WEEKEND TODAY,01/12/19,07:00,01/12/19,10:00,19,1
SPORTS SUNDAY,01/12/19,10:00,01/12/19,11:00,19,1
CROSS COURT,01/12/19,11:00,01/12/19,11:30,19,1
THE HOLD DOWN,01/12/19,11:30,01/12/19,12:00,5,1
EXPLORE TV-VIKING,01/12/19,16:30,01/12/19,17:00,1,1
NINE NEWS: FIRST AT FIVE,01/12/19,17:00,01/12/19,17:25,19,1
NINE NEWS SUNDAY,01/12/19,17:59,01/12/19,19:00,19,1
A CURRENT AFFAIR,10/12/19,19:00,10/12/19,19:38,19,1
TODAY,11/12/19,06:00,11/12/19,09:00,19,1
TODAY EXTRA,11/12/19,09:00,11/12/19,11:30,19,1
NINE'S MORNING NEWS,11/12/19,11:30,11/12/19,12:00,19,1
DESTINATION HAPPINESS,11/12/19,12:59,11/12/19,13:31,3,2
GIVING LIFE,11/12/19,13:31,11/12/19,14:02,1,3
NINE'S AFTERNOON NEWS,11/12/19,16:00,11/12/19,17:00,19,1
MILLIONAIRE HOT SEAT,11/12/19,17:00,11/12/19,17:59,19,2
,,,,,,";
            
GenerateXlsx(csv, "D:\\text.xlsx");

public GenerateXlsx(string csv, string path)
{
    string[] lines = csv.Replace("\r", "").Split('\n');
    //Creating XLSX document and filling it with the data
    using (SpreadsheetDocument document = SpreadsheetDocument.Create(path, SpreadsheetDocumentType.Workbook))
    {
        // Add a WorkbookPart to the document.
        WorkbookPart workbookPart = document.AddWorkbookPart();
        //Initialize a SheetData
        SheetData sheetData = InitializeSheetData(workbookPart, lines.Length);
        //Add the headers row
        AddHeadersRow(lines[0].Split(','), sheetData);
        //Add data rows
        for (int i = 1; i < lines.Length; i++)
        {
            if (String.IsNullOrEmpty(lines[i])) continue;
            String[] columnData = lines[i].Split(',');
            //Add row to the sheet
            AddDataRow(columnData, i + 1, sheetData, i == lines.Length - 2);
        }
        //Add the totals row
        AddTotalsRow(lines, sheetData);
        workbookPart.Workbook.Save();
    }
}

/// <summary>
/// Processes whole the routines to create the workbook, sheet parts, sheets, data
/// </summary>
/// <param name="workbookPart">
/// <param name="rowsNumber">
/// <returns></returns>
private SheetData InitializeSheetData(WorkbookPart workbookPart, int rowsNumber)
{
    workbookPart.Workbook = new Workbook();
    // Add a WorksheetPart to the WorkbookPart.
    WorksheetPart worksheetPart = workbookPart.AddNewPart<worksheetpart>();
    worksheetPart.Worksheet = new Worksheet(new SheetData());
    
    //Create a new sheet
    Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
    Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Report" };
    sheets.Append(sheet);
    // Get the sheetData cell table.
    SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<sheetdata>();
    //Add columns scheme
    worksheetPart.Worksheet.InsertBefore(GenerateColumnsScheme(), sheetData);
    // Add styles to the sheet
    WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart<workbookstylespart>();
    workbookStylesPart.Stylesheet = CreateStylesheet();
    workbookStylesPart.Stylesheet.Save();
    //Add IgnoredErrors Element
    var ignoredErrorsElement = new IgnoredErrors();
    ignoredErrorsElement.AppendChild(new IgnoredError()
    {
        SequenceOfReferences = new ListValue<stringvalue>()
        {
            InnerText = $"B2:B{rowsNumber} D2:D{rowsNumber}"
        },
        TwoDigitTextYear = true
    });
    worksheetPart.Worksheet.AppendChild(ignoredErrorsElement);
    //Add Totals
    
    return sheetData;
}

/// <summary>
/// Generates columns with custom widths
/// </summary>
/// <returns></returns>
private Columns GenerateColumnsScheme()
{
    Columns columns = new Columns();
    columns.AppendChild(new Column() { Min = 1, Max = 1, Width = 34, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 2, Max = 2, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 3, Max = 3, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 4, Max = 4, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 5, Max = 5, Width = 10, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 6, Max = 6, Width = 17, CustomWidth = true });
    columns.AppendChild(new Column() { Min = 7, Max = 7, Width = 8, CustomWidth = true });
    
    return columns;
}

/// <summary>
/// Add headers row to the sheet
/// </summary>
/// <param name="headers">
/// <param name="sheetData">
private void AddHeadersRow(string[] headers, SheetData sheetData)
{
    Row row = new Row() { RowIndex = 1 };
    foreach (string header in headers)
    {
        row.AppendChild(new Cell()
        {
            CellValue = new CellValue(header),
            DataType = new EnumValue<cellvalues>(CellValues.String),
            StyleIndex = 1
        });
    }
    sheetData.AppendChild(row);
}

private void AddDataRow(String[] rowData, int rowNumber, SheetData sheetData, bool isLastRow)
{
    Row row = new Row() { RowIndex = (UInt32)rowNumber };
    for (int columnIndex = 0; columnIndex < rowData.Length; columnIndex++)
    {
        string cellData = rowData[columnIndex];
        CellValues cellType = CellValues.String;
        TimeSpan timeSpanCellData = TimeSpan.Zero;
        if (columnIndex == 2 || columnIndex == 4)
        {
            TimeSpan.TryParse(cellData, out timeSpanCellData);
        }
        switch (columnIndex)
        {
            case 5: //Series Number
            case 6: //Run
            cellType = CellValues.Number;
                break;
        }
        Cell cell = new Cell()
        {
            CellValue = new CellValue(cellData),
            DataType = new EnumValue<cellvalues>(cellType)
        };
        //Add bottom line under the last row
        if (isLastRow) cell.StyleIndex = 2;
        row.AppendChild(cell);
    }
    sheetData.AppendChild(row);
}

/// <summary>
/// Add totals row to the sheet
/// </summary>
/// <param name="lines">
/// <param name="sheetData">
private void AddTotalsRow(string[] lines, SheetData sheetData)
{
    Row row = new Row() {RowIndex = (UInt32Value) (lines.Length + 1U)};
    for (int columnIndex = 0; columnIndex < 7; columnIndex++)
    {
        Cell cell = new Cell()
        {
            StyleIndex = 3,
            DataType = new EnumValue<cellvalues>(CellValues.String)
        };
        switch (columnIndex)
        {
            case 0:
                cell.CellValue = new CellValue("Totals");
                break;
            case 6:
                cell.DataType = new EnumValue<cellvalues>(CellValues.Number);
                cell.CellFormula = new CellFormula($"SUM(G2:G{lines.Length - 1})");
                break;
        }
        row.AppendChild(cell);
    }
    
    sheetData.AppendChild(row);
}

/// <summary>
/// Creates the stylesheet
/// </summary>
/// <returns></returns>
private static Stylesheet CreateStylesheet()
{
    //Fonts
    Font font0 = new Font();
    Font font1 = new Font(new FontSize() {Val = 10}, new Bold(), new Color() {Rgb = "FF000000"});
    Font font2 = new Font(new FontSize() { Val = 12 }, new Bold());
    Fonts fonts = new Fonts(font0, font1, font2);
    //Fills
    Fill fill0 = new Fill();
    Fill fill1 = new Fill();
    Fill fill2 = new Fill(new PatternFill()
    {
        PatternType = PatternValues.Solid,
        ForegroundColor = new ForegroundColor {Rgb = "FFA9CEE8"},
        BackgroundColor = new BackgroundColor() {Indexed = 64}
    });
    Fill fill3 = new Fill(new PatternFill()
    {
        PatternType = PatternValues.Solid,
        ForegroundColor = new ForegroundColor {Rgb = "FFC6EFCE"},
        BackgroundColor = new BackgroundColor() {Indexed = 64}
    });
    Fills fills = new Fills(fill0, fill1, fill2, fill3);
    //Borders
    Border border0 = new Border();
    Border border1 = new Border(new BottomBorder(new Color() {Auto = true}) {Style = BorderStyleValues.Double});
    Borders borders = new Borders(border0, border1);
    
    //CellFormats
    CellFormat cellFormat0 = new CellFormat {FontId = 0, FillId = 0};
    CellFormat cellFormat1 = new CellFormat {FontId = 1, FillId = 2, Alignment = new Alignment() {Horizontal = HorizontalAlignmentValues.Center}};
    CellFormat cellFormat2 = new CellFormat { FontId = 0, FillId = 0, BorderId = 1};
    CellFormat cellFormat3 = new CellFormat { FontId = 2, FillId = 3 };
    CellFormats cellFormats = new CellFormats(cellFormat0, cellFormat1, cellFormat2, cellFormat3);
    //Compose the Style Sheet
    Stylesheet styleSheet = new Stylesheet(fonts, fills, borders, cellFormats);
    return styleSheet;
}

</cellvalues></cellvalues></cellvalues></cellvalues></stringvalue></workbookstylespart></sheetdata></worksheetpart>