擅长:python、mysql、java
<p>一个简单的方法是:</p>
<pre><code>def default_cell(xl_obj, cell, default_val):
try:
return str(round(xl_obj[cell].value,2))
except: #best if you can narrow down the exception...
return default_val
kit = {
"1A": default_cell('a8', "0.00"),
"2A": default_cell('a9', "0.00"),
....
}
</code></pre>
<p>在Python中是<a href="https://docs.python.org/3/glossary.html#term-eafp" rel="nofollow noreferrer">easier to ask for forgiveness than permission</a></p>