Read Excel files from Python[轉]

<a href="http://scienceoss.com/read-excel-files-from-python/">http://scienceoss.com/read-excel-files-from-python/</a>

open the workbook

check the sheet names

get the first sheet either by index or by name

iterate through rows, returning each as a list that you can index:

if you just want the first column:

index individual cells:

(note python indices start at zero but excel starts at one)

turns out the put_cell() method isn’t supported, so ignore the following section (thanks for the heads up, john!)

put something in the cell:

possible ctypes: 0 = empty, 1 = string, 2 = number, 3 = date, 4 = boolean, 5 = error

歡迎加群互相學習，共同進步。qq群：ios: 58099570 | android: 330987132 | go：217696290 | python：336880185 | 做人要厚道，轉載請注明出處！