#!/usr/bin/python
# -*- coding: UTF-8 -*-
#-------------------------------------------------------------------------------
# Name: createExcel.py
# Author: ranyuan
# Email: yuan.ran@msxf.com
# Created: 23/02/2016
# requirement: python >=2.6
#-------------------------------------------------------------------------------
import xlsxwriter #pip install xlsxwriter
#import mysqldml # this is for the example at end of page
class excelpro:
def __init__(self,excelname):
self.excelname = excelname
# create a excel file
def createExcel(self):
workbook = xlsxwriter.Workbook(self.excelname)
return workbook
# create Sheet if have many sheet in one excel file
def createSheet(self,workbook,sheetName,queryColumnResult,queryResult):
worksheet = workbook.add_worksheet(sheetName)
# process column name to excel
colres = queryColumnResult
bo
通过python将MySQL,Oracle查询的数据存到Excel文件
最新推荐文章于 2023-08-02 18:28:43 发布
这个Python脚本使用xlsxwriter库创建Excel文件,并从MySQL和Oracle数据库中导出查询结果。通过`excelpro`类,可以初始化Excel文件,创建工作表,写入查询结果,并关闭文件。示例代码展示了如何处理SQL查询并将其数据存储到不同工作表中。
摘要由CSDN通过智能技术生成