java 时间相减精度确实 中间的不能直接取整数 long time = new Date().getTime(); long time1 = item.getAcate().getTime(); long l1 = time - time1; double v1 = l1 * item.getCgress() * 0.01; double v = time1 + v1; long l = new Double(v).longValue(); return..
vsto 批量删除列 list.add("S1"); list.add("D5");string address = string.Join(",", list.ToArray()); worksheet.get_Range(address, Type.Missing).EntireColumn.Delete(0);
vsto excel 批量sheet删除 var list = new List<string>(); wk.Worksheets[list.ToArray()].Select(); wk.Application.ActiveWindow.SelectedSheets.Delete();
java List＜Date＞ 获取集合日期最早的 Date date = null; List<Date> list=new ArrayList<>();date = Collections.min(list);
c# File.ReadAllText 会自动释放内存 File.ReadAllText(“a.text”, System.Text.Encoding.GetEncoding("gbk"))File.ReadAllText Method (System.IO) | Microsoft Docs
vsto 判断sheet是否存在 //如果为null就是没有public static class WorkbookExtensions{ public static Excel.Worksheet GetWorksheetByName(this Excel.Workbook workbook, string name) { return workbook.Worksheets.OfType<Excel.Worksheet>().FirstOrDefault(ws => ws.Name.
c# http模拟post请求，解决参数很大的情况 public static string HttpPost(string url, Dictionary<string, string> parms) { try { string result = string.Empty; //设置Http的正文 FormUrlEncodedContent httpContent =...
MyBatis Generator驼峰命名 <table schema="fb" tableName="table" domainObjectName="table" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"> <property name="useActualColu..
vsto excel 报错 无法将类型为“Microsoft.Office.Interop.Excel.ApplicationClass”的 COM 对象强制转换为接口类型“Microsoft.Office.Interop.Excel._Application”。此操作失败的原因是对 IID 为“{000208D5-0000-0000-C000-000000000046}”的接口的 COM 组件调用 QueryInterface 因以下错误而失败: 加载类型库/DLL 时出错。 (异常来自 HRESULT:0x80029C4A (TY
c# datatable 转二维数组 cint col = dt.Columns.Count; string[,] array = new string[dt.Rows.Count, col]; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { array[i, j] = Convert.ToString(dt.Rows[i]
vsto 宏xlsm文件转化为xlsx文件 NewWorkbook.SaveAs(savepath, Excel.XlFileFormat.xlWorkbookDefault, "", "", Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, 1, false, Type.Missing, Type.Missing, Type.Missing);namespace Microsoft.Office.Interop.Excel{ // // 摘要: ..
excel vlookup技巧判断两列值是否一致 =IF(ISERROR(VLOOKUP(B3,Sheet3!$C$4:$C$152,1,0)),"不重复","重复")当前sheetB3的值在sheet3中查找是否存在
git bash 统计开发者某段时间代码行数 单个人：git log --author=Json --since=2021-01-01 --until=2021-12-31 --format='%aN' | sort -u | while read name; do echo -en "$name\t"; git log --author="$name" --pretty=tformat: --numstat | grep "\(.html\|.cs\|.xml\)$" | awk '{ add += $1; subs += $2; loc +
excel 导入xml转换成列表数据 <bookstore><book category="children"><title lang="en">Harry Potter</title><author>J K. Rowling</author><year>2005</year><price>29.99</price></book><book category="cooking">...
excel vsto 功能菜单定义 有两种方式第一种可视化操作，第二种在可视化的界面右键【导出xml】using System;using System.Collections.Generic;using System.IO;using System.Linq;using System.Reflection;using System.Runtime.InteropServices;using System.Text;using Office = Microsoft.Office.Core;// TODO:.
