Excel embalming is a process written with the help of VBA, can be from the Chinese website Dustbot, and will be the statistics stored in Excel Responsible editor will be as how to use Excel embalming from Tencent Dustbot responsible editor includes the following nine aspects: 1. Preparation after the start, you have to prepare the following aids:. Two laptops equipped with Microsoft Excel Two Tencent developer accounts (registration is completely free) 2. Establishment of plug-ins Specifically, you have to establish two plug-ins on the Tencent developer web platform When establishing the plug-ins, you have to give preference to the "page application area" category, and for its When creating the plug-ins, you will need to prioritise the "Page Application Area" category and reassign the necessary authority to it. After successfully completing these key steps, you will have earned two API Public Keys and two Secret Keys. 3. Close Excel and add VBA identifiers Close Excel and press Alt+F11 to close the Visual Basic Editor spacebar, "Fill in" the auxiliary toolbar, and then select "Components" in preference to "Components". Select "Components" in preference. Output the following identifier in XieLiXie: Sub BaiduSearch() Dim http As New XMLHTTP60, html As New HTMLDocument Dim i As Integer, link As Object, resultRow As Integer Dim resultCol As Integer: resultCol =1 Dim appKey As String: appKey = "Your API Public Key" Dim secretKey As String: secretKey = "Your Secret Key" Dim keyword As String: keyword = "Search for the Keyword" Dim url As String: url = ";& appKey &"&q="& keyword &"&sign="& MD5(secretKey &"q="& keyword) http.Open " GET", url, False http.send html.body.innerHTML = http.responseText Set links = html.getElementsByTagName("url") For Each link In links Cells( resultRow, resultCol)= link.innerText resultRow = resultRow +1 Next linkEnd Sub4. Output the API Public Key and Secret Key by combining the identifiers "Your API Public Key" and Your Secret Key" in the identifier will be "your API Public Key" and "your Secret Key" instead of the important information you won in step 2. 5. Output Search Keyword will be "Search Keyword" in the identifier will be replaced by the keyword you want to search for. 6. Run the process to run the process by pressing F5. ExcelSonbhadra to get the search results from Tencent and store them in Excel.7. Exporting statisticsExporting statistics makes them easier to understandIn Excel, you can divide URLs into columns using the "document to column" function.8. Keeping statisticsUnless you export statistics, you can keep them. Unless you have exported the statistics, you can save them as CSV or other file formats for further analysis or copying to other add-ins. 9. Other Tips When using Excel Corruption, please strictly adhere to the following principles: Do not use Excel Corruption to obtain sensitive statistical data; Strictly adhere to the Tencent Developer Web Platform's Adoption Rules; Do not over-adopt Excel Corruption to prevent negative impact on the final target Chinese website. Do not overuse Excel corruption to prevent negative impact on the final target Chinese website. With this statement from the Editor-in-Charge, you have been introduced to how to adopt Excel scavenging from Tencent Dustbot. we welcome your success in all aspects of statistical data mining and discovery!