Export Charts from Excel as images using Python

by

I had to look at some VBA examples to get this working. Although I hate answering my own questions, I am leaving this here for people who might need it.

    import win32com.client as win32
    wb = excel.Workbooks.Open(excel_file)
    selection = "A1:J30" 
    xl_range = wb.Sheets(<sheet_name>).Range(selection)
    excel.ActiveWorkbook.Sheets.Add(                  After=excel.ActiveWorkbook.Sheets(3)).Name="image_sheet"
    cht = excel.ActiveSheet.ChartObjects().Add(0,0,
                                            xl_range.Width, xl_range.Height)
    xl_range.CopyPicture()
    # add the chart to new sheet
    cht.Chart.Paste()
    # Export the sheet with the chart to a new file
    cht.Chart.Export(<image_filename>)
    # Delete the sheet
    cht.Delete()
    excel.ActiveSheet.Delete()
    # Close the book
    excel.ActiveWorkbook.Close()

More Related Contents:

  1. ImportError: No module named win32com.client
  2. Windows 7: how to bring a window to the front no matter what other window has focus?
  3. .xlsx and xls(Latest Versions) to pdf using python
  4. GetWindowRect too small on Windows 7
  5. Python: Open Excel Workbook using Win32 COM Api
  6. Get other running processes window sizes in Python
  7. IOError: [Errno 13] Permission denied when trying to open hidden file in “w” mode
  8. Can’t import dll module in Python
  9. python-win32com excel com model started generating errors
  10. Print PDF document with python’s win32print module?
  11. Export a list of stock prices to excel
  12. Non-blocking console input?
  13. I can’t install pyaudio on Windows? How to solve “error: Microsoft Visual C++ 14.0 is required.”?
  14. Running Python on Windows for Node.js dependencies
  15. Jupyter Notebook with Python 3.8 – NotImplementedError
  16. python pip on Windows – command ‘cl.exe’ failed
  17. Why does termcolor output control characters instead of colored text in the Windows console?
  18. Flask CLI throws ‘OSError: [Errno 8] Exec format error’ when run through docker-compose
  19. Convert date from excel in number format to date format python [duplicate]
  20. What is the best way to map windows drives using Python?
  21. Merge rows based on value (pandas to excel – xlsxwriter)
  22. Run multiple programs sequentially in one Windows command prompt?
  23. How to add to and remove from system’s environment variable “PATH”?
  24. Is it possible to get writing access to raw devices using python with windows?
  25. pickle.load() raising EOFError in Windows
  26. django excel xlwt
  27. ‘pip setup.py bdist_wheel’ no longer builds forced non-pure wheels
  28. Add “django-admin.py” path to command line on Windows 7
  29. Python long filename support broken in Windows
  30. Detecting computer/program shutdown in Python?

Leave a Comment