Thread: Xlwt

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Xlwt


    Hello everyone!
    I have a piece of code witch takes a list of subfolders(C:/desktop/movie/1/filmenamelalal,2/filmenametralala,3,4,5,6,7,8,9 and so on) and creates a list of xls files(C:/desktop/text/1.xls, 2.xls, 3xls, and so on).
    In that files (xls) i want to write the names of the files from that subfolder in each row for xnumber of files in the subfolder:
    xls:row0filmenamelalal
    xls:row0filmenametralala
    and so on...
    The code that i have so far is:
    import os
    import xlwt
    import os.path

    #link = raw_input("Linkul: ")



    for dirname, dirnames, filenames in os.walk(r"C:/Users/s/Desktop/filme/"):
    for subdirname in dirnames:
    foldere_filme = os.path.join(dirname, subdirname)
    numarul_folderelor = foldere_filme.replace("C:/Users/s/Desktop/filme/", "")
    print numarul_folderelor
    for filenames in os.listdir(foldere_filme):
    numele_pt_text = filenames.replace(".avi", "")
    print numele_pt_text
    wbk = xlwt.Workbook()
    sheet = wbk.add_sheet('sheet 1', cell_overwrite_ok=True)
    sheet.write(0,0,numele_pt_text)
    sheet.write(1,0,numele_pt_text)
    sheet.write(2,0,numele_pt_text)
    sheet.write(3,0,numele_pt_text)
    wbk.save("C:/Users/s/Desktop/text/"+numarul_folderelor+".xls")
    It prints ok, but when it saves it saves into the xls it saves only the last name of the file from the subfolder.
    Thank you in advanced.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0
    No one? Here's a simpler aproach:
    import os
    import xlwt
    import os.path
    from win32com.client import Dispatch
    #link = raw_input("Linkul: ")
    for dirname, dirnames, filenames in os.walk(r"C:/Users/s/Desktop/filme/"):
    ----for subdirname in dirnames:
    ------foldere_filme = os.path.join(dirname, subdirname)
    ------numarul_folderelor = foldere_filme.replace("C:/Users/s/Desktop/filme/", "")
    ------print numarul_folderelor #1,2,3,4,5...
    ------for filenames in os.listdir(foldere_filme):
    --------numele_pt_text = filenames.replace(".avi", "")
    --------print numele_pt_text
    --------root_text = "C:/Users/s/Desktop/text/"+numarul_folderelor+".txt"
    --------fisier_text = open(""+root_text+"", "w")
    --------fisier_text.writelines(
    --------------------"Full Movie: \n\n\nwatch "
    --------------------+numele_pt_text+" online free, watch "
    --------------------+numele_pt_text+" online")
    --------fisier_text.close()

    It only saves in the text files: root_text = "C:/Users/s/Desktop/text/"+numarul_folderelor+".txt" the last filename from the list in within the subfolders, i want to save all of them.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    5
    Rep Power
    0

    ok


    oops
  6. #4
  7. Contributing User
    Devshed Demi-God (4500 - 4999 posts)

    Join Date
    Aug 2011
    Posts
    4,997
    Rep Power
    481
    I'm here, but lost interest as soon as I saw both an
    xlwt module of which I'm unaware, and
    xls which I try to avoid.
    [code]Code tags[/code] are essential for python code and Makefiles!

IMN logo majestic logo threadwatch logo seochat tools logo