oracle分页导出excel,oracle导出excel,每6万生成一个excel文件

#! /usr/bin/python

#_*_coding:utf8_*_

import cx_Oracle,xlwt,time,sys,os,zipfile

from datetime import timedelta, datetime

default_encoding = 'utf-8'

if sys.getdefaultencoding() != default_encoding:

reload(sys)

sys.setdefaultencoding(default_encoding)

def export_excel_format(filename,savepath,dbuser,dbpasswd,address,table_name,start_point,end_point,condition='1=1'):

yesterday = datetime.today() + timedelta(-1)

yesterday_format = yesterday.strftime('%Y%m%d')

tadaypath = os.path.exists("%s/%s"%(savepath,yesterday_format))

if not tadaypath:

os.makedirs("%s/%s"%(savepath,yesterday_format))

conn = cx_Oracle.connect(dbuser,dbpasswd,address)

cursor = conn.cursor ()

cursor.execute ("select t.* from (select t.* ,rownum rowidnum from (sele