擅长:python、mysql、java
<p><a href="https://i.stack.imgur.com/Z6deu.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z6deu.jpg" alt="enter image description here"/></a></p>
<p>您可以使用此代码访问excel并获取值
正如您在图像中看到的,您可以获得标题的第一行
所以你会有:区域;Sotto-area1等等
并获取第二行、第三行等等的值。
结果你会
Area=“Campalto”;Sotto-area1=“”等</p>
<pre><code># Reading an excel file using Python
import xlrd
# Give the location of the file
loc = ("path of file")
# To open Workbook
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0)
# For row 0 and column 0
sheet.cell_value(0, 0) //this will return the value of the first cell ... that has position 0,0
</code></pre>