# -*- coding: utf-8 -*-
import urllib,os
import xdrlib ,sys
import xlrd
reload(sys)
sys.setdefaultencoding('utf-8')
file_dir=r'E:\test\data\data\11'
def open_excel(filename):
try:
data=xlrd.open_workbook(filename)
return data
except Exception,e:
print str(e)
def get_flile_list(file_dir):
return os.listdir(file_dir)
def excel2txt(suffix,file_dir,byindex,split_str):
filelist=get_flile_list(file_dir)
for file in filelist:
basefile=os.path.splitext(file)
target_file=basefile[0]+'.txt'
if os.path.exists(file_dir+r'\\'+target_file):
os.remove(file_dir+r'\\'+target_file)
if basefile[1]==suffix:
excel_data=ope
import urllib,os
import xdrlib ,sys
import xlrd
reload(sys)
sys.setdefaultencoding('utf-8')
file_dir=r'E:\test\data\data\11'
def open_excel(filename):
try:
data=xlrd.open_workbook(filename)
return data
except Exception,e:
print str(e)
def get_flile_list(file_dir):
return os.listdir(file_dir)
def excel2txt(suffix,file_dir,byindex,split_str):
filelist=get_flile_list(file_dir)
for file in filelist:
basefile=os.path.splitext(file)
target_file=basefile[0]+'.txt'
if os.path.exists(file_dir+r'\\'+target_file):
os.remove(file_dir+r'\\'+target_file)
if basefile[1]==suffix:
excel_data=ope