23.行中的值属于某个集合

1.基础python 

vi 5excel_value_in_set.py 
#!/usr/bin/env python3 
import sys
from datetime import date
from xlrd import open_workbook,xldate_as_tuple
from xlwt import Workbook
input_file=sys.argv[1]
output_file=sys.argv[2]
output_workbook=Workbook()
output_worksheet=output_workbook.add_sheet('jan_2013_output')
important_dates=['1/24/2014','1/31/2014']
purchase_date_column_index=4
with open_workbook(input_file) as workbook:
        worksheet=workbook.sheet_by_name('january_2013')
        data=[]
        header=worksheet.row_values(0)
        data.append(header)
        for row_index in range(1,3):
                for column_index in range(0,worksheet.ncols):
                        cell_value=worksheet.cell_value(row_index,column_index)
                        cell_type=worksheet.cell_type(row_index,column_index)
                        row_list=[]
                        if cell_type!=3:
                                row_list.append(cell_value)
                                #print(row_list)
                                data.append(row_list)
                        else:
                                if cell_value in important_dates:
                                        row_list.append(cell_value)
                                row_list.append(cell_value)
                                #print(row_list)        
                                data.append(row_list)
        print(data)
        for list_index,output_list in enumerate(data):
                for element_index,element in enumerate(output_list):
                        output_worksheet.write(list_index,element_index,element)
output_workbook.save(output_file)





[root@oracle1 python]# python3 5excel_value_in_set.py sales_2013.xls 15output.xls 
[['Customer ID', 'Customer Name', 'Invoice Number', 'Sale Amount', 'Purchase Date'], [1234.0], ['John Smith'], ['100-0002'], [1200.0], ['1/1/2014'], [2345.0], ['Mary Harrison'], ['100-0003'], [1425.0], ['1/6/2014']]

def xldate_as_tuple(xldate, datemode) 
xldate 是一个数字。

2.总结

这个编写的有点问题。