Many people are asking: how to Baidu map inside the search to the company business phone export form? How will Baidu map inside the search for the company's telephone address and other data exported to Excel?
Now, a lot of people on the Internet to find businesses, business. Baidu Map has a lot of business contact information address and other data, which has become a lot of people's convenient way. But a copy of the business phone, address is a very painful thing, so think of developing a program, simulating the operation of people, all the data extracted to save to excel.
Exchange Learning qq:3125547039
Main code ideas:
M_objconnection.open (); Button1. Enabled = false;
txtinfo.text = ""; txtinfo.backcolor = Color.White; //////////////////////////////////////////// m_icount = 0; int itemCount = Comboqitems.count; for (int i = 0; i < ItemCount; i++) & nbsp; { string str1 = Comboq.items[i]. ToString (); application.doevents (); ///////////////////////////////////////////////////////////////////////////////////// //Extract information for the first time String strresult = clsdownload.gethtml (strhttp); //string strresult = TextBox3.Text;
poiinfolist = Getfirstallinfo (strresult); if (poiinfolist = = NULL ) { MessageBox.Show (Strquxian + "does not get any numeric--null, may appear abnormal"); } Else { foreach (Poiparameter poiinfo in poiinfolist) { Addtotable (poiinfo, 0); } } lblstatus.text = "No. 0";
//2nd to last for (int ipage = 1; ipage < m_ Ipagecount; ipage++) { strresult = clsdownload.gethtml (strhttp);
POIinfoList2 = Getallinfo (Strresult, ipage); if (POIinfoList2 = = null) { Thread.Sleep (200); ipage = iPage-1; continue; } Else { foreach (Poiparameter poiinfo in POIinfoList2) { addtotable (Poiinfo, ipage); application.doevents (); } } Lblstatus.text = "No." + Ipage.tostring (); Application.doevents ();
} /////////////////////////////////////////////////////////////////////////////////////////////// } Txtinfo.text = Txtinfo.text + "Total number of bars:" + m_icount.tostring (); Txtinfo.backcolor = Color.green;
M_objconnection.close (); Thread.Sleep (1000);
//Save to Excel if (checksavetoexcel.checked) { String strexcelfile = ""; if (m_ Stroldaccess.length < 7) { strexcelfile = Application.startuppath + "\\Data\\Over\\Excel\\" + comboshenfen.text + "\ \" + Txtcity.text + Txtaim.text + m_icount.tostring () + ". xls"; } Else {//wyf:insert to old Access. int iPos1 = M_stroldaccess.lastindexof ('_'); Baidupoi_ City Attractions 94.mdb int iPos2 = M_stroldaccess.lastindexof ('. '); . mdb string strcityaimoldcount = m_stroldaccess.substring (iPos1 + 1, ipos2-ipos1-1);
Strexcelfile = Application.startuppath + "\\Data\\Over\\Excel\\" + comboshenfen.text + "\ \" + Strcityaimoldcount + "_" + M _icount.tostring () + ". xls"; Xinyang Lighting 187.xls}
Easyexcel.access2excel (Straccessfile, strexcelfile); }
Baidu map inside the search to the company business phone export form? How will Baidu map inside the search for the company's telephone address and other data exported to Excel?