Python을 사용하여 Oracle에서 데이터를 내보내는 동안 Excel이 충돌했습니다.

아래 코드를 시도하고 python을 사용하여 oracle에서 xlsx 형식으로 데이터를 내보내는 작업을 성공적으로 수행했습니다.

import xlsxwriter
from xlsxwriter import Workbook
import cx_Oracle
import datetime
from datetime import date
import os
import logging
import sys
import getopt
import traceback

## Define Function
def writeToExcel(cur_sor):
    
    workbook = xlsxwriter.Workbook('path.xlsx')
    worksheet = workbook.add_worksheet("DATA") #Add a New Worksheet Name - 
    
 
    for row, row1 in enumerate(cur_sor.fetchall()):
        
    
         for col, col1 in enumerate(row1):
             
              
              worksheet.write(row, col, col1)
        

    workbook.close() 


def setSqlCommand():
    
    
    sqlCommand = '''
    SELECT * 
            FROM
                ( SELECT LROWNUM,DTIMESTAMP,LSCENARIO,LYEAR,LPERIOD,
                      LENTITY,LPARENT,LVALUE,LACCOUNT,LICP,LCUSTOM1,
                      LCUSTOM2,STRUSERNAME,STRSERVERNAME,
                      LACTIVITY,DDATAVALUE,BNODATA,
                      To_Date('12/30/1899','MM/DD/YYYY') +
                          DTIMESTAMP as Decoded_Date
                  FROM tablename
                ) SUB
            WHERE SUB.Decoded_Date 
                  <= to_date('28-JUN-2020', 'DD-MON-YYYY')
                  '''
    return sqlCommand


# Function to Execute Sql commands over TNS
def runSqlTNS (sqlCommand, username, password , hostName, portNumber, sID):
    
    
        
    dsn_tns = cx_Oracle.makedsn('HOST', 'PORT', sid='SERVICEID') 
    
    db = cx_Oracle.connect(user=r'USERNAME', password='PASSWORD', dsn=dsn_tns)
    
    cursor = db.cursor()
    cursor.execute(sqlCommand)
 
    return cursor

def main(argv=None):

#Setup Logging Information
        logging.basicConfig(filename='PATH/myapp.log', level=logging.INFO, format='%(asctime)s %(message)s', datefmt='%m/%d/%Y %I:%M:%S %p')
        logging.info('Started')

        username = 'USERNAME'
        password = 'PASSWORD'
        #Define dsn entries to create a tns connection
        hostName = 'HOST'
        portNumber = 'PORT'
        sid = 'SERVICEID'
        #
        try:
                sqlCommand = setSqlCommand()
        except Exception as e:
                logging.info('Function - sqlCommand - In Exception')
                logging.info(traceback.print_exc())

        try:
            
            
            c = runSqlTNS(sqlCommand, username, password , hostName, portNumber, sid)
        except Exception as e:
                logging.info('Function - runSql In Exception')
                logging.info(traceback.print_exc())
        try:
            
            writeToExcel(c) # Send the Cursor to writetoExcel Function
            c.close()
        except Exception as e:
                logging.info('Function - writeToExcel In Exception')
                logging.info(traceback.print_exc())

if __name__ == "__main__":

    main(sys.argv)