FilesExpand file tree

main

/

make_dirs_from_xls.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

14 lines (10 loc) · 387 Bytes

main

/

make_dirs_from_xls.py

Copy path

Top

File metadata and controls

• Code
• Blame

14 lines (10 loc) · 387 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

import os

import pyexcel

# creating folders from list in XLS file using pyexcel

# assuming that folders are in "Folder" column

root_path = os.path.dirname(os.path.realpath(__file__))

datafile = ".\\filename.xls"

records = pyexcel.iget_records(file_name=datafile)

folders = [record['Folder'] for record in records]

for folder in folders:

os.mkdir(os.path.join(root_path, folder))