public void CreateWorksheet(uint index, XlsxSheet xlsxSheet)
{
// Append a new worksheet and associate it with the workbook.
// Add a WorksheetPart to the WorkbookPart.
WorksheetPart worksheetPart = WorkbookPart.AddNewPart <WorksheetPart>();
SheetData = new SheetData();
worksheetPart.Worksheet = new Worksheet(SheetData);
Sheets.Append(new Sheet {
Id = SsDoc.WorkbookPart.GetIdOfPart(worksheetPart),
SheetId = index,
Name = xlsxSheet.SheetName
});
}
private static IList <IXlsxSheet> SetSheets()
{
IList <IXlsxSheet> sheets = new List <IXlsxSheet>();
XlsxSheet sheet = new XlsxSheet();
sheet.SheetName = "Just to test";
IXlsxFill fill1 = new XlsxFill {
PatternType = PatternType.DarkTrellis
};
IXlsxFill fill2 = new XlsxFill {
PatternType = PatternType.LightTrellis,
BackgroundColorArgb = "FF0000FF"
};
IXlsxBorder border1 = new XlsxBorder {
TopBorder = BorderType.Dashed,
RightBorder = BorderType.Double
};
IXlsxBorder border2 = new XlsxBorder {
DiagonalBorder = BorderType.MediumDashDot
};
XlsxCell[] header = new XlsxCell[] {
new XlsxCell("Name")
{
Fill = fill1, Border = border1
},
new XlsxCell("Zahl")
{
Fill = fill1, Border = border1
},
new XlsxCell("Datum")
{
Fill = fill1, Border = border1
}
};
XlsxCell[] row1 = new XlsxCell[] {
new XlsxCell("Sanjay", new XlsxFont {
FontType = FontType.Calibri,
Bold = true,
Italic = true,
Size = 13,
UnderlineType = UnderlineType.DoubleLine,
ColorArgb = "FF00FF00"
})
{
Fill = fill1
},
new XlsxCell(5.2765)
{
Fill = fill2
},
new XlsxCell(new DateTime(2018, 1, 1, 12, 12, 12))
{
Border = border2
}
};
IXlsxCell[][] cells = new XlsxCell[][] {
header,
row1
};
sheet.Cells = cells;
sheets.Add(sheet);
return(sheets);
}
