如何用python连接Oracle数据库并往现有的excel文件添加内容_python实现将oracle的数据与现有excel中的数据匹配-优快云博客

本文链接：https://blog.youkuaiyun.com/ciscopaulch/article/details/115536505

本文介绍如何使用Python连接Oracle数据库，并将查询结果追加到现有Excel文件中。通过cx_Oracle和pandas等库实现数据库连接及数据读取，利用openpyxl保持原有工作表的同时写入新数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如何用python连接Oracle数据库并往现有的excel文件添加内容

import cx_Oracle
import pandas as pd
from openpyxl import load_workbook

conn = None
writer = None
username = "oracle_username"
password = "oracle_password"
ip = 'oracle_server_ip'
port = oracle_port
SID = 'oracle_sid'
dsn_tns = cx_Oracle.makedsn(ip, port, SID)
conn = cx_Oracle.connect(username, password, dsn_tns)
try:
	#these 4 lines below will make sure the existing worksheet will be kept
	fileName = "<full path of the file>"
	book = load_workbook(fileName)
	writer = pd.ExcelWriter(fileName, engine='openpyxl')
	writer.book = book
	writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
	data = pd.read_sql("<sql_string>", conn)
    data.to_excel(excel_writer=writer, sheet_name='myworksheet1', index=False)
   writer.save()   # use close in finally section

except cx_Oracle.DatabaseError as exc:
    err, = exc.args
    print("Oracle-Error-Code:", err.code)
    print("Oracle-Error-Message:", err.message)
except cx_Oracle.Error as error:
    print(error)
finally:
    # release the connection
    conn.close()
    writer.close()