HSSFWorkbook操作excel读写//exlel读操作MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;Iterator<String> iter = multipartRequest.getFileNames();File fileFile = null;while (iter.hasNext()) {MultipartFile multipa…
HSSFWorkbook操作excel读写//exlel读操作MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;Iterator<String> iter = multipartRequest.getFileNames();File fileFile = null;while (iter.hasNext()) {MultipartFile multipa…
1. System.IO命名空间System.IO中存在Directory类,提供了获取应用程序运行当前目录的静态方法 System.IO.Directory.GetCurrentDirectory()=>Gets the current working directory of the application, 在.net core中此方法是执行dotnet命令所在的目录.class Program …
public class JSON2DictConverter : JsonConverter { public override bool CanConvert(Type objectType) { bool match = (objectType == typeof(object)); return match; } public override object ReadJs…
这里用到了NPOI这个第三方插件实现对Excel数据的写入和读取写入 <span style="font-family:Microsoft YaHei;font-size:18px;">List<person> list = new List<person>() { new person (){Name ="lun&…
public class SqlsugarHelper { static string ConnectionString = string.Empty; static SqlSugar.DbType dbtype = SqlSugar.DbType.SqlServer; SqlsugarHelper( SqlSugar.DbType dbtype) { if(dbtype== SqlSuga…
大数据操作ORM性能瓶颈在实体转换上面，并且不能使用常规的Sql去实现当列越多转换越慢，SqlSugar将转换性能做到极致，并且采用数据库最佳API操作数据库达到极限性能功能用法BulkCopy 性能远强于现有市场的 ORM框架，比 EFCore Efcore.Bulkextension 快30%BulkUpdate 吊打…
一、新建泛型辅助类SqlSugarHelper.cs,用于创建数据库连接 /// <summary> /// SqlSugar的辅助方法 /// </summary> /// <typeparam name="T"></typeparam> public class SqlSugarHelper<T> where …
public ActionResult testImport(string path){ string[] columnsStr = new string[] {"dataType", "customerCode", "factory", "projectNo", "countrieType", "productCategory", "modelName&q…
版本：.net framework 4.6.1Quartz.net：Quartz Scheduling Framework for .NET 3.2.4首先使用VS 创建工程->NuGet 中引用Quartz；使用Quartz分为五步：<1> 创建一个ISchedulerFactory，然后并且获取 Scheduler ISchedulerFactory schedFact = new Std…
这个是记录，单元格的图片。直接上代码，直接新建一个 net core api 解决方案，引用一下nuget包。本地创建一个 .xlsx 格式的excel文件using ICSharpCode.SharpZipLib.Zip;using Microsoft.AspNetCore.Mvc;using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using NPOI.…
© Copyright 2014 - 2025 柏港建站平台 ejk5.com. 渝ICP备16000791号-4