擅长:python、mysql、java
<p>您可以使用<code>pandas</code>:</p>
<pre><code>import pandas as pd
df = pd.read_excel('file.xlsx', header=None)
result = [list(df[x].values) for x in df.columns.values]
</code></pre>
<p>输出:</p>
<pre><code>[['Column1', 'one', '22/03/1997'], ['Column2', 'two', 'six'], ['Column3', 'three', 7], ['Column4', 'four', 'eight']]
</code></pre>