- 博客(80)
- 资源 (10)
- 收藏
- 关注
原创 Python相关环境变量配置和模拟手机app登录
C:\Program Files\Java\jdk1.8.0_201(这里是你的安装路径,最好复制粘贴)接下来我们开始测试。在F盘新建一个java文件。我的是debug.java。接着,打开系统->高级系统设置->环境变量。新建一个JAVA_HOME。然后打开cmd,输入javac,若出现以下信息,则证明你成功了一半。输入java,若出现以下信息,则证明java环境变量配置成功了。然后成功输出10.java环境检验成功。【java环境变量配置】然后在Path下添加。
2023-05-30 20:27:33 1793
原创 Excel中VBA实现文件夹表格合并和数据提取
多个文件夹下excel文件的提取复制。获取多个文件夹下文件和文件夹信息。excel数据批量汇总‘
2022-08-01 22:21:30 2444
原创 日常开单送货VBA模块
合并数据Sub 按钮1_Click()送货单开单.ShowEnd SubPublic Sub hebing()Dim k%Dim sh As WorksheetOn Error Resume NextApplication.ScreenUpdating = FalseFilename = Application.GetOpenFilename("Excel 文件 ,*.xls;*.xlsx")If Filename <> False ThenDebug.Print F
2022-04-27 20:04:56 865
原创 python获取职位信息
51job获取完整代码:import requestsfrom bs4 import BeautifulSoupimport datetimeimport jsonimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdfrom selenium.webdriver import Chrome, ChromeOptions, ActionChainsfrom selenium.w.
2022-02-28 23:31:59 1200 1
原创 基金收益排名
基金收益排名import xlwings as xwimport requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdimport csvimport refrom selenium.webdriv
2022-02-05 14:37:03 687 1
原创 火狐浏览器驱动下载
Chromedrive下载版本可参照Selenium Chrome版本与chromedriver兼容版本对照表下载地址各版本下载地址geckodriver下载地址淘宝npm镜像geckodriver Mirroriedriver下载地址http://selenium-release.storage.googleapis.com/index.htmlphantomjs驱动下载地址Download PhantomJSoperadriver下载地址淘宝npm镜像Op
2022-01-25 14:30:11 5013
原创 Excel中VBA合并工作表
合并送货单数据Dim k%Dim sh As WorksheetOn Error Resume NextApplication.ScreenUpdating = FalseName = "安智-送货单12.18"MP = "E:\杭实\运营数据\开单电子台账\" & Name & ".xlsx" '工作簿路径 Set Wb = Workbooks.Open(MP) '清空数据last_row_clear = ThisWorkbook.Sheets("送货单").Cel
2021-12-29 10:35:19 4513
原创 python中地图测距
百度地图测距:import requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xwfrom selenium import webdriverimport timefrom selenium.webdriver import Chrome, ChromeOptionsimport pandas as pdimport js
2021-12-04 22:57:12 648
原创 excel中VBA获取指定单元格内容
1、筛选指定列获取数据For Each Rng In Sheets("目录").Range("b1:B23") Debug.Print Rng.Value If Rng.Value = "个人" Then n = n + 1 Sheets("备注").Cells(n, "g").Resize(1, 5) = Rng.Offset(0, -1).Range("a1:e1").Value Sheets("备注").Cells(n, "g").
2021-11-24 22:12:57 10486
原创 python操作excel
import pandas as pdimport osimport xlwt#文件路径file_dir = r'C:\Users\HONORS\Desktop\进出库'#构建新的表格名称new_filename = file_dir + '\\new_file.xls'#找到文件路径下的所有表格名称,返回列表file_list = os.listdir(file_dir)new_list = []for file in file_list: #重构文件路径 fi.
2021-11-06 15:51:12 607
原创 python中异常处理-安装包失败
导入第三方库失败和解调器配置根据字面意思理解,一直以为是pip版本不对导致的,于是花费时间在更新pip版本上。根据导入模块时错误提示信息可以看出,我的pycharm路径为C:\Users\Administrator.USER-20190620KX\PycharmProjects\untitled20\Scripts。在该径路下打开命令窗口,输入python.exe -m pip install matplotlib -i http://pypi.douban.com/simple --trusted-
2021-11-06 15:39:07 2882
原创 access中sql语句
查询:SELECT 日期 ,单位,起运地,卸货地FROM 热联 Where 日期> #2021-5-1# ;SELECT 日期 ,单位,起运地,卸货地FROM 热联 Where 日期 between #2021-10-1# and #2021-10-31# SELECT 日期 ,单位,起运地,卸货地,总价,附加费,实际成本金额FROM 热联 Where 日期 between #2021-10-1# and #2021-10-31# and 卸货地='武汉库'or 起运地='武汉库'
2021-11-06 11:40:47 747
原创 python中pyecharts的使用
import pyechartsfrom pyecharts.charts import Barfrom pyecharts.charts import Piefrom pyecharts.charts import Linefrom pyecharts import options as optsbar=Bar()bar.add_xaxis(["衬衫","毛衣","裙子","T学",])bar.add_yaxis("A销售",[120,110,30,40,])bar.add_yaxis(.
2021-10-08 19:13:52 810
原创 python中获取职位信息
51job爬取完整代码:import requestsfrom bs4 import BeautifulSoupimport datetimeimport jsonimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdfrom selenium.webdriver import Chrome, ChromeOptions, ActionChainsfrom selenium.we
2021-09-30 21:46:18 920
原创 python中完整爬取股票财务信息和公司基本信息含xpath
完整代码:import xlwings as xwimport requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdimport csvimport refrom selenium.webdrive
2021-09-19 13:45:54 3653 2
原创 python中完整爬取股票财务信息和公司基本信息
完整代码:import xlwings as xwimport requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdimport csvimport refrom selenium.webdrive
2021-09-19 13:45:14 1799 3
原创 python中爬取网页图片
完整代码:import requestsimport re# 自定义下载页面函数def load_page(url): response = requests.get(url) data = response.content return data# 自定义保存页面图片函数def get_image(html): regx = r'http://[\S]*jpg' # 定义图片正则表达式 pattern = re.compile(regx)
2021-09-16 20:14:31 3540
原创 python通过selenium绕过反扒系统跨网页批量获取股票财务信息
完整代码:import xlwings as xwimport requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xwfrom selenium import webdriverimport timeimport pandas as pdimport csvimport refrom selenium.webdrive
2021-09-11 22:19:56 418
原创 python通过selenium获取网页信息可以绕过反扒系统
加载selenium控件:pip intall selenium;pip showseleniumweb下载地址:chrome浏览器,chrome插件,谷歌浏览器下载,谈笑有鸿儒 (chromedownloads.net)https://www.chromedownloads.net/
2021-09-10 17:53:34 396
原创 Excel中VBA相关类的操作
.综合应用方法Public 条件Private rngsPrivate nDim ccProperty Set 单元格(rng As Range)If rng > 条件 Then n = n + 1 If n = 1 Then Set rngs = rng Set rngs = Union(rngs, rng)End If cc = rngs.AddressEnd PropertyFunction 求和()求和 = WorksheetFunct
2021-09-08 08:33:30 153
原创 Excel中VBA相关函数的使用
自定义函数实例-单元颜色求和(字典+自定义函数)Function COLORSUM(单元格区域 As range, 汇总的颜色 As range)Set d = CreateObject("Scripting.Dictionary")For Each Rng In 汇总的颜色 d(Rng.Interior.ColorIndex) = ""NextFor Each ci In d.keys For Each Rng In 单元格区域 If Rng.Interior
2021-09-08 08:29:29 499
原创 Excel总VBA相关类模块
VBA操作Excel类模块的综合运用:Public 条件Private rngsPrivate nDim ccProperty Set 单元格(rng As Range)If rng > 条件 Then n = n + 1 If n = 1 Then Set rngs = rng Set rngs = Union(rngs, rng)End If cc = rngs.AddressEnd PropertyFunction 求和()求和 = Wo
2021-09-08 08:23:15 395
原创 Excel中VBA操作相关数组和字典
VBA操作Excel中数组分类汇总:Sub VBA数组分类汇总()Dim arr1()arr = [a2:c13]For i = 1 To UBound(arr) ReDim Preserve arr1(1 To 2, 1 To n + 1) For j = 1 To UBound(arr1, 2) If arr1(1, j) = arr(i, 1) Then arr1(2, j) = arr1(2, j) + arr(i, 3)
2021-09-08 08:12:54 2156
原创 Excel中VBA操作工作表相关
VBA操作Excel中盘点:Sub 未盘点编码()Dim rng As Range, rngs As Range, k%For Each rng In [a1:a796] For Each rngs In [g1:g175] If rngs = rng Then GoTo 100 End If Next rngs k = k + 1 Cells(k, "h") = rng100:Next rngEnd S
2021-09-08 08:07:49 567
原创 Excel中VBA相关工作簿操作
VBA拆分工作簿Sub 拆分到工作簿()Dim wk As Workbook, ss$, k%Application.DisplayAlerts = FalseFor Each sht In Workbooks("2-11.工作簿综合运用(拆分工作簿)").Sheets Set wk = Workbooks.Add k = k + 1 Workbooks(1).Sheets(k).Copy Workbooks(2).Sheets(1) ss = ThisWorkb
2021-09-08 07:58:32 544
原创 python中网页数据输出到csv操作方法
完整代码:import jsonimport requestsfrom bs4 import BeautifulSoupimport csvimport pandas as pdwith open('web.html','r',encoding='gbk') as f: html=BeautifulSoup(f,'html.parser') html.list=html.find_all('div',attrs={'class':'e'}) # print(html)
2021-09-07 15:03:35 385
原创 python中针对反爬虫网站爬取网页操作(51job)
C#利用webbrowser获取网页代码,并写入text: public static void WriteTxt(string filePath, string massage) { FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate);//创建写入文件 fs.Close();//关闭文件 if (File.Exists(file
2021-09-07 08:42:05 2687
原创 Python中cookie登录基金账户获取账户金额以追加写入方式导出到excel【心血付出】
好买网完整代码:from unicodedata import decimalimport requestsfrom bs4 import BeautifulSoupfrom datetime import datetimeimport jsonimport xlwtimport xlwings as xw# 新闻链接from numpy.core import doubleurl = ' https://i.howbuy.com/member/property/'sess
2021-09-05 16:36:04 2616
原创 python中模拟登录网址含验证码
完整代码:# -*- coding: UTF-8 -*-import jsonimport requestsimport sysfrom bs4 import BeautifulSoups = requests.Session()class JD: def __init__(self, username, password): self.username = username self.password = password s
2021-09-05 09:32:19 691
原创 关于cookielib和urllib2无法安装问题
cookielib操作from http import cookiejarcookielib=cookiejar.CookieJar()
2021-09-05 09:09:48 259
原创 python中登录基金账户获取基金数据
完整代码:from lxml.html import fromstringfrom bs4 import BeautifulSoupimport xlwtimport jsonwith open('rr.html' ,'r' ,encoding='utf-8') as f: # Soup = BeautifulSoup(f, 'lxml') html = BeautifulSoup(f, 'html.parser') html.list=html.find_all(
2021-09-04 22:20:02 934
原创 python中模拟点击
完整代码:import timefrom selenium import webdriver# sys.setProperty("webdriver.chrome.driver", "C:\\Program Files (x86)\\Google\\Chrome\\Application\\chromedriver.exe");wd = webdriver.Chrome('C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome
2021-09-04 18:39:42 123
原创 python模拟登录保存并读取cookie
完整代码:在这里要感谢一下博客楼主的辛勤付出,给的账户和密码都是真实的,楼主很伟大;博客来源:https://blog.csdn.net/weixin_46192930/article/details/105135087完整代码:from urllib import requestfrom urllib import parsefrom http.cookiejar import CookieJarfrom urllib import requestfrom http.cook
2021-09-04 17:41:04 1274
C#中读取excel文件中数据并导入dataGridView添加读取ProgressBar进度及当前读取条目挨个
2021-08-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人