ByteScout Spreadsheet SDK – C# – Add Line Chart

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

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

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

The tutorial below will demonstrate how to add line chart in C#

On this page you will learn from code samples for programming in C#.Writing of the code to add line chart in C# can be done by developers of any level using ByteScout Spreadsheet SDK. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays. It can be used to add line chart using C#.

The SDK samples like this one below explain how to quickly make your application do add line chart in C# with the help of ByteScout Spreadsheet SDK. In order to implement the functionality, you should copy and paste this code for C# below into your code editor with your app, compile and run your application. Use of ByteScout Spreadsheet SDK in C# is also explained in the documentation included along with the product.

ByteScout free trial version is available for download from our website. It includes all these programming tutorials along with source code samples.

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 System.IO;
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 lineChart = sheet.Charts.AddChartAndFitInto(1, 3, 16, 9, ChartType.Line);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

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

            lineChart = sheet.Charts.AddChartAndFitInto(1, 17, 16, 23, ChartType.LineStacked100);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            lineChart = sheet.Charts.AddChartAndFitInto(17, 3, 32, 9, ChartType.LineMarkers);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            lineChart = sheet.Charts.AddChartAndFitInto(17, 10, 32, 16, ChartType.LineMarkersStacked);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            lineChart = sheet.Charts.AddChartAndFitInto(17, 17, 32, 23, ChartType.LineMarkersStacked100);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 1, length - 1, 1)));

            lineChart = sheet.Charts.AddChartAndFitInto(33, 10, 48, 16, ChartType.Line3D);
            lineChart.SeriesCollection.Add(new Series(sheet.Range(0, 0, length - 1, 0)));
            lineChart.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");
        }
    }
}