Modify Chart in Word with actxserver

VINCENT

2026 8 5

0 个回答

27 次查看（30 天）

显示更早的评论

0 个投票

Hello everyone, I'm working on a word template file including chart that have been included from Excel. I'm willing to modify those charts. For now I'm able to find the corresponding chart using the caption. But whenever I modify the chart, it only show 1 point in (0,0) instead of the curve that was shown before.

I would appreciate any help on this !

Thanks in advance

WordApplication=actxserver('Word.Application')
Documents = WordApplication.Documents;
Documents.Open(fullSavefile);
Doc = Documents.Item(Documents.Count);
update_word_chart_by_caption(Doc, 'Caption Title',X,Y);
function update_word_chart_by_caption(Doc, captionText, xValues, yValues, warnings)
    chartObj = find_chart_by_caption(Doc, captionText);
    Chart = chartObj.Chart;
    xValues = double(xValues(:))';
    yValues = double(yValues(:))';
    Series = Chart.SeriesCollection.Item(1);
    Series.XValues = xValues;
    Series.Values  = yValues;
    Chart.Refresh;
end
function chartObj = find_chart_by_caption(Doc, captionText)
    chartObj = [];
    Text_Margin_Search = 50; %Search in the following 50 characters
    for i = 1:Doc.InlineShapes.Count
        Item = Doc.InlineShapes.Item(i);
        if Item.HasChart
            afterStart = Item.Range.End;
            afterEnd = min(Item.Range.End + Text_Margin_Search, Doc.Content.End);
            txtAfter = char(Doc.Range(afterStart, afterEnd).Text);
            aroundText = normalize_text(txtAfter);
            if contains(aroundText, target)
                chartObj = Item;
                return;
            end
        end
    end

2 个评论
显示无隐藏无

Torsten 2026-8-5，13:29

Why do you try to do this in MATLAB and not directly in Word ?

VINCENT about 12 hours 前

I have to do it many times (~100 times) and the X and Y values come from calculations, so it would be longer to save them as xlsx files and plot them.

请先登录，再进行评论。

请先登录，再回答此问题。

请先登录再关注