python讀取excel並製表輸出

標籤：get   print   ret   slice   class   sheet   row   val   end   

源碼如下：

#!/usr/bin/python#coding=UTF-8import xlrdfrom prettytable import PrettyTabledef sheetRowToSlice(sheet, r, colnum):        res = []        for c in range(colnum):                cell_value = sheet.cell(r, c).value                if isinstance(cell_value, str):                        cell_value = ‘\n‘.join(cell_value.split(‘ ‘))                res.append(sheet.cell(r, c).value)        return resdef appendSliceToTable(table, res):        table.append(res)        returndata = xlrd.open_workbook("test.xlsx")sheet = data.sheets()[0]nrows_num = sheet.nrowsncols_num = sheet.ncolsfor r in range(nrows_num):        cell_value = str(sheet.cell(r, 0).value.encode("utf8"))        if "Name" in cell_value:                common_row_num = r        if "合計" in cell_value:                end_row_num = rcommon_row = sheetRowToSlice(sheet, common_row_num, ncols_num)table = PrettyTable(common_row)table.add_row(sheetRowToSlice(sheet, common_row_num + 1, ncols_num))print table.get_string()

　　

python讀取excel並製表輸出