ByteScout Barcode Suite – VB.NET – Font style in cell with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Font style in cell with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Font-style-in-cell-with-spreadsheet-sdk.pdf

font style in cell with spreadsheet sdk in VB.NET and ByteScout Barcode Suite

font style in cell with spreadsheet sdk in VB.NET

This page explains the steps and algorithm of implementing font style in cell with spreadsheet sdk and how to make it work in your application. ByteScout Barcode Suite helps with font style in cell with spreadsheet sdk in VB.NET. 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).

If you want to quickly learn then these fast application programming interfaces of ByteScout Barcode Suite for VB.NET plus the guideline and the VB.NET code below will help you quickly learn font style in cell with spreadsheet sdk. If you want to know how it works, then this VB.NET sample code should be copied and pasted into your application’s code editor. Then just compile and run it. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

Trial version can be downloaded from our website for free. It contains this and other source code samples for VB.NET.

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