import re
import matplotlib.pyplot as plt

def series_output(chart):
    print(f'\tChart name is {chart.Name}')
    for sc in chart.SeriesCollection():
        series = sc.Formula
        print(series)
        # Extract data range and values from the series formula
        match = re.search(r"SERIES\('.+?'\!(.+?),(.+?),(.+?),\d+\)", series)
        if match:
            data_range = match.group(2)
            data_values = match.group(3)
            # Process the data range and values to convert them to appropriate formats
            # You may need to adjust this part based on the specific format of your data
            x_values = [float(x.strip()) for x in data_range.split(":")[0][1:].split("$") if x.strip()]
            y_values = [float(y.strip()) for y in data_values.split(":")[0][1:].split("$") if y.strip()]
            # Plot the data using matplotlib
            plt.plot(x_values, y_values, label=chart.Name)
       
    print('*********************')
    print('                     ')
            

xl = client.Dispatch('Excel.Application')
wb = xl.Workbooks.Open(ef)
sh = wb.Sheets('Calc Tool')  
print(f'Processed sheet {sh.Name}')
for ch in sh.ChartObjects():
    series_output(ch.Chart)

# Add legends, labels, and show the plot
plt.legend()
plt.xlabel('X values')
plt.ylabel('Y values')
plt.show()

wb.Close(False)  # don't save & close workbook
xl.Quit()

字符串
您可能需要根据数据的特定格式调整数据处理部分。