ByteScout Barcode Suite – C# – Add stock chart with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Add stock chart with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Add-stock-chart-with-spreadsheet-sdk.pdf

How to add stock chart with spreadsheet sdk in C# using ByteScout Barcode Suite

Learning is essential in computer world and the tutorial below will demonstrate how to add stock chart with spreadsheet sdk in C#

The code displayed below will guide you to install an C# app to add stock chart with spreadsheet sdk. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK). It can be applied to add stock chart with spreadsheet sdk using C#.

The following code snippet for ByteScout Barcode Suite works best when you need to quickly add stock chart with spreadsheet sdk in your C# application. IF you want to implement the functionality, just copy and paste this code for C# below into your code editor with your app, compile and run your application. If you want to use these C# sample examples in one or many applications then they can be used easily.

You can download free trial version of ByteScout Barcode Suite from our website to see and try many others 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.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
            for (int i = 1; i < 6; i++)
            {
                sheet[i, 0].Value = 39082 + i;
                sheet[i, 0].ValueDataTypeByNumberFormatString = Bytescout.Spreadsheet.Constants.NumberFormatType.DateTime;
            }

            sheet[1, 1].Value = 41301; sheet[1, 2].Value = 24.3; sheet[1, 3].Value = 27.2; sheet[1, 4].Value = 23.49; sheet[1, 5].Value = 25.45;
            sheet[2, 1].Value = 35203; sheet[2, 2].Value = 25.4; sheet[2, 3].Value = 25.03; sheet[2, 4].Value = 19.55; sheet[2, 5].Value = 23.05;
            sheet[3, 1].Value = 27908; sheet[3, 2].Value = 23; sheet[3, 3].Value = 19.05; sheet[3, 4].Value = 15.12; sheet[3, 5].Value = 17.32;
            sheet[4, 1].Value = 29567; sheet[4, 2].Value = 17.3; sheet[4, 3].Value = 20.33; sheet[4, 4].Value = 17.84; sheet[4, 5].Value = 20.45;
            sheet[5, 1].Value = 25895; sheet[5, 2].Value = 20.4; sheet[5, 3].Value = 18.56; sheet[5, 4].Value = 16.33; sheet[5, 5].Value = 17.35;

            // Add charts to worksheet
            Chart stockChart = sheet.Charts.AddChartAndFitInto(7, 1, 26, 9, ChartType.StockHLC);
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 3, 5, 3)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 4, 5, 4)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 5, 5, 5)));

            stockChart = sheet.Charts.AddChartAndFitInto(7, 10, 26, 18, ChartType.StockOHLC);
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 2, 5, 2)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 3, 5, 3)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 4, 5, 4)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 5, 5, 5)));

            stockChart = sheet.Charts.AddChartAndFitInto(28, 1, 46, 9, ChartType.StockVHLC);
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 1, 5, 1)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 3, 5, 3)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 4, 5, 4)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 5, 5, 5)));

            stockChart = sheet.Charts.AddChartAndFitInto(28, 10, 46, 18, ChartType.StockVOHLC);
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 1, 5, 1)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 2, 5, 2)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 3, 5, 3)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 4, 5, 4)));
            stockChart.SeriesCollection.Add(new Series(sheet.Range(1, 5, 5, 5)));

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