c#操作npoi完整代码资源-CSDN文库

共164个文件

dll：39个

_：26个

xml：20个

需积分: 5 152 浏览量 2023-05-16 13:14:00 上传评论收藏 12.94MB 7Z 举报

NPOI是一个强大的.NET库，专门用于处理Microsoft Office文件格式，如Excel（XLS和XLSX）和Word（DOC和DOCX）。在C#中使用NPOI，开发者可以轻松地读取、写入和操作这些文件，而无需依赖Microsoft Office本身。本教程将深入探讨如何使用C#和NPOI进行Excel操作。 1. **安装NPOI** 在你的C#项目中使用NPOI，首先需要通过NuGet包管理器来安装它。在Visual Studio中，打开包管理控制台并运行以下命令： ``` Install-Package NPOI ``` 2. **创建Excel文件** 创建一个新的Excel工作簿，你需要实例化`HSSFWorkbook`（用于旧的.xls格式）或`XSSFWorkbook`（用于新的.xlsx格式）类。例如，创建一个.xlsx文件： ```csharp using NPOI.XSSF.UserModel; XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet sheet = workbook.CreateSheet("Sheet1"); ``` 3. **添加行和单元格** 要向工作表中添加数据，你需要创建`XSSFRow`对象并在其中创建`XSSFCell`。例如，向第一行添加一个值： ```csharp XSSFRow row = sheet.CreateRow(0); XSSFCell cell = row.CreateCell(0); cell.SetCellValue("Hello, NPOI!"); ``` 4. **设置单元格样式** NPOI允许你定义单元格的样式，包括字体、对齐方式、边框等。例如，设置单元格为粗体： ```csharp IFont font = workbook.CreateFont(); font.FontHeightInPoints = (short)12; font.Bold = true; ICellStyle style = workbook.CreateCellStyle(); style.SetFont(font); cell.CellStyle = style; ``` 5. **读取Excel文件** 要读取Excel文件，你需要使用`XSSFWorkbook`的静态方法`OpenInputStream`。例如： ```csharp using (FileStream stream = File.OpenRead("input.xlsx")) { XSSFWorkbook workbook = new XSSFWorkbook(stream); XSSFSheet sheet = workbook.GetSheetAt(0); // 读取数据... } ``` 6. **遍历单元格数据** 遍历工作表中的行和单元格，你可以使用`foreach`循环： ```csharp foreach (IRow row in sheet) { foreach (ICell cell in row) { string cellValue = cell.ToString(); Console.WriteLine(cellValue); } } ``` 7. **保存和关闭文件** 完成修改后，记得保存并关闭工作簿： ```csharp using (FileStream file = File.Create("output.xlsx")) { workbook.Write(file); } workbook.Close(); ``` 8. **高级功能** NPOI还支持更复杂的操作，如公式计算、图表创建、图片插入等。例如，插入图片： ```csharp XSSFClientAnchor anchor = new XSSFClientAnchor(); anchor.Dx1 = 0; anchor.Dy1 = 0; anchor.Dx2 = 100; anchor.Dy2 = 100; Drawing drawings = sheet.CreateDrawingPatriarch(); XSSFImagePart imagePart = (XSSFImagePart)workbook.AddPicture( Image.FromFile("image.jpg"), XSSFPictureData.PictureType.JPEG); XSSFPicture picture = drawings.CreatePicture(anchor, imagePart.Id); ``` 9. **异常处理** 在实际开发中，确保处理可能出现的异常，例如文件不存在或无法读取时的异常： ```csharp try { // 读写操作... } catch (FileNotFoundException ex) { Console.WriteLine("文件未找到: " + ex.Message); } catch (IOException ex) { Console.WriteLine("读写错误: " + ex.Message); } ``` 通过以上步骤，你已经掌握了C#操作NPOI的基本用法。结合实际情况，你可以根据需求实现更复杂的功能，如数据导出、数据分析等。NPOI是一个强大且灵活的工具，对于处理Office文件，尤其是大量数据操作，它是一个非常实用的选择。

资源推荐

资源详情

资源评论

收起资源包目录

c# 操作npoi完整代码（164个子文件）

_._ 0B

_IsIncrementalBuild 32B

DesignTimeResolveAssemblyReferencesInput.cache 21KB

WindowsFormsApp1.csproj.AssemblyReference.cache 14KB

DesignTimeResolveAssemblyReferences.cache 2KB

WindowsFormsApp1.csproj.GenerateResource.cache 126B

WindowsFormsApp1.csproj.CoreCompileInputs.cache 42B

WindowsFormsApp1.csproj.SuggestedBindingRedirects.cache 0B

packages.config 746B

App.config 187B

WindowsFormsApp1.exe.config 187B

WindowsFormsApp1.csproj.CopyComplete 0B

Form1.cs 11KB

ExcelOperationHelper.cs 8KB

Form1.Designer.cs 6KB

Resources.Designer.cs 3KB

log.cs 2KB

ExcelDataResource.cs 2KB

AssemblyInfo.cs 1KB

Settings.Designer.cs 1KB

Program.cs 537B

TitleAttribute.cs 369B

.NETFramework,Version=v4.8.AssemblyAttributes.cs 210B

WindowsFormsApp1.csproj 6KB

NPOI.OpenXmlFormats.dll 2.25MB

NPOI.dll 1.8MB

System.Text.Encoding.CodePages.dll 749KB

System.Text.Encoding.CodePages.dll 744KB

System.Text.Encoding.CodePages.dll 742KB

System.Text.Encoding.CodePages.dll 741KB

System.Drawing.Common.dll 658KB

System.Drawing.Common.dll 639KB

NPOI.OOXML.dll 566KB

NPOI.OOXML.dll 565KB

ICSharpCode.SharpZipLib.dll 194KB

System.Drawing.Common.dll 140KB

System.Drawing.Common.dll 117KB

NPOI.OpenXml4Net.dll 97KB

System.Drawing.Common.dll 50KB

System.Drawing.Common.dll 26KB

System.Runtime.CompilerServices.Unsafe.dll 23KB

System.Runtime.CompilerServices.Unsafe.dll 22KB

System.Text.Encoding.CodePages.dll 21KB

System.Runtime.CompilerServices.Unsafe.dll 21KB

WindowsFormsApp1.exe 17KB

read.lock 0B

System.Text.Encoding.CodePages.4.5.0.nupkg 4.07MB

DotNetCore.NPOI.OpenXmlFormats.1.2.3.nupkg 1.33MB

DotNetCore.NPOI.Core.1.2.3.nupkg 1.26MB

System.Drawing.Common.4.5.0.nupkg 609KB

DotNetCore.NPOI.1.2.3.nupkg 480KB

SharpZipLib.1.2.0.nupkg 404KB

System.Runtime.CompilerServices.Unsafe.4.5.0.nupkg 101KB

DotNetCore.NPOI.OpenXml4Net.1.2.3.nupkg 87KB

.signature.p7s 22KB

共 164 条

.NET Core uses third-party libraries or other resources that may be distributed under licenses different than the .NET Core software. In the event that we accidentally failed to list a required notice, please bring it to our attention. Post an issue or email us: dotnet@microsoft.com The attached notices are provided for information only. License notice for Slicing-by-8 ------------------------------- http://sourceforge.net/projects/slicing-by-8/ Copyright (c) 2004-2006 Intel Corporation - All Rights Reserved This software program is licensed subject to the BSD License, available at http://www.opensource.org/licenses/bsd-license.html. License notice for Unicode data ------------------------------- http://www.unicode.org/copyright.html#License Copyright © 1991-2017 Unicode, Inc. All rights reserved. Distributed under the Terms of Use in http://www.unicode.org/copyright.html. Permission is hereby granted, free of charge, to any person obtaining a copy of the Unicode data files and any associated documentation (the "Data Files") or Unicode software and any associated documentation (the "Software") to deal in the Data Files or Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the Data Files or Software, and to permit persons to whom the Data Files or Software are furnished to do so, provided that either (a) this copyright and permission notice appear with all copies of the Data Files or Software, or (b) this copyright and permission notice appear in associated Documentation. THE DATA FILES AND SOFTWARE ARE PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THE DATA FILES OR SOFTWARE. Except as contained in this notice, the name of a copyright holder shall not be used in advertising or otherwise to promote the sale, use or other dealings in these Data Files or Software without prior written authorization of the copyright holder. License notice for Zlib ----------------------- https://github.com/madler/zlib http://zlib.net/zlib_license.html /* zlib.h -- interface of the 'zlib' general purpose compression library version 1.2.11, January 15th, 2017 Copyright (C) 1995-2017 Jean-loup Gailly and Mark Adler This software is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software. Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions: 1. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required. 2. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 3. This notice may not be removed or altered from any source distribution. Jean-loup Gailly Mark Adler jloup@gzip.org madler@alumni.caltech.edu */ License notice for Mono ------------------------------- http://www.mono-project.com/docs/about-mono/ Copyright (c) .NET Foundation Contributors MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the Software), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. License notice for International Organization for Standardization ----------------------------------------------------------------- Portions (C) International Organization for Standardization 1986: Permission to copy in any form is granted for use with conforming SGML systems and applications as defined in ISO 8879, provided this notice is included in all copies. License notice for Intel ------------------------ "Copyright (c) 2004-2006 Intel Corporation - All Rights Reserved Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. License notice for Xamarin and Novell ------------------------------------- Copyright (c) 2015 Xamarin, Inc (http://www.xamarin.com) Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. Copyright (c) 2011 Novel

评论收藏

内容反馈