python script for getting some columns of one excel into new one
Question: ![enter image description here](http://i.stack.imgur.com/0URm9.png) I am new
to Python. I have to create another Excel file from my test report Excel file.

I need to create a new excel file as 'test result summery' with columns-values
like `test case ID` and 'Function loop1', 'function loop2' which is result of
resp test case etc from my test_report.xls (as in below image) Can anybody
share some Python script for this?


Answer: You can use csv lib for this.  
More information here: <http://docs.python.org/2/library/csv.html>  
You would start with something like:

    
    
    import csv
    outputfile = open('Your Desired File Name', 'wb')
    DataWriter = csv.writer(outputfile, delimiter=',', quotechar='|', quoting = csv.QUOTE_MINIMAL)
    DataWriter.writerow(['Test Case ID', 'Result'])
    DataWriter.writerow(#Some data that you want to add)
    outputfile.close() # Close the file
    

