[python-win32] save chart from an existing xlsx as an image

[Vernon D. Cole]

It might be possible to run some older versions of Excel on Linux using wine
<https://winehq.org/> or crossover <https://codeweavers.com/products/>, but
I do not think that you will be able to control them using COM.  Python 2.7
(32 bit) for Windows and pywin32 can be installed using Wine, but many
features do not work. (I tried using Ubuntu 14.04).

It might be better to try opening your spreadsheet using libreoffice
<http://www.libreoffice.org/>, which has the ability to export .pdf files
(and works on both Linux and Windows).

Otherwise, you might only be able to make screen shots of your Excel window
using a Windows computer.



On Fri, Jun 20, 2014 at 8:23 AM, Weijie Wu -X (weijwu - YI JIN XIN XI FU
WU(SU ZHOU)YOU XIAN GONG SI at Cisco) <weijwu at cisco.com> wrote:

>  Hi, guys
>
>
>
> I know win32com is working on windows for python, and I’ve question:
>
> I want to save chart from demo.xlsx as an image.  I also found some code
> as below:
>
>
>
> *from win32com.client import Dispatch*
>
> *xlsApp = Dispatch("Excel.Application") *
>
> *xlsWB = xlsApp.Workbooks.Open(r'/tmp/test/demo.xlsx') *
>
> *xlsSheet = xlsWB.Sheets("sheet1") *
>
> *mychart = XlsSheet.Charts(1)  #'1' is the index of the chart object in
> the wb*
>
> *mychart.Export(Filename=r'/tmp/test/MyExportedChart.png')*
>
>
>
>
>
> is there anyway I can run this code on linux ?
>
>
>
> or is there anyway I can save chart from an existing xlsx as an image?
>
>
>
> It drives me crazy.
>
>
>
>
>
> Thanks
>
> Wiley
>
>
>
>
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> https://mail.python.org/mailman/listinfo/python-win32
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20140620/cc50ce40/attachment.html>