首页新闻找找看学习计划

Python获取Excel表格时有的列为什么获取不到

0
悬赏园豆:20 [待解决问题]

在一次导数据过程中,通过xlrd从Excel表格里获取内容,为什么表格中有的列获取不到,前0~6列的内容能够正常获取,到第7列时获取的内容实际为第10列的内容,中间的列为什么跳过去了?谢谢高手指点~~~急急!

#-*- coding:utf-8 -*-
# 根据业务人员提供的科目代码excel生成交易相应的配置文件
import string
import database as db
import database.obj as obj
import datetime
from xlrd import xldate_as_tuple
from xlrd import open_workbook

def add_customer(file,sheet_name):
  wb = open_workbook(file)
  sheet = wb.sheet_by_name(sheet_name)
  fileHandle = open ( 'organization_customer.txt', 'a' )
  for row in range(1,sheet.nrows):    
    customer_no = transform_code_to_utf(sheet.cell(row,0).value)
    print customer_no
    id_type = transform_code_to_utf(sheet.cell(row,1).value)
    print id_type
    id_no = transform_code_to_utf(sheet.cell(row,2).value)
    print id_no
    registration_auth = transform_code_to_utf(sheet.cell(row,3).value)
    print registration_auth
    id_start_time = getdate(sheet.cell(row,4).value)
    print id_start_time
    id_end_time = getdate(sheet.cell(row,5).value)
    capital_currency = get_value(sheet.cell(row,23).value)
    china_sign = get_code(sheet.cell(row,24).value)
    customer_type = get_code(sheet.cell(row,31).value)
    public_enterprise_type = get_code(sheet.cell(row,32).value)
     organization_code = transform_code_to_utf(sheet.cell(row,6).value)
    print organization_code
    units_awarded = transform_code_to_utf(sheet.cell(row,7).value)
    print "XXXXX%sXXXXXX"%(units_awarded)
    sign_date = getdate(sheet.cell(row,8).value)
    print "IIIIIII%sIIIIIIIII"%(sign_date)
    end_date = getdate(sheet.cell(row,9).value)
    print "KKKKKKKKK%sKKKKKKK"%(end_date)
    customer_name = transform_code_to_utf(sheet.cell(row,10).value)
    print "QQQQQQ%sQQQQQQ"%(customer_name)
    english_name = transform_code_to_utf(sheet.cell(row,11).value)
    print "KKKKKK%sKKKKKKK"%(english_name)
    register_date = getdate(sheet.cell(row,12).value)
    print "LLLLL%sLLLLLLL"%(register_date)
    register_area_code = get_code(sheet.cell(row,13).value)
    print "TTTTTT%sTTTTT"%(register_area_code)
    credit_code_no = transform_code_to_utf(sheet.cell(row,14).value)
    print "PPPPPPP%sPPPP"%(credit_code_no)
    enterprise_property = transform_code_to_utf(sheet.cell(row,15).value)
    print "HHHHH%sHHHHHH"%(enterprise_property)
    corporate_enterprise = transform_code_to_utf(sheet.cell(row,16).value)
    print "UUUUUU%sUUUUUU"%(corporate_enterprise)

    
if  __name__=='__main__':
    if add_customer(u'数据文档/支行对公客户信息.xls',u'25银鹰')==False:
    exit(1)


 

背对光芒的主页 背对光芒 | 初学一级 | 园豆:179
提问于:2014-05-16 15:18
< >
分享
所有回答(1)
0

尝试了一下,并没有出现你所说的情况

-----------------------------------------------

选用的xls内容如下:

测试程序如下:

from xlrd import open_workbook

def add_customer(file,sheet_name):
    wb = open_workbook(file)
    sheet = wb.sheet_by_name(sheet_name)
    for row in range(0,sheet.nrows):
        for col in range(0,sheet.ncols):
            print "%4s" % sheet.cell(row, col).value, " ", 
        print " "

if  __name__=='__main__':
    if add_customer(u'test.xls',u'Sheet1')==False:
        exit(1)

得到的结果如下:

----------------------------------------------------------------

希望对你有所帮助~~

grassofsky | 园豆:342 (菜鸟二级) | 2014-05-16 17:40

非常感谢,原因找出来了,是项目组另外的人改动了Excel模板,他们把其中的列删除掉了,后来又还原了,而我不知道所以没有更新的缘故~

支持(0) 反对(0) 背对光芒 | 园豆:179 (初学一级) | 2014-05-16 18:26
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册