ByteScout Spreadsheet SDK – C# – Add Doughnut Chart

Home
/
Articles
/
ByteScout Spreadsheet SDK – C# – Add Doughnut Chart

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Add-Doughnut-Chart.pdf

How to add doughnut chart in C# using ByteScout Spreadsheet SDK

Tutorial on how to add doughnut chart in C#

These sample source codes on this page below are demonstrating how to add doughnut chart in C#. Want to add doughnut chart in your C# app? ByteScout Spreadsheet SDK is designed for it. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays.

C# code samples for C# developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. In your C# project or application you may simply copy & paste the code and then run your app! This basic programming language sample code for C# will do the whole work for you to add doughnut chart.

Free trial version of ByteScout Spreadsheet SDK is available on our website. Documentation and source code samples are included.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Diagnostics;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.Charts;

namespace CSharp
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet object
            Spreadsheet spreadsheet = new Spreadsheet();
            spreadsheet.RegistrationName = "demo";
            spreadsheet.RegistrationKey = "demo";

            // Add new worksheet
            Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample");

            // Add few random numbers
            int length = 10;
            Random rnd = new Random();
            for (int i = 0; i < length; i++)
            {
                sheet.Cell(i, 0).Value = rnd.Next(10);
                sheet.Cell(i, 1).Value = rnd.Next(10);
            }

            // Add charts to worksheet
            Chart doughnutChart = sheet.Charts.AddChartAndFitInto(12, 1, 35, 9, ChartType.Doughnut);
            doughnutChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            doughnutChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            doughnutChart = sheet.Charts.AddChartAndFitInto(12, 10, 35, 18, ChartType.DoughnutExploded);
            doughnutChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            doughnutChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            // Save it as XLS
            spreadsheet.SaveAs("Output.xls");

            // Close the document
            spreadsheet.Close();

            // Cleanup
            spreadsheet.Dispose();

            // Open generated XLS file in default associated application
            Process.Start("Output.xls");
        }
    }
}