查了很多相關 Microsoft.Office.Interop.Excel
Excel.Series series = (Excel.Series)chartPage.SeriesCollection(1);
//Setting the series to Secondary (y) axis so as to format the same
series.AxisGroup = Excel.XlAxisGroup.xlSecondary;
//Setting the trendline type
Excel.Trendlines trendlines = (Excel.Trendlines)series.Trendlines(System.Type.Missing);
issing);
Excel.Trendline trendline =
trendlines.Add(Microsoft.Office.Interop.Excel.XlTrendlineType.xlLinear, 2,
0, misValue, misValue, misValue, false, false, misValue);
查了很多相關Trendline的用法 都會跑出COMEXCEPTION
請問有人知道怎麼解決嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 106.1.242.102