Add Line Chart - VB.NET
Spreadsheet SDK sample in VB.NET demonstrating ‘Add Line Chart’
Module1.vb
Imports Bytescout.Spreadsheet
Imports Bytescout.Spreadsheet.Charts
Imports System.IO
Module Module1
Sub Main()
' Create new Spreadsheet object
Dim spreadsheet As New Spreadsheet()
spreadsheet.RegistrationName = "demo"
spreadsheet.RegistrationKey = "demo"
' Add new worksheet
Dim sheet As Worksheet = spreadsheet.Workbook.Worksheets.Add("Sample")
' Add few random numbers
Dim length As Integer = 10
Dim rnd As New Random()
For i As Integer = 0 To length - 1
sheet.Cell(i, 0).Value = rnd.[Next](10)
sheet.Cell(i, 1).Value = rnd.[Next](10)
Next
' Add charts to worksheet
Dim lineChart As Chart = 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")
End Sub
End Module
+ Show More
Explore SDK documentations here.
Resources.Designer.vb
��'------------------------------------------------------------------------------
' <auto-generated>
' This code was generated by a tool.
' Runtime Version:2.0.50727.42
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------
Option Strict On
Option Explicit On
Namespace My.Resources
'This class was auto-generated by the StronglyTypedResourceBuilder
'class via a tool like ResGen or Visual Studio.
'To add or remove a member, edit your .ResX file then rerun ResGen
'with the /str option, or rebuild your VS project.
'<summary>
' A strongly-typed resource class, for looking up localized strings, etc.
'</summary>
<Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "2.0.0.0"), _
Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
Global.System.Runtime.CompilerServices.CompilerGeneratedAttribute(), _
Global.Microsoft.VisualBasic.HideModuleNameAttribute()> _
Friend Module Resources
Private resourceMan As Global.System.Resources.ResourceManager
Private resourceCulture As Global.System.Globalization.CultureInfo
'<summary>
' Returns the cached ResourceManager instance used by this class.
'</summary>
<Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)> _
Friend ReadOnly Property ResourceManager() As Global.System.Resources.ResourceManager
Get
If Object.ReferenceEquals(resourceMan, Nothing) Then
Dim temp As Global.System.Resources.ResourceManager = New Global.System.Resources.ResourceManager("VB.NET.Resources", GetType(Resources).Assembly)
resourceMan = temp
End If
Return resourceMan
End Get
End Property
'<summary>
' Overrides the current thread's CurrentUICulture property for all
' resource lookups using this strongly typed resource class.
'</summary>
<Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)> _
Friend Property Culture() As Global.System.Globalization.CultureInfo
Get
Return resourceCulture
End Get
Set(ByVal value As Global.System.Globalization.CultureInfo)
resourceCulture = value
End Set
End Property
End Module
End Namespace
+ Show More
Explore SDK documentations here.
Settings.Designer.vb
��'------------------------------------------------------------------------------
' <auto-generated>
' This code was generated by a tool.
' Runtime Version:2.0.50727.42
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------
Option Strict On
Option Explicit On
Namespace My
<Global.System.Runtime.CompilerServices.CompilerGeneratedAttribute(), _
Global.System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "8.0.0.0"), _
Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)> _
Partial Friend NotInheritable Class MySettings
Inherits Global.System.Configuration.ApplicationSettingsBase
Private Shared defaultInstance As MySettings = CType(Global.System.Configuration.ApplicationSettingsBase.Synchronized(New MySettings), MySettings)
#Region "My.Settings Auto-Save Functionality"
#If _MyType = "WindowsForms" Then
Private Shared addedHandler As Boolean
Private Shared addedHandlerLockObject As New Object
<Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)> _
Private Shared Sub AutoSaveSettings(ByVal sender As Global.System.Object, ByVal e As Global.System.EventArgs)
If My.Application.SaveMySettingsOnExit Then
My.Settings.Save()
End If
End Sub
#End If
#End Region
Public Shared ReadOnly Property [Default]() As MySettings
Get
#If _MyType = "WindowsForms" Then
If Not addedHandler Then
SyncLock addedHandlerLockObject
If Not addedHandler Then
AddHandler My.Application.Shutdown, AddressOf AutoSaveSettings
addedHandler = True
End If
End SyncLock
End If
#End If
Return defaultInstance
End Get
End Property
End Class
End Namespace
Namespace My
<Global.Microsoft.VisualBasic.HideModuleNameAttribute(), _
Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
Global.System.Runtime.CompilerServices.CompilerGeneratedAttribute()> _
Friend Module MySettingsProperty
<Global.System.ComponentModel.Design.HelpKeywordAttribute("My.Settings")> _
Friend ReadOnly Property Settings() As Global.VB.NET.My.MySettings
Get
Return Global.VB.NET.My.MySettings.Default
End Get
End Property
End Module
End Namespace
+ Show More
Explore SDK documentations here.