/// <summary>
/// Creates style part
/// </summary>
/// <param name="workbookPart">The work book part.</param>
internal void CreateStylePart(WorkbookPart workbookPart)
{
WorkbookStylesPart stylesPart = workbookPart.AddNewPart <WorkbookStylesPart>();
Stylesheet styles = ExcelWriterHelper.CreateStylesheet();
styles.Save(stylesPart);
}
/// <summary>
/// Creates Content rows.
/// </summary>
/// <param name="sheetData">The sheet data.</param>
/// <param name="datatable">The data table.</param>
/// <param name="index">The index.</param>
/// <param name="rowCount">The row count.</param>
internal void CreateContent(SheetData sheetData, DataTable datatable, uint index, int rowCount)
{
for (int i = 0; i < rowCount; i++)
{
Row contentRow = ExcelWriterHelper.CreateContentRow(index++, datatable.Rows[i]);
sheetData.AppendChild(contentRow);
}
}
/// <summary>
/// Creates work sheet columns.
/// </summary>
/// <param name="worksheet">The work sheet.</param>
/// <param name="numCols">The count of columns.</param>
internal void CreateWorksheetColumns(Worksheet worksheet, int numCols)
{
Columns columns = new Columns();
for (int col = 0; col < numCols; col++)
{
Column column = ExcelWriterHelper.CreateColumnData((uint)col + 1, (uint)numCols + 1, 25);
columns.Append(column);
}
worksheet.Append(columns);
}
/// <summary>
/// Creates footer row.
/// </summary>
/// <param name="sheetData">The sheet data.</param>
/// <param name="index">The index.</param>
/// <param name="footer">The footer.</param>
internal void CreateFooterRow(SheetData sheetData, uint index, DataRow footer)
{
Row footerRow = ExcelWriterHelper.CreateFooterRow(index, footer);
sheetData.AppendChild(footerRow);
}
/// <summary>
/// Creates header row.
/// </summary>
/// <param name="sheetData">The sheet data.</param>
/// <param name="datatable">The data table.</param>
internal void CreateHeaderRow(SheetData sheetData, DataTable datatable)
{
Row headerRow = ExcelWriterHelper.CreateHeaderRow(1, datatable);
sheetData.AppendChild(headerRow);
}