The CSV read in the "Python" file reads the data in the CSV read and the execution is successful.

Source: Internet
Author: User

1# coding=utf-82  fromSelenium Import Webdriver3  fromTime Import Sleep4 Import Keyword5  fromSelenium.webdriver.common.keys Import Keys6  fromselenium.webdriver.support.wait Import webdriverwait7  fromselenium.webdriver.support.ui Import Select8 Import CSV9 Import RandomTen Import IO One  A #文件路径 -Inputfilepath ="Documents\logininputdata.csv" -Outputfilepath ="Documents\loginoutputdata.csv" the  - def readcsvfiletolist (filePath): -  -With Io.open (FilePath,"R", encoding='Utf-8') asCSVFile: +List =Csvfile.readlines () -     returnList +  A def savelisttofiletolist (filePath): at  -CSVFile = File (FilePath,'WB') -writer =Csv.writer (csvfile) - #表头 -Writer.writerow (['UserName','PWD',"']) - writer.writerows (outputstring) in csvfile.close () -  to #通过Id判断该元素是否存在 + def iselementexist (driver,id): -     Try: the driver.find_element_by_id (ID) *         returnTrue $ except:Panax Notoginseng         returnFalse -  the if__name__=="__main__": +  A #读取文件到list数组里面 theLists =readcsvfiletolist (Inputfilepath) +#lists的组成: ["grace,1","grace2,2"] - #声明一个输出数组 to save the result set $outputstring=[] $  - #循环数组 -      forListinchlists: the  - #获取每一行数据 and use a comma to unpack the user name and passwordWuyi#list ="grace,1" the#list. Split (",") =[grace1,1] #csv是用逗号分隔, the following list.split (",")[0] is the 1th element in the Grace1,list.split (",")[1the 2nd element in the] is 1 -Username=list.split (",")[0].strip () WuPwd= List.split (",")[1].strip () -  About print (userName) $ print (PWD) -  - #开始浏览登陆 -Driver =Webdriver. Firefox () ADriver.Get("http://demo.pingnanlearning.com/test/login/index.php") +  theDRIVER.FIND_ELEMENT_BY_ID ("username"). Send_keys (UserName) -Sleep1) $DRIVER.FIND_ELEMENT_BY_ID ("Password"). Send_keys (PWD) theSleep1) theDRIVER.FIND_ELEMENT_BY_ID ("loginbtn"). Click () the  theSleep2) -  inresult="unsuccessful" the #il判断是否登陆成功 the         ifIselementexist (Driver,"maincontent"): About #成功 theresult ="successful" the #将结果追加到保存结果集 the outputstring.append ([Username,pwd,result]) + driver.quit () -  the     #Bayi # End of Cycle the print (outputstring) the  - #将结果集写入文件 -Savelisttofiletolist (Outputfilepath)

The CSV read in the "Python" file reads the data in the CSV read and the execution is successful.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.