Tag: npoi

Unity uses NPOI library to operate Excel files

Unity uses the NPOI library to operate Excel files 1. Import the DLL of NPOI library Link: https://pan.baidu.com/s/1O29nSZdBsNM8hP_f6-bH1A?pwd=6666 Extraction code: 6666 – Sharing from Baidu Netdisk super member V4 2. Import the class library file into the Plugins folder. The class library file must be placed in the Plugins folder before it can be referenced […]

Unity configuration table reading – data storage – reading Excel files to cs files based on NPOI – reading xlsx files

Foreword In game companies, in order to facilitate the interaction of game data between programs and planners, Excel files are generally used. The program needs to write a program that reads xlsx files. It can export xlsx files to json, xml, cs files, etc. and store them for convenience. read This article introduces how to […]

Use NPOI in c# combined with Magicodes.IE.excel to convert xlsx files into xls files in memory

In the project, Magicodes.IE is used as the component to export excel, but it only supports the new format xlsx. If there is a need to export the old format xls file, we can only consider the conversion solution. After trying and searching through various solutions Related solutions: I found relevant code in an article […]

[Transfer] [NPOI] Use NPOI to read and write word

1. Introduction 1. Class library for operating Word: NPOI: V2.5.1 rapid generation https://github.com/tonyqus/npoi NPOI Baidu Cloud download: https://pan.baidu.com/s/13wiYmZ2txCq79CR-kj9Cvg Extraction code: 5x1v DocX (free version of Xceed Words for .NET): V1.6.0 https://github.com/xceedsoftware/DocX Aspose.Words: Charges Spire.Doc: Charges 2. Simple use 1. Instantiation of XWPFDocument class An instance of this class corresponds to a word document XWPFDocument MyDoc […]

c# NPOI operation Excel help class

public class ExcelHelp {<!– –> /// <summary> /// /// </summary> /// <typeparam name=”T”></typeparam> /// <param name=”list”>Data list</param> /// <param name=”file”>File address</param> /// <param name=”sheetnum”>sheet number</param> /// <param name=”titles”>Header name list</param> /// <param name=”startNumber”>Start line number</param> /// <exception cref=”Exception”></exception> public void ListToExcel<T>(List<T> list, string file, string sevefile, int sheetnum, List<string> titles, int startNumber) {<!– –> DataTable […]

Four solutions for reading and writing Excel in C# (OpenXml, NPOI, EPPlus, Spire.Office)

Preface In the project, you need to use C# to read and write Excel, and output data to the Excel table regularly every day. After referring to many solutions, we found 4 commonly used solutions and provided some small demos. For more functions and examples, please refer to the official documentation. 1. Microsoft.Office.Interop.Excel: Not recommended. […]

.NET Core6.0 uses NPOI to import and export Excel

1. Use NPOI to export Excel //Introduce NPOI package HTML <input type=”button” class=”layui-btn layui-btn-blue2 layui-btn-sm” id=”ExportExcel” onclick=”ExportExcel()” value=\ “Export” /> js //Export Excel function ExportExcel() {<!– –> window.location.href = “@Url.Action(“ExportFile”)”; } C# private readonly Microsoft.AspNetCore.Hosting.IHostingEnvironment _hostingEnvironment; public HomeController(Microsoft.AspNetCore.Hosting.IHostingEnvironment hostingEnvironment) {<!– –> _hostingEnvironment = hostingEnvironment; } [HttpGet(“ExportFile”)] //export file public async Task<IActionResult> ExportFile() {<!– –> //Get […]

c# uses NPOI to operate List to export excel

Need to introduce NPOI, download from Nuget General method, pro-test available public class NPOIHelper<T> where T : class { public static async Task<IActionResult> ExcelDataExrot(string tablename, List<T> list, List<string> ExcelTitle) { try { //Create Excel file object var workbook = new HSSFWorkbook(); //Create worksheet sheet0 var sheet = workbook. CreateSheet(tablename); //Set the top title style var […]