ByteScout Barcode Suite – VB.NET – Rich text formatting in cell with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Rich text formatting in cell with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Rich-text-formatting-in-cell-with-spreadsheet-sdk.pdf

rich text formatting in cell with spreadsheet sdk in VB.NET using ByteScout Barcode Suite

Simple tutorial on how to do rich text formatting in cell with spreadsheet sdk in VB.NET

ByteScout tutorials describe the stuff for programmers who use VB.NET. ByteScout Barcode Suite was made to help with rich text formatting 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 rich text formatting in cell with spreadsheet sdk. To use rich text formatting in cell with spreadsheet sdk in your VB.NET project or application just copy & paste the code and then run your app! VB.NET application implementation mostly involves various stages of the software development so even if the functionality works please check it with your data and the production environment.

Trial version along with the source code samples for VB.NET can be downloaded from our website

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 As Worksheet = document.Workbook.Worksheets.Add("Sheet1")

        ' set values for cells
        worksheet.Cell("A1").ValueAsHTML = "<b><u>Bold Underline</u>, and <i>bold italic</i></b> text"
        worksheet.Cell("A2").ValueAsHTML = "<font color=Blue>Blue</font>, <font color=Green>Green</font> and other <b><font face=Tahoma color=Red>co<font><font face=Tahoma color=Green>lo<font><font face=Tahoma color=Blue>rs<font></b> <font color=black><b>are</b> <u>available</u></font>"


        ' 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