ByteScout Spreadsheet SDK – VB.NET – Font Style In Cell

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Font Style In Cell

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Font-Style-In-Cell.pdf

font style in cell in VB.NET using ByteScout Spreadsheet SDK

How to use ByteScout Spreadsheet SDK for font style in cell in VB.NET

These source code samples are listed and grouped by their programming language and functions they use. ByteScout Spreadsheet SDK was made to help with font style in cell in VB.NET. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays.

You will save a lot of time on writing and testing code as you may just take the code below and use it in your application. To do font style in cell in your VB.NET project or application you may simply copy & paste the code and then run your app! Test VB.NET sample code examples whether they respond your needs and requirements for the project.

ByteScout Spreadsheet SDK is available as free trial. You may get it from our website along with all other source code samples for VB.NET applications.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Module1.vb

      Imports Bytescout.Spreadsheet
Imports System.IO

Module Module1

    Sub Main()

        ' Create new Spreadsheet
        Dim document As New Spreadsheet()

        ' Add new worksheet
        Dim worksheet = document.Workbook.Worksheets.Add("Sheet1")

        ' Apply rich text formatting
        Worksheet.Cell("A1").Value = "Arial Italic Bold, Size=23"
        worksheet.Cell("A1").Font = New System.Drawing.Font("Arial", 23, System.Drawing.FontStyle.Bold Or System.Drawing.FontStyle.Italic)


        ' 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