Exemple #1
0
def load_keyword_from_datebase():
    reload(sys)
    sys.setdefaultencoding('utf-8')
    allkeyword = []
    file = 'config\cfg_allsearch\database.xls'
    data = read_excel.open_excel(file)
    table = data.sheet_by_name('all')
    for row_date in range(1, read_excel.rownum(file,'all')):
        keyword = table.cell(row_date, read_excel.find_colum(file,'all','keyword')).value
        allkeyword.append(keyword)
    return allkeyword
Exemple #2
0
def load_keyword_from_AppTestCase():
    file = '..\AppTestCase.xls'
    allkeyword = []
    for sheetname in read_excel.sheets_name(file):
        if "CAS" in sheetname:
            data = read_excel.open_excel(file)
            table = data.sheet_by_name(sheetname)
            reload(sys)
            sys.setdefaultencoding('utf-8')
            for row_date in range(5, read_excel.rownum(file,sheetname)):
                keyword = table.cell(row_date, read_excel.find_colum(file,sheetname,'data')).value
                if keyword == '':
                    pass
                elif "\n" in keyword:
                    for n in str(keyword).split("\n"):
                        if n == "":
                            pass
                        elif "," in keyword:
                            for m in str(keyword).split(","):
                                if m != '':
                                    allkeyword.append(m)
                                else:
                                    pass
                elif "," in keyword:
                    for o in str(keyword).split(","):
                        if o != "":
                            allkeyword.append(o)
                        else:
                            pass

                else:
                    allkeyword.append(keyword)

                reload(sys)
                sys.setdefaultencoding('utf-8')

    return allkeyword
Exemple #3
0
# -*- coding: UTF-8 -*-

__author__ = 'guyh'
from common.trd import read_excel

file = 'datebasea.xls'
data = read_excel.open_excel(file)
table = data.sheet_by_name('2')
table1 = data.sheet_by_name('1')
aa = []
bb = []
cc = []
dd = []


for row_date in range(0, read_excel.rownum(file,'2')):
    keyword = table.cell(row_date, 0).value
    if "," in str(keyword):
        abc = str(keyword).split(",")
        for n in str(keyword).split(","):
            aa.append(n)
    else :
        aa.append(keyword)

for row_date in range(0, read_excel.rownum(file,'1')):
    keyword = table1.cell(row_date, 0).value
    bb.append(keyword)
    if keyword in aa:
        dd.append(keyword)
    else :
        print keyword