美文网首页
python输出目录结构到excel

python输出目录结构到excel

作者: 一枚小工匠 | 来源:发表于2018-04-26 16:31 被阅读0次


# -*- coding: utf-8 -*-
import xlwt

import os

wbk = xlwt.Workbook(encoding='utf-8')
sheet = wbk.add_sheet('tt')

j=0
def traverse(f):
    fs = os.listdir(f)
    global j
    for f1 in fs:
      tmp_path = os.path.join(f, f1)
      if not os.path.isdir(tmp_path):
          print('文件: %s' % tmp_path)
          pathlist = tmp_path.split('/')
          i = 0;
          j = j + 1
          for folderName in pathlist:

              if folderName == '':
                  print('空目录')
              else:
                  i = i+1


                  print(j,i,folderName)
                  savaFile(j, i, folderName)
      else:
          # print('文件夹:%s' % tmp_path)
          traverse(tmp_path)

def savaFile(v,h,content):
    sheet.write(v,h,content)

path = '/Users/yaokai/tizen-sdk/ide/configuration/org.eclipse.osgi/bundles'
traverse(path)
wbk.save('test.xls')




相关文章

网友评论

      本文标题:python输出目录结构到excel

      本文链接:https://www.haomeiwen.com/subject/eelmlftx.html