python script for getting some columns of one excel into new one

Question

enter image description here 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?

Just throw the image URL in the comments,so that I can understand what the problem is, and try to help you. Instead of just telling you to use this library or that. — Andy_A̷n̷d̷y̷, Dec 07 '13 at 08:02
i tried to attach an image but it failed ok , in short i have my excel file for test cases as follows TCID Description Expected Actual Loop 1 loop2 TC_0001 make switch on light shall on light gets on Pass pass TC_002 make switch off light shall off light is on FAIL FAIL from this source excel file i only have to create another excel with columns TC_ID and Result like Loop 1 , Loop 2 with its data , please share some code for windows xp — Sara, Dec 07 '13 at 08:06
how can add image for ur ref , it states needs some 10 reputation etc while attaching image — Sara, Dec 07 '13 at 08:16
You now have 10 reputation. You should be able to add your picture now — inspectorG4dget, Dec 07 '13 at 09:29
hi andy , i gote reputation hence added image , can you help me out with a script as per my description ? — Sara, Dec 07 '13 at 09:50

Andy_A̷n̷d̷y̷ · Answer 1 · 2013-12-07T08:04:33.497

1

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

edited Dec 07 '13 at 08:04

answered Dec 07 '13 at 07:46

Andy_A̷n̷d̷y̷

795
2
11
25

TC_ID TS_STEP ACTUAL RESULT_LOOP1 RESULT_LOOP2 TC001 BAT ON LIGHT ON PASS PASS TC002 BAT OFF LIGHT oFF PASS FAIL only want a seperate excel with TC_ID and LOOP1, LOOP2 etc – Sara Dec 07 '13 at 08:21
@Sara Sorry I don't understand what you really want. – Andy_A̷n̷d̷y̷ Dec 07 '13 at 08:27
yes , sorry , i thought it will appear like rows and column view easy to understand but its displaying in a line – Sara Dec 07 '13 at 09:10

score 0 · Answer 2 · edited May 23 '17 at 12:13

0

Use python libraries xlrd and xlwt.

import xlrd, xlwt

workbook1 = xlrd.open_workbook('my_workbook.xls')
worksheet1 = workbook1.sheet_by_name('Sheet1')
row = 0
col = 0
cell_value = worksheet1.cell_value(row, col)

workbook2 = xlwt.Workbook()
workssheet2 = workbook2.add_sheet('A Test Sheet')
workssheet2.write(row, col, cell_value)
workbook2.save('output.xls')

Another example: Using Python, write an Excel file with columns copied from another Excel file

edited May 23 '17 at 12:13

Community

1
1

answered Dec 07 '13 at 07:47

Prashant Borde

1,058
10
21

hi prashant do u have some examples – Sara Dec 07 '13 at 09:11
I have added some simple examples and you will find many more on Google. – Prashant Borde Dec 07 '13 at 11:26

python script for getting some columns of one excel into new one

2 Answers2