Eduardo Vieira wrote:
Hello, this is my first post in this list and I'm not a programmer, but am enjoying learning python. I'm trying to make a script to add worksheets to excel files: I managed to implement this code:import os folder = 'C:\\Personal\\oldxlsformat\\' from win32com.client import Dispatch xl = Dispatch('Excel.Application') xl.Application.AskToUpdateLinks = "False" for ficheiro in os.listdir(folder):
os.listdir returns a list of files relative to the directory in question. (Try it at the interpreter and see). Excel requires, pretty much, a list of absolute filenames. So try using something like os.path.join (folder, ficheiro) when opening in Excel. TJG _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
