VB.net 2010 视频教程 VB.net 2010 视频教程 python基础视频教程
SQL Server 2008 视频教程 c#入门经典教程 Visual Basic从门到精通视频教程
当前位置:
首页 > Python基础教程 >

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

　　

创建文件：ExcelCreate.cs

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

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
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;
        }
    }
}

相关教程