#!/usr/bin/python
# -*- coding: UTF-8 -*-
import openpyxl as excel

## 读取excel,获取站点关联线段
excelFile=r"D:\zlc\test.xlsx"
wb=excel.load_workbook(excelFile)
## 读取第一行，获取列头
sheet=wb["Sheet1"]
rows=sheet.max_row
columns=sheet.max_column
array=[]

test="kkj就立即立即"
for kl in test.split("立"):
    print kl

for i in range(1,rows-1):
    temp=sheet.cell(row=i,column=1).value
    ## 分割
    # temp=temp.encode("utf-8")
    # print temp
    # sp="″".encode("utf-8")
    coordinates=temp.encode('utf-8').split("″")
    # for c in coordinates:
    #     print c
    print coordinates
    print len(coordinates)
    # for j in range(len(coordinates)-2):
    #     print j
    #     te=coordinates[j]
    #     print coordinates.get
        # if temp not None:
        #     print temp   
    # print coordinates
    # array.append(temp)

if x is None:

if not x:

if not x is None:

## 遍历key
for key in d:
    print key

for key in d.iterkeys():
    # d.iterkeys(): an iterator over the keys of d
    print key

for key in d.keys():
    # d.keys() -> ['y', 'x', 'z']
    print key

## 遍历values
for value in d.itervalues():
    # d.itervalues: an iterator over the values of d
    print value

for value in d.values():
    # d.values() -> [2, 1, 3]
    print value

## 遍历keys和values
for key, value in d.iteritems():
    # d.iteritems: an iterator over the (key, value) items
    print key,'corresponds to',d[key]

for key, value in d.items():
    # d.items(): list of d's (key, value) pairs, as 2-tuples
    # [('y', 2), ('x', 1), ('z', 3)]
    print key,'corresponds to',value

## 10进制string转化为int 
int('12')

## 16进制string转化为int
int('12', 16)

## int转化为10进制string
str(18)

## int转化为16进制string
hex(18)

## 进行验证
def validate():
    print("天王")
    while True:
        if input('输入回车键退出程序') == '':
            sys.exit()
        else:
            break