代码：# /usr/bin/env python# -*- coding:utf-8 -*-# @Time: 2019/2/15 08:45# @Author: lemonimport requestsfrom lxml.html import fromstringimport jsonclass SpiderDouban():def __init__(self,url):self.url = u

建立连接：private OleDbConnection Getconnection()//建立连接{string Constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Administrator\Documents\测试.accdb";OleDbConnection myCon = new OleDbConnectio

Chromedrive下载版本可参照Selenium Chrome版本与chromedriver兼容版本对照表下载地址各版本下载地址geckodriver下载地址淘宝npm镜像geckodriver Mirroriedriver下载地址http://selenium-release.storage.googleapis.com/index.htmlphantomjs驱动下载地址Download P

1、筛选指定列获取数据For Each Rng In Sheets("目录").Range("b1:B23")Debug.Print Rng.ValueIf Rng.Value = "个人" Thenn = n + 1Sheets("备注").Cells(n, "g").Resize(1, 5) = Rng.Offset(0, -1).Range("a1:e1").ValueSheets("备注"