Excel转txt文件格式批量转换python脚本

  • A+
所属分类：python基础入门
收 藏

Excel转txt文件格式批量转换python脚本

  1. #?-*-?coding:?utf-8?-*-
  2. """
  3. Created?on?Wed?May??9?18:14:45?2018
  4. @author:?lenovo
  5. """
  7. #?-*-?coding:?utf-8?-*-?
  8. import?xlrd,os
  10. file_dir=r'E:\test'
  11. target_dir=r'E:\test\target'
  13. def?open_excel(filename):
  14. ????try:
  15. ????????data=xlrd.open_workbook(filename)
  16. ????????return?data
  17. ????except?Exception?as?e:
  18. ????????print?(e)
  19. def?get_flile_list(file_dir):
  20. ????return?os.listdir(file_dir)
  24. def?excel2txt(file_dir,byindex,split_str,suffix='.xls'):
  25. ???filelist=get_flile_list(file_dir)
  26. ???for?file?in?filelist:
  27. ????????basefile=os.path.splitext(file)
  28. ????????target_file=basefile[0]+'.txt'
  29. ????????if?os.path.exists(target_dir+r'\\'+target_file):
  30. ????????????os.remove(target_dir+r'\\'+target_file)
  31. ????????if?basefile[1]==suffix:
  32. ????????????excel_data=open_excel(file_dir+'\\'+file)
  33. ????????????table=excel_data.sheets()[byindex]
  34. ????????????nrows=table.nrows
  35. ????????????ncols=table.ncols
  36. ????????????txtfile=open(target_dir+'\\'+target_file,'a+',encoding?=?'utf-8')
  37. ????????????for?i?in?range(1,nrows):
  38. ????????????????for?j?in?range(ncols):
  39. ????????????????????if?j==0:
  40. ????????????????????????cell_value=str(table.cell(i,j).value)
  41. ????????????????????else:
  42. ????????????????????????cell_value=split_str+str(table.cell(i,j).value)
  43. ????????????????????txtfile.write(cell_value)
  44. ????????????????txtfile.write('\n')
  45. ????????????txtfile.close()
  47. if?__name__=='__main__':
  48. ????excel2txt(file_dir,0,'\t')
  • 我的微信
  • 这是我的微信扫一扫
  • weinxin
  • 我的微信公众号
  • 我的微信公众号扫一扫
  • weinxin

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: