最小的Excel文档

最新推荐文章于 2025-07-04 19:35:49 发布

勾吴江南

最新推荐文章于 2025-07-04 19:35:49 发布

阅读量858

点赞数

CC 4.0 BY-SA版权

分类专栏： OpenXml C# Spreadsheet Document Visual Studio 2010 OpenXml SDK2.0 Office Development 文章标签： excel openxml object string 文档 button

本文链接：https://blog.youkuaiyun.com/TX_OfficeDev/article/details/7075588

Office Development 同时被 3 个专栏收录

134 篇文章

订阅专栏

63 篇文章

订阅专栏

Visual Studio 2010

40 篇文章

订阅专栏

这是一个空白的Excel文档，只有一个WorkSheet。能省略的东西我都省略了。

实现环境：Visual Studio 2010, OpenXml SDK 2.0.50727

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Spreadsheet;
using DocumentFormat.OpenXml.Packaging;

namespace OpenXmlCreatExcelDocument
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string strPath = null;
            SaveFileDialog objSaveFileDialog = new SaveFileDialog();
            objSaveFileDialog.Filter = "Excel Document (*.xlsx)|*.xlsx";
            objSaveFileDialog.ShowDialog();
            strPath = objSaveFileDialog.FileName;
            if (strPath.Length > 0)
            {
                using (SpreadsheetDocument objDocument = 
                    SpreadsheetDocument.Create(strPath, 
SpreadsheetDocumentType.Workbook))
                {
                    WorkbookPart objWorkbookPart = 
                        objDocument.AddWorkbookPart();
                    WorksheetPart objWorksheetPart =
                         objWorkbookPart.AddNewPart<WorksheetPart>();
                    string strWorkSheetPartrId =
                         objWorkbookPart.GetIdOfPart(objWorksheetPart);
                    objWorksheetPart.Worksheet = new Worksheet();
                    SheetData objSheetData = new SheetData();
                    objWorksheetPart.Worksheet.Append(objSheetData);
                    Sheets objSheets = new Sheets();
                    Sheet objSheet = new Sheet() 
                    { 
                        Name = "MySheet", 
                        SheetId = (UInt32Value)1U, 
                        Id = strWorkSheetPartrId 
                    };
                    objSheets.Append(objSheet);
                    objWorkbookPart.Workbook = new Workbook();
                    objWorkbookPart.Workbook.Append(objSheets);
                }
            }
        }
    }