Print _python after data de-duplication in Python looking for a column in Excel

1. Excel in Python simple read and write operation, recommend the use of XLRD (especially read operation)

2. Go to http://pypi.python.org/pypi/xlrd to download XLRD library;

3. The engineering code is as follows:

Copy Code code as follows:

Import xlrd

def open_excel (filename= "Simple.xls"):
Try
Filehandler = Xlrd.open_workbook (fileName)
Return Filehandler
Except Exception, E:
Print str (e)

def scan_excel (sheet_name1=u ' Sheet1 '):
Handler = Open_excel ()
page = Handler.sheet_by_name (sheet_name1)
Return page

def trim_cols (index=0):
page = Scan_excel ()
col1 = page.col_values (index)
col2 = []

For item in col1:
If Item not in col2:
Col2.append (item)
Print col1
Print col2

def main ():
Trim_cols ()

if __name__ = = "__main__":
Main ()

Print results:
[1.0, 2.0, 3.0, 4.0, 1.0, 2.0, 3.0, 4.0]
[1.0, 2.0, 3.0, 4.0]