- 博客(18)
- 资源 (7)
- 收藏
- 关注
RSS订阅原创 Data_Process.java
Data_Process.javapackage com;import java.util.List;import java.util.Map;public class DataProcessing {public static void main(String[] args) {String TeamTrackSource = System.getProperty(“C:\wz\Crester\9-20\marked//FEM.xlsx”);String JiraSource = Syste
2022-03-31 15:42:19
188
原创 Data Filter JAVA
package com;import java.util.ArrayList;import java.util.Arrays;import java.util.List;public class DataFilter {public static void main(String[] args) {//声明数组，通过数组注明需要获取的colnum//0 Item Id、1 Title 、3 Assigned To、4 Country 、10 Item Type 、11 Last Modifie
2022-03-31 15:40:10
578
原创 Java Excel 文件处理
package com;import java.io.*;import java.util.Date;import java.util.List;import com.AlertReprtEntity;import com.AlterReportService;import java.util.List;import java.text.SimpleDateFormat;import com.sun.corba.se.spi.orbutil.threadpool.Work;import j
2022-03-31 15:32:25
526
原创 excel追加内容
package demo;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import java.io.FileInputStream;import java.io.Fil
2022-03-31 15:24:13
256
原创 exceltodb
package com;import com.DBhelper;import com.PartyEntity;import com.PartyService;import com.Logger;import java.util.List;public class TestExcelToDb2 {public static void main(String[] args){// List listExcel=PartyService.getAllByExcel(“C:\wz//T
2022-03-31 15:23:03
971
原创 Git Command
一、基本操作1、git初始化git config --global http.https://bitbucket.org.proxy http://10.63.8.70:10938—对仓库进行配置。git init:—git init 命令用于在目录中创建新的 Git 仓库, .git 这个子目录，所有有关你的此项目的快照数据都存放在这里。git remote add origin —添加仓库，可以理解为本地目录与仓库进行绑定。— git remote add origin https:/
2022-03-28 17:32:18
82
原创 DataTrans
import osimport sysfrom pathlib import Pathimport openpyxl # openpyxl引入模块sys.path.append(Path(file).parent.resolve())sys.path.append(Path(file).parent.parent.resolve())sys.path.append(Path(file).parent.parent.parent.resolve())def write_to_excel(pat
2022-03-23 18:30:09
210
原创 run_mainFrame19.py
# ======================# imports# ======================import tkinter as tkfrom tkinter import ttkfrom tkinter import scrolledtextfrom tkinter import Menufrom tkinter import Spinboxfrom tkinter import messagebox as mBox# import timeimport calen
2022-03-23 18:15:14
54
原创 testpythonfile
GenerateTxt.pyimport osmkpathconfig = r"C:\Users\Public\pythonAutomationConfig"if os.path.exists(mkpathconfig) != True:os.makedirs(mkpathconfig)downloadConfig = ‘downloadConfig.txt’mailConfig = ‘mailConfig.txt’uploadConfig = ‘uploadConfig.txt’downl
2022-03-22 16:05:51
804
原创 Colorset
colorset.pyimport openpyxlfrom openpyxl.styles import PatternFill, colorsfrom demo.src.demo.Data_Process import readCashFlowlAdjuestmentFilexlsxffnpath = r’C:\wz\pythonFile\crashflow_sg_template_Weekly.xlsx’ffnpath = r’C:\Users\Public\pythonFile1\cras
2022-03-22 16:00:56
599
原创 GetDirfilename_checkbutton_Gui
import tkinter as tkfrom tkinter import messagebox as mBoximport osdef GetItems():# ‘get the new items from folder’name = []for root, dirs, files in os.walk(r’C:\Users\Public\SourceFile’):for i in files:if ‘.xlsx’ + ’ ’ in i + ’ ': # 这里后面不加一个字母可能会
2022-03-22 15:24:53
37
原创 CFA_Data Process
Data_Process.pyimport openpyxlimport sysimport tracebackfrom pathlib import Pathimport xlrdimport csvimport codecsfrom datetime import datetimefrom openpyxl.reader.excel import load_workbookfrom xlrd import xldate_as_tuplesys.path.append(Path(fi
2022-03-22 15:03:04
185
原创 CFA_Project --- selenium tool
testm_bak.pyimport sysimport timeimport osimport tracebackimport loggingfrom pathlib import Pathos.path.joinfrom zipfile import ZipFilesys.path.append(str(Path(file).parent.resolve()))import shutilsys.path.append(str(Path(file).parent.parent.res
2022-03-22 14:37:48
461
原创 CFA_Project ---- GUI
GUIrun_mainFrame9.pyimport tkinter as tkfrom tkinter import ttkfrom tkinter import scrolledtextfrom tkinter import Menufrom tkinter import Spinboxfrom tkinter import messagebox as mBoximport timeimport calendarimport threadingimport timeimport
2022-03-22 14:30:51
428
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人