ByteScout Spreadsheet SDK - C# - Add Line Chart - ByteScout

ByteScout Spreadsheet SDK – C# – Add Line Chart

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

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.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

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"); } } }

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next