ByteScout Spreadsheet SDK – C# – Add Radar Chart

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

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

How to add radar chart in C# with ByteScout Spreadsheet SDK

Write code in C# to add radar chart with this step-by-step tutorial

The code below will help you to implement an C# app to add radar chart. 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. It can add radar chart in C#.

You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Spreadsheet SDK for add radar chart below and use it in your application. This C# sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Implementing C# application typically includes multiple stages of the software development so even if the functionality works please test it with your data and the production environment.

Free trial version of ByteScout Spreadsheet SDK is available for download from our website. Get it to try other source code samples for C#.

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(1, 10);
                sheet.Cell(i, 1).Value = rnd.Next(1, 5);
            }

            // Add charts to worksheet
            Chart radarChart = sheet.Charts.AddChartAndFitInto(1, 3, 16, 9, ChartType.Radar);
            radarChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            radarChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            radarChart = sheet.Charts.AddChartAndFitInto(1, 10, 16, 16, ChartType.RadarMarkers);
            radarChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            radarChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            radarChart = sheet.Charts.AddChartAndFitInto(1, 17, 16, 23, ChartType.RadarFilled);
            radarChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            radarChart.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");
        }
    }
}