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(); }