C# Net 使用 openxml 写入对象到 Excel 中(2)|C#教程

当前位置:

首页 > 编程开发 > C#编程 >

C#教程之C# Net 使用 openxml 写入对象到 Excel 中(2)

本站最新发布 C#从入门到精通
试听地址 https://www.xin3721.com/eschool/CSharpxin3721/

创建文件：ExcelCreate.cs

复制下面全部代码到文件 ExcelCreate.cs

using System;

using System.Collections.Generic;

using System.IO;

using System.Text;

using DocumentFormat.OpenXml;

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

namespace YCBX.Office.ExcelXml

{

    /// <summary>

    /// 创建Excel

    /// </summary>

    public class ExcelCreate

    {

        /// <summary>

        /// 新的空白Excel文档

        /// </summary>

        /// <returns></returns>

        public static void NewCreate(string path)

        {

            //创建 xlsx

            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(path, SpreadsheetDocumentType.Workbook);

            //将工作簿部件添加到文档中

            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();

            workbookpart.Workbook = new Workbook();

            //将工作表部分添加到工作簿部分

            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();

            worksheetPart.Worksheet = new Worksheet(new SheetData());

            //将工作表添加到工作簿

            Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.

                AppendChild<Sheets>(new Sheets());

            //附加新工作表并将其与工作簿关联

            Sheet sheet = new Sheet()

            {

                Id = spreadsheetDocument.WorkbookPart.

                GetIdOfPart(worksheetPart),

                SheetId = 1,

                Name = "Sheet1"

            };

            sheets.Append(sheet);

            workbookpart.Workbook.Save();

            spreadsheetDocument.Close();

        }

        /// <summary>

        /// 新的空白Excel文档

        /// </summary>

        /// <returns>临时的文件</returns>

        public static string NewCreate()

        {

            var file = Path.ChangeExtension(Path.GetRandomFileName(), ".xlsx");

            NewCreate(file);

            //var memoryStream = new MemoryStream(File.ReadAllBytes(tempFileName));

            return file;

        }

    }

}

栏目列表

首页 > 编程开发 > C#编程 >

C#教程之C# Net 使用 openxml 写入 对象 到 Excel 中(2)

C#教程之C# Net 使用 openxml 写入对象到 Excel 中(2)