Beispiel #1
0
        private void EndPackage()
        {
            string workbookPath      = "/xl/workbook.xml";
            string stylesheetPath    = "/xl/styles.xml";
            string sharedStringsPath = "/xl/sharedStrings.xml";

            var idCounter = _WorksheetInfos.Count + 1;

            int ridWb            = idCounter++;
            int ridStyles        = idCounter++;
            int ridSharedStrings = idCounter++;

            var wbEntry = _Package.CreateStream(workbookPath, _CompressionLevel);

            using (var stream = wbEntry.Open())
            {
                _Package.AddPackageRelationship(workbookPath, "http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument", "rId" + ridWb);
                _Package.AddContentType(workbookPath, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml");

                WriteWorkbookXml(stream);
            }

            var stylesEntry = _Package.CreateStream(stylesheetPath, _CompressionLevel);

            using (var stream = stylesEntry.Open())
            {
                _Package.AddPartRelationship(workbookPath, stylesheetPath, "http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles", "rId" + ridStyles);
                _Package.AddContentType(stylesheetPath, "application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml");

                WriteStylesXml(stream);
            }

            var sharedStringsEntry = _Package.CreateStream(sharedStringsPath, _CompressionLevel);

            _Package.AddPartRelationship(workbookPath, sharedStringsPath, "http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings", "rId" + ridSharedStrings);
            _Package.AddContentType(sharedStringsPath, "application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml");

            using (var stream = sharedStringsEntry.Open())
                using (var writer = new StreamWriter(stream))
                {
                    writer.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n");
                    writer.Write("<sst xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\" count=\"0\" uniqueCount=\"0\"></sst>");
                }

            foreach (var ws in _WorksheetInfos)
            {
                _Package.AddPartRelationship(workbookPath, ws.Path, "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet", "rId" + ws.Id);
                _Package.AddContentType(ws.Path, "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml");
            }

            _Package.CommitRelationships(_CompressionLevel);
            _Package.CommitContentTypes(_CompressionLevel);
            _Package.Close();

            _Package = null;
        }
Beispiel #2
0
        public ExcelSpreadsheetWriter(Stream outputStream, CompressionLevel compressionLevel = CompressionLevel.Fastest)
            : base(outputStream ?? new MemoryStream())
        {
            if (outputStream.GetType().FullName == "System.Web.HttpResponseStream")
            {
                outputStream = new WriteStreamWrapper(outputStream);
            }

            _Package = new PackageWriteStream(outputStream);

            _CompressionLevel = compressionLevel;
        }