C#NPOI2.5.6库，并说明使用方法_npoi最新版本资源-CSDN文库

共41个文件

pdb：12个

dll：12个

xml：7个

需积分: 2 200 浏览量 2023-09-16 16:57:29 上传评论收藏 21.23MB ZIP 举报

NPOI是一个强大的开源库，尤其在C#编程环境中，它为处理Microsoft Office文档提供了极大的便利。这个库的版本2.5.6专注于对Excel、Word和PowerPoint等文件的读写操作。以下是对NPOI 2.5.6在C#中使用方法的详细说明。 ### 1. 安装NPOI库你需要通过NuGet包管理器在你的C#项目中安装NPOI库。在Visual Studio中，右键点击你的项目，选择“管理NuGet程序包”，然后在搜索框中输入“NPOI”。找到NPOI 2.5.6并安装。 ### 2. Excel操作 #### 2.1 读取Excel文件使用NPOI可以方便地读取XLS和XLSX格式的Excel文件。以下代码展示了如何打开一个Excel文件并读取第一张工作表的数据： ```csharp using NPOI.SS.UserModel; using NPOI.XSSF.UserModel; // 打开Excel文件 FileStream file = new FileStream("path_to_your_file.xlsx", FileMode.Open, FileAccess.Read); var workbook = new XSSFWorkbook(file); // 获取第一个工作表 ISheet sheet = workbook.GetSheetAt(0); // 遍历行数据 for (int rowIndex = 0; rowIndex < sheet.LastRowNum + 1; rowIndex++) { IRow row = sheet.GetRow(rowIndex); if (row != null) { // 遍历单元格数据 for (int cellIndex = 0; cellIndex < row.LastCellNum; cellIndex++) { ICell cell = row.GetCell(cellIndex); if (cell != null) Console.WriteLine(cell.ToString()); } } } // 关闭文件流 file.Close(); ``` #### 2.2 写入Excel文件创建新的Excel文件或向现有文件添加数据也很简单： ```csharp // 创建新工作簿 workbook = new XSSFWorkbook(); // 添加新工作表 ISheet sheet = workbook.CreateSheet("Sheet1"); // 写入数据 IRow row = sheet.CreateRow(0); ICell cell = row.CreateCell(0); cell.SetCellValue("Hello, World!"); // 写入文件 using (FileStream stream = new FileStream("output.xlsx", FileMode.Create, FileAccess.Write)) { workbook.Write(stream); } ``` ### 3. Word操作 NPOI对于Word文档的处理能力相对较弱，主要支持读取。以下代码展示了如何读取一个DOCX文件的内容： ```csharp using NPOI.XWPF.UserModel; // 打开Word文件 FileStream file = new FileStream("path_to_your_file.docx", FileMode.Open, FileAccess.Read); XWPFDocument document = new XWPFDocument(file); // 读取段落 foreach (XWPFParagraph paragraph in document.Paragraphs) { Console.WriteLine(paragraph.Text); } // 关闭文件流 file.Close(); ``` ### 4. PowerPoint操作 NPOI同样支持读取PPTX文件，但不支持写入。以下代码展示了如何读取幻灯片的文本内容： ```csharp using NPOI.PPTX.UserModel; // 打开PowerPoint文件 FileStream file = new FileStream("path_to_your_file.pptx", FileMode.Open, FileAccess.Read); XSLFSlideShow slideshow = new XSLFSlideShow(file); // 读取每张幻灯片的文本 foreach (XSLFSlide slide in slideshow.Slides) { StringBuilder slideText = new StringBuilder(); foreach (XSLFShape shape in slide.Shapes) { if (shape is XSLFTextShape) { slideText.Append(shape.Text); } } Console.WriteLine($"Slide Text: {slideText}"); } // 关闭文件流 file.Close(); ``` NPOI 2.5.6库提供了灵活且高效的API，使开发者能够在C#中轻松处理Office文档。尽管它在某些功能上可能有限（如Word写入和PowerPoint编辑），但在读取和创建Excel文件方面，NPOI无疑是一个强大而可靠的工具。

资源推荐

资源详情

资源评论

收起资源包目录

NPOI.2.5.6.zip （41个子文件）

NPOI.2.5.6

lib

net45

NPOI.OpenXmlFormats.dll 2.02MB

NPOI.OpenXml4Net.XML 162KB

NPOI.OpenXml4Net.dll 95KB

NPOI.pdb 5.58MB

NPOI.OOXML.XML 623KB

NPOI.OOXML.dll 616KB

NPOI.OOXML.pdb 1.74MB

NPOI.OpenXml4Net.pdb 244KB

NPOI.dll 1.7MB

NPOI.XML 2.28MB

NPOI.OpenXmlFormats.pdb 5.73MB

netstandard2.1

NPOI.OpenXmlFormats.dll 2.03MB

NPOI.OpenXml4Net.dll 98KB

NPOI.pdb 842KB

NPOI.OOXML.dll 619KB

NPOI.OOXML.pdb 283KB

NPOI.xml 2.3MB

NPOI.OpenXml4Net.pdb 46KB

NPOI.dll 1.73MB

NPOI.OOXML.xml 623KB

NPOI.OpenXmlFormats.pdb 794KB

netstandard2.0

NPOI.OpenXmlFormats.dll 2.03MB

NPOI.OpenXml4Net.dll 98KB

NPOI.pdb 841KB

NPOI.OOXML.dll 619KB

NPOI.OOXML.pdb 282KB

NPOI.xml 2.3MB

NPOI.OpenXml4Net.pdb 46KB

NPOI.dll 1.73MB

NPOI.OOXML.xml 623KB

NPOI.OpenXmlFormats.pdb 793KB

可以在这选择版本.png 269KB

LICENSE 10KB

logo

32_32.jpg 2KB

120_120.jpg 8KB

240_240.png 15KB

60_60.jpg 4KB

操作office库项目引用.png 19KB

NPOI.2.5.6.nupkg 10.51MB

Read Me.txt 4KB

.signature.p7s 9KB

================ * Introduction * ================ This project is the .NET port of POI project. With NPOI, you can read/write Excel and Word files easily. It has a wide application. For example, you can use it a to generate a Excel report without Microsoft Office suite installed on your server and more efficient than call Microsoft Excel ActiveX at background; you can also use it to extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines). ========================= * Nissl Introduction * ========================= NPOI was used to be maintained by Neuzilla ( Tony's first startup company). After Neuzilla is closed in 2018, Nissl Lab maintains NPOI. Nissl Lab is a NGO org created by Nissl LLC. The trademake NPOI is hold by Nissl in order to avoid abuse. ================== * NPOI Source Code * ================== https://github.com/nissl-lab/npoi/ ================== * LICENSE COMPLIANCE * ================== You are NOT allowed to remove NPOI logo or Nissl/Neuzilla brand (even text). This is a must of Apache license. This shows basic respects to the previous contributors of NPOI. You must state that you are using NPOI no matter you are creating a commercial product or an open source project. ====================== * System Requirement * ====================== VS2015 and above medium trust environment in ASP.NET ================= * Nissl in social network * ================= Linkedin: https://www.linkedin.com/company/nissl Github: https://github.com/nissl-lab ================ * Team Members * ================ Tony Qu - coodinator, developer ------------------------------- From: Shanghai, China Participated since Sep, 2008 Time Zone: GMT+8 -------------------------------------------------------------------------------- NPOI 1.2.1 -------------------------------------------------------------------------------- Huseyin Turfekcilerli - developer -------------------- From: Istanbul, Turkey Participated since Nov, 2008 Time Zone: GMT+2 Main Contribution: POIFS Browser 1.0 aTao Xiang - Technical writer ----------- From: China Participated since Aug, 2009 Time Zone: GMT+8 Main Contribution: NPOI 1.2 Chinese Tutorial -------------------------------------------------------------------------------- NPOI 1.2.3 - NPOI 1.2.5 -------------------------------------------------------------------------------- Antony - developer ------------------------------ From: Guangzhou, China Time Zone: GMT+8 Main Contribution: main code,bug fixing ,Excel2Html, Word2Html Christian Leutloff - developer ------------------------------ From: Germany Time Zone: GMT+1 Main Contribution: fix FXCop warnings, OOXML Jeff Stedfast - developer ------------------------------ From: Cambridge, MA, USA Time Zone: GMT Main contribution: Mono version of NPOI, naming conversion Leon Wang - developer ----------------------------- From: Xi'an, China Time Zone: GMT+8 Main contribution: NPOIFS/POIFS NPOI 2.0 -------------------------------------------------------------------------------- Tony Qu - chief developer ------------------------------- From: Shanghai, China Time Zone: GMT+8 Main Contribution: OpenXml4Net, OpenXmlFormats, NPOI.XSSF, NPOI.XWPF implementation Antony - developer ------------------------------ From: Guangzhou, China Time Zone: GMT+8 Main Contribution: XWPF implementation, OpenXmlFormats Christian Leutloff - developer ------------------------------ From: Germany Time Zone: GMT+1 Main Contribution: OpenXmlFormats, Excel 2007 comment read Jeff Stedfast - developer ------------------------------ From: Cambridge, MA, USA Time Zone: GMT Main contribution: Mono version of NPOI, enumeration changes and compilation optimization Paul Kratt - developer ------------------------------ From: Greater Milwaukee Area, Wisconsin, USA Time Zone: GMT Main contribution: CopyTo, CopySheet functions in HSSFSheet NPOI 2.1 -------------------------------------------------------------------------------- Tony Qu - main contributor Antony - fix some poi bugs Phil Rykoff - developer ------------------------------ Main contribution: XSSF bug fixing and feature implement NPOI 2.2 ~ 2.5.2 -------------------------------------------------------------------------------- Antony Tony Qu

评论收藏

内容反馈