正在从excel获取数据。将附加垃圾值。
您好,我正在使用python代码从EXCEL中获取数据..我也能看到它的一些垃圾价值。如[文本:U
如何移除它..以下是代码
选择 | 换行 | 行号
- 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)