Syncfusion.XlsIO.Base
Example 


Clear Method (IChartTrendLines)

Clears current IChartTrendLines collection.
Syntax
'Declaration
 
Sub Clear() 
'Usage
 
Dim instance As IChartTrendLines
 
instance.Clear()
void Clear()
Example
The following code illustrates how to clear IChartTrendLines collection
using Syncfusion.XlsIO;
using System;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            
            //Get chart serie
            IChartSerie serie = chart.Series[0];
            
            //Get chart serie trendlines collection
            IChartTrendLines trendLines = serie.TrendLines;
            
            //Add trendlines
            IChartTrendLine trendLine1 = trendLines.Add(ExcelTrendLineType.Logarithmic);
            IChartTrendLine trendLine2 = trendLines.Add(ExcelTrendLineType.Linear);
            
            Console.WriteLine("Before TrendLines Count is: " + trendLines.Count);
            
            //Clears the trendlines collection
            trendLines.Clear();
            
            Console.WriteLine("After TrendLines Count is: " + trendLines.Count);
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
            Console.ReadKey();        
        }
    }
}
//Output will be
//Before TrendLines Count is: 2
//After TrendLines Count is: 0
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also