【问题】
想要折腾Python中的Excel中的图标，Chart，Graph。
【解决过程】
1.参考：
use python to generate graph in excel
说是可以用pywin32的OLE automation
去试试其代码：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | #!/usr/bin/python# -*- coding: utf-8 -*-"""Function:【已解决】Python中处理操作Excel中的图表（Chart，Graph）Author: Crifan LiVersion: 2012-12-25Contact: admin at crifan dot com"""from win32com.client import Dispatch;def excelChart(): ex = Dispatch("Excel.Application"); print "ex=",ex; if __name__ == "__main__": excelChart(); |
结果出错：
D:\tmp\tmp_dev_root\python\excel_chart>excel_chart.py File "D:\tmp\tmp_dev_root\python\excel_chart\excel_chart.py", line 13, in <module> from win32com.client import Dispatch; ImportError: No module named win32com.client |
很明显，是没有对应的库。
2.关于上述错误的折腾过程，参见：
【已解决】Python中出错：ImportError: No module named win32com.client
3.再参考：
Creating Charts in Excel with pyExcelerator.ExcelMagic
去写代码，结果又出现了错误，详细折腾过程见：
4.最后，最终结果是，
在当前文件夹下面，建立一个空的xsl文件：chart_demo.xls
然后用下面的代码：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | #!/usr/bin/python# -*- coding: utf-8 -*-"""Function:【已解决】Python中处理操作Excel中的图表（Chart，Graph）Author: Crifan LiVersion: 2012-12-25Contact: admin at crifan dot com"""import os;from win32com.client import Dispatch;#from win32com.client import *;def excelChart(): xl = Dispatch("Excel.Application"); #xl = win32com.client.Dispatch("Excel.Application") print "xl=",xl; #[1] Fail # xlsPath = "chart_demo.xls"; # wb = xl.Workbooks.open(xlsPath); #pywintypes.com_error #[2] Fail # xlsPath = "D:\tmp\tmp_dev_root\python\excel_chart\chart_demo.xls"; # absPath = os.path.abspath(xlsPath); # print "absPath=",absPath; #absPath= D:\tmp\tmp_dev_root\python\excel_chart\ mp mp_dev_root\python\excel_chart\chart_demo.xls # wb = xl.Workbooks.open(absPath); #pywintypes.com_error #[3] Fail # xlsPath = "D:\tmp\tmp_dev_root\python\excel_chart\chart_demo.xls"; # normalPath = os.path.normpath(xlsPath); # print "normalPath=",normalPath; #normalPath= D: mp mp_dev_root\python\excel_chart\chart_demo.xls # wb = xl.Workbooks.open(normalPath); #pywintypes.com_error #[4] Fail # rawPath = r"chart_demo.xls"; # wb = xl.Workbooks.open(rawPath); #pywintypes.com_error #[5] OK xlsPath = "chart_demo.xls"; absPath = os.path.abspath(xlsPath); print "absPath=",absPath; #absPath= D:\tmp\tmp_dev_root\python\excel_chart\chart_demo.xls wb = xl.Workbooks.open(absPath); #OK #[6] OK # rawPath = r"D:\tmp\tmp_dev_root\python\excel_chart\chart_demo.xls"; # wb = xl.Workbooks.open(rawPath); # OK xl.Visible = 1; ws = wb.Worksheets(1); ws.Range('$A1:$D1').Value = ['NAME', 'PLACE', 'RANK', 'PRICE']; ws.Range('$A2:$D2').Value = ['Foo', 'Fooland', 1, 100]; ws.Range('$A3:$D3').Value = ['Bar', 'Barland', 2, 75]; ws.Range('$A4:$D4').Value = ['Stuff', 'Stuffland', 3, 50]; wb.Save(); wb.Charts.Add(); wc1 = wb.Charts(1); if __name__ == "__main__": excelChart(); |
写入的excel中的内容是：
生成的图表的效果是：
【总结】
总的来说，使用win32com.client，去操作excel文件，效果还是不错的。