- 博客(11)
- 资源 (1)
- 收藏
- 关注
转载 IntellIJ IDEA 配置 Maven 以及 修改 默认 Repository
今天将IntellIJ IDEA 关于Maven的配置总结一下,方便以后可参考。IDEA版本:IntelliJ IDEA 2019.3.4 (Ultimate Edition)Build #IU-193.6911.18, built on March 17, 2020Licensed to phpdragonRuntime version: 11.0.6+8-b520.43 amd64VM: OpenJDK 64-Bit Server VM by JetBrains s.r.oWindows
2020-07-14 19:01:46
442
原创 IDEA中如何手动引入jar包
1.打开Maven项目,选择File-Project Structure。2.在打开的窗口中左边菜单列表中选择Modules,点击上方的dependencies,然后点击+,在弹出的菜单栏中选择JARs or directories。3.在打开的文件管理器中,选择要导入的jar包即可引入到项目中来。4.引入的jar包可以在dependencies窗口中查看,引入完成后选择OK即可。5.添加好项目的jar包之后,可以在项目文件夹External Libraries中查看。...
2020-07-14 18:48:53
4357
原创 DataCompare
package excel;import org.apache.poi.hssf.usermodel.HSSFDateUtil;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.*;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import java.io.*;import java.text.DecimalFormat
2020-06-15 21:20:11
444
原创 VBA
Sub NewToNewCICO()Dim OldReportFolderDim NewReportFolderDim CompareResultFolder'Dim wkTemplate As WorkbookDim xlapp As Excel.ApplicationDim xlbook As Excel.WorkbookDim xlsheet As Excel.WorksheetDim SummaryResult As StringSet xlapp = CreateObject
2020-06-10 21:49:28
549
原创 DiffValue
package excel;public class DiffValue {public DiffValue(){rowIndex = 0;columnIndex = 0;diffValue = 0.0;}public int rowIndex;public int columnIndex;public double diffValue;}
2020-06-10 20:59:23
216
原创 CsvUtil
package excel;import java.io.BufferedReader;import java.io.FileReader;import java.util.ArrayList;import java.util.List;public class CsvUtil {/** * 描述:获取IO流中的数据,组装成List<Object[]>对象 * @param path 物理文件地址 * @return * @throws Exception */publ
2020-06-10 20:58:37
1189
原创 CalculateUtil
package excel;import java.util.ArrayList;import java.util.List;public class CalculateUtil {public static List<DiffValue> CompareCellsValue(List<Object[]> dataList, List<Object[]> dataListNew, double allowDiffValue, int rowIndex, int c
2020-06-10 20:57:52
363
原创 ExcelUtil
package excel;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFDateUtil;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.util.HSSFColor;import org.apache.poi.ss.usermodel.*;import
2020-06-10 20:57:12
301
原创 ExcelCompare
package excel;import org.example.MainApp;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;public class ExcelCompare {public static void main(String[] args) throws Exception {/HSSFWorkbook wb = new HSSFW
2020-06-10 20:56:35
463
原创 Compare Excel
from Config import configsimport pymssqlimport xlrdimport osimport shutilimport pandasimport xlwingsimport openpyxl#import elementtree.ElementTree as ETconfig = configs.get_config()def query_from_db(sql):server = config.ASAP_db[“server”]db_name
2020-05-11 22:53:20
253
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人