public static uint AddTitleRow(uint rowIndex, string modelName, string[] excelColumnNames, string reportTitle, SheetData sheetData)
{
var titleRow = new Row {
RowIndex = rowIndex
}; // add a row at the to name the fields of spreadsheet
OpenXmlSpreadsheetUtilities.AppendTextCell
(excelColumnNames[0] + rowIndex.ToString(), reportTitle, titleRow, CellValues.String, OpenXmlSpreadsheetUtilities.BOLD_CELL);
sheetData.Append(titleRow);
rowIndex++;
return(rowIndex);
}
public static uint AddHeaderRows(uint rowIndex, string modelName, string[] excelColumnNames, List <string> contents, SheetData sheetData)
{
foreach (string content in contents)
{
var titleRow = new Row {
RowIndex = rowIndex
}; // add a row at the to name the fields of spreadsheet
OpenXmlSpreadsheetUtilities.AppendTextCell
(excelColumnNames[0] + rowIndex.ToString(), content, titleRow, CellValues.String, OpenXmlSpreadsheetUtilities.BOLD_CELL);
sheetData.Append(titleRow);
rowIndex++;
}
return(rowIndex);
}
public static MemoryStream MakeSpreadSheet(Worksheet workSheet, SheetData sheetData, string modelName)
{
MemoryStream stream = new MemoryStream();
using (SpreadsheetDocument document = SpreadsheetDocument.Create(stream, DocumentFormat.OpenXml.SpreadsheetDocumentType.Workbook, true))
{
document.AddWorkbookPart();
document.WorkbookPart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();
document.WorkbookPart.Workbook.Append(new BookViews(new WorkbookView()));
WorkbookStylesPart workbookStylesPart = document.WorkbookPart.AddNewPart <WorkbookStylesPart>("rIdStyles");
Stylesheet stylesheet = OpenXmlSpreadsheetUtilities.GenerateStyleSheet();
workbookStylesPart.Stylesheet = stylesheet;
uint worksheetNumber = 1;
string workSheetID = "rId" + worksheetNumber.ToString();
string worksheetName = "Export";
WorksheetPart newWorksheetPart = document.WorkbookPart.AddNewPart <WorksheetPart>();
newWorksheetPart.Worksheet = workSheet;
newWorksheetPart.Worksheet.AppendChild(sheetData);
newWorksheetPart.Worksheet.Save();
if (worksheetNumber == 1)
{
document.WorkbookPart.Workbook.AppendChild(new DocumentFormat.OpenXml.Spreadsheet.Sheets());
}
document.WorkbookPart.Workbook.GetFirstChild <DocumentFormat.OpenXml.Spreadsheet.Sheets>().AppendChild(new DocumentFormat.OpenXml.Spreadsheet.Sheet()
{
Id = document.WorkbookPart.GetIdOfPart(newWorksheetPart),
SheetId = (uint)worksheetNumber,
Name = worksheetName
});
document.WorkbookPart.Workbook.Save();
}
stream.Flush();
stream.Position = 0;
return(stream);
}
