Python操作Excel生成数据库定义。
#!/usr/bin/env python# -*- coding:utf8-*-
import xlrd
class WorkBook():
def __init__(self):
pass
def __del__(self):
pass
def readExcel(self,excelFile):
book = xlrd.open_workbook(excelFile)
return book
def readSheet(self,sheet):
lifiled = sheet.col(2)#字段
litype = sheet.col(4) #类型
lilength = sheet.col(5) #长度
linull = sheet.col(6) #是否为空
#print "++++++++++++++++++++++++++++++++++++"
print "CREATE TABLE DamsDB.dbo.%s" %(sheet.name,)
print "("
for i in range(0,(sheet.nrows - 5)):
if lilength.value != "":
if linull.value == "":
print " %s %s (%s)," %(lifiled.value,litype.value,lilength.value)
else:
print " %s %s (%s) %s," %(lifiled.value,litype.value,lilength.value,"NOT NULL")
else:
if linull.value != "":
print " %s %s %s," %(lifiled.value,litype.value,linull.value)
else:
print " %s %s," %(lifiled.value,litype.value)
print ")"
print "GO"
print "\n"
#print "++++++++++++++++++++++++++++++++++++"
if __name__ == "__main__":
workbook = WorkBook()
book = workbook.readExcel("d:\\a.xls")
print "The number of worksheets is", book.nsheets
for i in range(3, book.nsheets):
#print "+++++++++++ i ==",i
workbook.readSheet(book.sheet_by_index(i))
页:
[1]