.Net 第三方库运用：ClosedXML

最新推荐文章于 2025-04-23 14:20:40 发布

lionheart922

最新推荐文章于 2025-04-23 14:20:40 发布

阅读量4.2k

点赞数 1

分类专栏： .Net第三方

本文链接：https://blog.csdn.net/lionheart922/article/details/100040397

版权

ClosedXML是一个.NET库，简化了创建Excel 2007/2010文件的过程。它提供了一种类似VBA的面向对象的方法来操作文件，而无需处理XML文档的复杂性。从C#到Visual Basic，任何.NET语言都可以使用。要下载最新代码，请访问https://github.com/ClosedXML/ClosedXML。示例代码展示了如何创建简单的Excel工作表文件，包括添加工作表、设置单元格值、定义表格范围、设置样式、合并单元格以及插入行和列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

什么是Closed Xml

ClosedXML makes it easier for developers to create Excel 2007/2010 files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).

哪里下载

Please refer to https://github.com/ClosedXML/ClosedXML to download the latest code

如何使用
How to create a simple excel sheet file
```
  public void Create(String filePath)
  {
     var workbook = new XLWorkbook();
     var worksheet = workbook.Worksheets.Add("Sample Sheet");
     worksheet.Cell("A1").Value = "Hello World!";
     workbook.SaveAs(filePath);
  }
```
The sample code demonstrate how to create a very simple excel sheet file. First, you need to create a workbook--XLWorkbook , then add a new sheet, then set value to cell: ‘A1’, then save to a specific path.

2. How to create basic table:

public void Create(string filePath)
        {
            // Creating a new workbook
            var wb = new XLWorkbook();

            //Adding a worksheet
            var ws = wb.Worksheets.Add("Contacts");

            //Adding text
            //Title
            ws.Cell("B2").Value = "Contacts";
            //First Names
            ws.Cell("B3").Value = "FName";
            ws.Cell("B4").Value = "John";
            ws.Cell("B5").Value = "Hank";
            ws.Cell("B6").Value = "Dagny";
            //Last Names
            ws.Cell("C3"