Use Rich Formatting to Create Report - VB.NET
Spreadsheet SDK sample in VB.NET demonstrating ‘Use Rich Formatting to Create Report’
Module1.vb
Imports Bytescout.Spreadsheet
Imports Bytescout.Spreadsheet.Constants
Imports System.IO
Imports System.Diagnostics
Imports System.Drawing
Module Module1
Sub Main()
' Create new Spreadsheet
Dim document As Spreadsheet = New Spreadsheet()
' Add new worksheet
Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("AdvancedReport")
' Set Values
worksheet.Cell(0, 0).Value = "Name"
worksheet.Cell(0, 1).Value = "Full Name"
Dim headerColor As Color = [Color].FromArgb(75, 172, 198)
Dim contentColor As Color = [Color].FromArgb(141, 180, 227)
' Set font bold for headers
worksheet.Cell(0, 0).Font = New Font("Arial", 12, FontStyle.Bold)
worksheet.Cell(0, 1).Font = New Font("Arial", 12, FontStyle.Bold)
' Set back color for headers rows
worksheet.Cell(0, 0).FillPattern = PatternStyle.Solid
worksheet.Cell(0, 0).FillPatternForeColor = headerColor
worksheet.Cell(0, 1).FillPattern = PatternStyle.Solid
worksheet.Cell(0, 1).FillPatternForeColor = headerColor
worksheet.Cell(6, 0).FillPattern = PatternStyle.Solid
worksheet.Cell(6, 0).FillPatternForeColor = headerColor
worksheet.Cell(6, 0).FontColor = Color.White
worksheet.Cell(6, 1).FillPattern = PatternStyle.Solid
worksheet.Cell(6, 1).FillPatternForeColor = headerColor
' Set back color for content rows
For i As Integer = 1 To 5
worksheet.Cell(i, 0).FillPattern = PatternStyle.Solid
worksheet.Cell(i, 0).FillPatternForeColor = contentColor
worksheet.Cell(i, 1).FillPattern = PatternStyle.Solid
worksheet.Cell(i, 1).FillPatternForeColor = contentColor
Next
worksheet.Cell(1, 0).Value = "Homer"
worksheet.Cell(1, 1).Value = "Homer Jay Simpson"
worksheet.Cell(2, 0).Value = "Marjorie"
worksheet.Cell(2, 1).Value = "Marjorie Marge Simpson (Bouvier)"
worksheet.Cell(3, 0).Value = "Bartholomew"
worksheet.Cell(3, 1).Value = "Bartholomew Jojo Bart Simpson"
worksheet.Cell(4, 0).Value = "Lisa"
worksheet.Cell(4, 1).Value = "Lisa Marie Simpson"
worksheet.Cell(5, 0).Value = "Margaret"
worksheet.Cell(5, 1).Value = "Margaret Maggie "
worksheet.Cell(6, 0).Value = "Count"
worksheet.Cell(6, 1).Value = "5"
worksheet.Columns(1).Width = 250
worksheet.Columns(2).Width = 250
' remove output file if already exists
If File.Exists("Output.xls") Then
File.Delete("Output.xls")
End If
' Save document
document.SaveAs("Output.xls")
' Close Spreadsheet
document.Close()
' open in default spreadsheets viewer/editor
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.1433
'
' 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("Using_rich_formatting__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.1433
'
' 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.Using_rich_formatting__VB.NET_.My.MySettings
Get
Return Global.Using_rich_formatting__VB.NET_.My.MySettings.Default
End Get
End Property
End Module
End Namespace
+ Show More
Explore SDK documentations here.