python读取excel文件

# -*- coding: utf-8 -*-
import xlrd
import xlwt
import re
import coordTransfor


def readexcel():
    workbook = xlrd.open_workbook('/Users/cc/PycharmProjects/uddsg/all wgs84.xlsx')
    booksheet = workbook.sheet_by_index(0)
    p = list()
    for row in range(booksheet.nrows):
        row_data = []
        for col in range(booksheet.ncols):
            # print(col)
            cel = booksheet.cell(row, col)
            # print(cel)
            val = cel.value
            try:
                val = cel.value
                val = re.sub(r'\s+', '', val)
            except:
                pass

            if type(val) == float:
                val = int(val)
            else:
                val = str(val)
            row_data.append(val)
        p.append(row_data)
    return p

转载于:https://my.oschina.net/u/3343582/blog/1525230