print recorded data for excel files on python

[CalculusG]

there are xls files saved in a folder and all of them have have values in the 1st, 2nd, and 3rd columns. in the folder there are about 100 excel files, the first five number of excel file names represent the patient id.there are about 5 to 10 excels for a single patient, which each excel corresponding to different days of treatment. i was trying to print the values of the first column for a patient to a single excel, which each column represents different days of treatment values of the 1st column.

i know how to read the values...i just need help on how i can print the values of the 1st column for different days of treatment in different columns.

[Gribouillis]

There was a thread with exactly the same question recently, see here http://www.daniweb.com/software-development/python/threads/378039/page2. Is this homework ? Read this too http://www.daniweb.com/forums/announcement.php?f=8&announcementid=2

[CalculusG]

Thank you for your quick response. i looked at the link,

def create_workbook(dstdir, ID, triples, sheet_name = u"TrackingData"):
    name = pjoin(dstdir, ID + ".xls")
    wb = xlwt.Workbook()
    try:
        sh = wb.add_sheet(sheet_name)
        for col, val in enumerate("Xvalue Yvalue Zvalue".split()):
            sh.write(0, col, val)
        for row, triple in enumerate(triples, 1):
            for col, val in enumerate(triple):
                sh.write(row, col, val)
    finally:
        wb.save(name)

this prints all the x values in to one column. i was trying to print only the x values for different days of treatment in different columns, and the same for y value and z value.

[TrustyTony]

And how you tried to do that? Show your effort.