python-win32com-excel-分列,设置坐标轴格式

python-excel-分列,设置坐标轴格式

from win32com.client import Dispatch
import os
import logging
import traceback
import sys

"""
从excel中提取图表，生成图片
"""

def excelChart(workbook_file_name):
    """


    :param workbook_file_name:
    :return:
    """


    # workbook_file_name = r'D:\pythonworkspace\develop\DCU\prime\scan\analyse\data.xlsx'
    try:
        app = Dispatch("Excel.Application")
        workbook = app.Workbooks.Open(Filename=workbook_file_name)
        # WARNING: The following line will cause the script to discard any unsaved changes in your workbook
        app.DisplayAlerts = False
        imageList = []

        for sheet in workbook.Worksheets:
            if sheet.Name.find("Sheet") != -1:
                continue
            if sheet.UsedRange.Rows.Count > 1:
                # 分列
                xlDelimited = 1
                xlDoubleQuote = 1
                sheet.Columns("B:B").TextToColumns(Destination=sheet.Range("B1"), DataType=xlDelimited,
                                                 TextQualifier=xlDoubleQuote, ConsecutiveDelimiter=False, Tab=False, Semicolon=False,
                                                 Comma=False, Space=False, Other=True, OtherChar="_", FieldInfo=(1, 1),
                                                 TrailingMinusNumbers=True)
            for chartObject in sheet.ChartObjects():
                # 设置纵坐标格式为时间
				chartObject.Chart.Axes(2).TickLabels.NumberFormatLocal = "[$-x-systime]h:mm:ss AM/PM"
    except Exception as er:
        logging.error(f"** Meet exception ** :{er}")
        logging.error("".join(traceback.format_exception(*sys.exc_info())))
    finally:
        workbook.Close(SaveChanges=True, Filename=workbook_file_name)