ByteScout Spreadsheet SDK – VB.NET – Rich Text Formatting in Cell

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Rich Text Formatting in Cell

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Rich-Text-Formatting-in-Cell.pdf

rich text formatting in cell in VB.NET and ByteScout Spreadsheet SDK

How to code rich text formatting in cell in VB.NET: How-To tutorial

On this page you will learn from code samples for programming in VB.NET. ByteScout Spreadsheet SDK helps with rich text formatting in cell in VB.NET. ByteScout Spreadsheet SDK is the SDK component for writing, reading, modifying and calculating Excel and CSV spreadsheets. Can calculate and reculculate formulas with Excel installed. You may import or export data to and from CSV, XML, JSON. Supports export to databases, arrays, streams.

Fast application programming interfaces of ByteScout Spreadsheet SDK for VB.NET plus the instruction and the VB.NET code below will help you quickly learn rich text formatting in cell. To do rich text formatting in cell in your VB.NET project or application you may simply copy & paste the code and then run your app! Further enhancement of the code will make it more vigorous.

Visit our website provides for free trial version of ByteScout Spreadsheet SDK. Free trial includes lots of source code samples to help you with your VB.NET project.

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