October 2nd, 2012, 03:43 AM
-
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.
October 3rd, 2012, 12:22 AM
-
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.
October 15th, 2012, 02:18 AM
-
October 15th, 2012, 09:32 AM
-
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!