首页 > 其他 > 详细

[OpenXml] Generate excel in memory and dump to file

时间:2015-07-27 14:49:36      阅读:148      评论:0      收藏:0      [点我收藏+]
public static void GenerateExcelFromStream()
{
    using (MemoryStream memoryStream = new MemoryStream()) {
        using (SpreadsheetDocument document = SpreadsheetDocument.Create(memoryStream, SpreadsheetDocumentType.Workbook)) {
            document.AddWorkbookPart();
            document.WorkbookPart.Workbook = new Workbook();

            document.WorkbookPart.AddNewPart<WorksheetPart>();
            document.WorkbookPart.WorksheetParts.First().Worksheet = new Worksheet();
            document.WorkbookPart.WorksheetParts.First().Worksheet.AppendChild(new SheetData());

            Row row = new Row();
            row.AppendChild<Cell>(new Cell() { CellValue = new CellValue("hahaasdfhkasddjjalsdkjflaksdjfladskjflj"), DataType = CellValues.String, CellReference = "A1" });
            document.WorkbookPart.WorksheetParts.First().Worksheet.First().AppendChild(row);
            document.WorkbookPart.WorksheetParts.First().Worksheet.Save();

            document.WorkbookPart.Workbook.AppendChild(new Sheets());
            document.WorkbookPart.Workbook.GetFirstChild<Sheets>().AppendChild(new Sheet() {
                Id = document.WorkbookPart.GetIdOfPart(document.WorkbookPart.WorksheetParts.First()),
                SheetId = 1,
                Name = "sheet1"
            });
            document.WorkbookPart.Workbook.Save(); 
        }

        using (FileStream fileStream = File.Create("generateExcel.xlsx")) {
            memoryStream.WriteTo(fileStream);
        }
    }
}

 

[OpenXml] Generate excel in memory and dump to file

原文:http://www.cnblogs.com/webglcn/p/4679899.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!