public RenderSpreadSheetDocument_OpenXmlSdk(Report report, IStreamGen sg)
: base(report, sg)
{
_ms = new MemoryStream();
_spreadSheet = SpreadsheetDocument.Create(_ms, SpreadsheetDocumentType.Workbook);
_openXmlExportHelper = new OpenXmlWriterHelper();
_workbook = new Workbook();
_workSheetSettings = new List<WorkSheetSetting>();
}
protected internal override void CreateDocument()
{
Report r = base.Report();
_workbookPart = _spreadSheet.AddWorkbookPart();
var openXmlExportHelper = new OpenXmlWriterHelper();
_styleSheet = openXmlExportHelper.CreateDefaultStylesheet();
_workbookPart.Workbook = _workbook;
var sheets = _workbook.AppendChild<Sheets>(new Sheets());
// create worksheet 1
var worksheetPart =_workbookPart.AddNewPart<WorksheetPart>();
var sheet = new Sheet() { Id = _workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = r.Name };
sheets.Append(sheet);
_workSheetSettings.Add(new WorkSheetSetting(r.Name));
_writer = OpenXmlWriter.Create(worksheetPart);
_writer.WriteStartElement(new Worksheet());
_writer.WriteStartElement(new SheetData());
_currentWorkSheet = _workSheetSettings.Last();
}
