Fetching data from excel.. junk value is appended.

[Mikedikearun]

Hi im fetching data from excel using python code.. i could see some junk value also with it. like [text:u

How to remove it.. below is the code

from xlrd import open_workbook
from win32com.client import Dispatch
book = open_workbook('C:/Users/742123/Desktop/test.xls')
sheet0 = book.sheet_by_index(0)
#sheet1 = book.sheet_by_index(1)
 
print sheet0.col(0) 
print sheet0.col(2)
print sheet0.col(3)
print sheet0.col(4)
print sheet0.col(5)
print sheet0.col(6)
print sheet0.col(7)
print sheet0.col(8)
print sheet0.col(9)
print sheet0.col(10)
print sheet0.col(12)
print sheet0.col(13)
print sheet0.col(14)
print sheet0.col(15)
print sheet0.col(16)
print sheet0.col(17)
print sheet0.col(18)
print sheet0.col(19)
print sheet0.col(20)
print sheet0.col(21)
print sheet0.col(22)
print sheet0.col(23)
print sheet0.col(24)
print sheet0.col(25)
print sheet0.col(26)
print sheet0.col(27)
 

[dwblas]

We have no idea what "junk" means or where in the file it is located so can not offer any advice. First you have to somehow quantify what you want and what you do not want. Also, you can print columns 2 through 27 with a for() loop.

 for ctr in range(2, 28):
    if 11 != ctr:  ## omit
        print print sheet0.col(ctr)