我对python并尝试处理一个项目,该项目要求我从SQL(.db)数据库,并将这些数据输出到Excel文件中。
我的数据库文件有很多数据,但我设法打印的结构如下Run ID | Environment
1 52
2 52
3 52
4 52
5 72
6 72
7 72
8 72
....
现在我需要能够将这些值输出到像这样的Excel电子表格中,52-72-92-112-112-132
下面是我的当前代码,它允许我输出52,000,000,000,000,000,000,000,000,000,000,000
A是c.fetchall()在模块访问数据库中,任何帮助都是非常感谢的。Access_Database_Module.Access_Database(DB)
x = 2
DBcommand = "SELECT * FROM " + a[x][0]
print(a[x][0])
c.execute(DBcommand)
y = c.fetchall()
x = y
workbook = xls.Workbook('Environment.xlsx')
worksheet = workbook.add_worksheet('Environment Direction')
rowNum = 0
colNum = 1
workbook = xls.Workbook('Environment.xlsx')
worksheet = workbook.add_worksheet('Environment Direction')
for item in y:
while colNum == colNum + 1 :
colNum
worksheet.write(rowNum, colNum, item[14])
colNum += 1
workbook.close()