前面操作参考上一篇博客
腾讯地图API爬取街景
1用到工具将经纬度转换成可识别的场景id 坐标转成panoid,执行read.html,将执行好的panoid先复制在word,然后转换成txt,最后将这一列添加到excel
转换工具主要代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta http-equiv="X-UA-Compatible" content="ie=edge" />
<link rel="stylesheet" href="app.css" />
<title>转换</title>
</head>
<body>
<div class="container">
<h2>读取excel(仅读取第一个sheet)</h2>
<div class="mt-sm">
<input type="file" id="file" style="display:none;"
accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />
<a href="javascript:selectFile()">加载本地excel文件</a>
</div>
<div id="panel">
<span>pano:</span>
<span id="panoid"></span>
</div>
<p>结果输出:(下面表格可直接编辑导出)</p>
<button type="button" onclick="translateExcel()" style="margin-bottom:10px">
转化
</button>
<div id="result" contenteditable="">
<table>
<tbody>
<tr>
<th></th>
<th>A</th>
<th>B</th>
<th>C</th>
<th>D</th>
</tr>
<tr>
<td>1</td>
<td>name</td>
<td>经度</td>
<td>纬度</td>
<td>值</td>
</tr>
<tr>
<td>2</td>
<td>人民中路一段</td>
<td>104.0672425</td>
<td>30.65643045</td>
<td></td>
</tr>
</tbody>
</table>
</div>
<h2>导出excel</h2>
<div class="mt-sm" style="padding-bottom:40px;">
<input type="button" onclick="exportExcel()" value="保存" />
上面读取的表格您可以直接编辑,编辑后点击保存即可导出excel文件。
</div>
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/xlsx.core.min.js"></script>
<script charset="utf-8" src="https://map.qq.com/api/js?v=2.exp&key=OB4BZ-D4W3U-B7VVO-4PJWW-6TKDJ-W