python excel表格生成图片-使用Python导出Excel图表以及导出为图片的方法

本篇讲下如何使用纯python代码将excel 中的图表导出为图片。这里需要使用的模块有win32com、pythoncom模块。

网上经查询有人已经写好的模块pyxlchart，具体代码如下：

from win32com.client import Dispatch

import os

import pythoncom

class Pyxlchart(object):

"""

This class exports charts in an Excel Spreadsheet to the FileSystem

win32com libraries are required.

"""

def __init__(self):

pythoncom.CoInitialize()

self.WorkbookDirectory = ""

self.WorkbookFilename = ""

self.GetAllWorkbooks = False

self.SheetName = ""

self.ChartName = ""

self.GetAllWorkbookCharts = False

self.GetAllWorksheetCharts = False

self.ExportPath = ""

self.ImageFilename = ""

self.ReplaceWhiteSpaceChar = "_"

self.ImageType = "jpg"

def __del__(self):

pass<