Tuesday, 27 March 2012 06:24

Excel Wrap/Unwrap-Wrap/Unwrap Text in Excel Cells with C#, VB.NET

Written by  support iceblue
Rate this item
(0 votes)
Wrap text and unwrap text in excel cells are indispensable for developers. Wrap text is specially required when the excel text exceeds the column width or excel data cannot be shown completely. While unwrap text enables the cell data to be displayed in orderly rows and columns. In this section, a solution will be introduced for you to quickly wrap or unwrap text in excel with C#, VB.NET via a .NET Excel component.

 

Spire.XLS for .NET, as a standalone excel component, can help both enterprises and individuals to operate a wide range of tasks in Excel document such as convert excel to other formats, encrypt/decrypt excel, generate different kinds of charts and tables etc. Using this Excel component, you can easily wrap and unwrap through two lines of core code.

 

Suppose you want to wrap text in A1, you can set up the A1 cell text and wrap properties by Worksheet. Range["A1"].Text and Worksheet.Range["A1"].Style.WrapText = true. Of course if you want to unwrap text in A1, you can set the wrap property to be false. Now, please download Spire.XLS for .NET and preview the effect of your text wrap and unwrap task as below picture.

 

Wrap and Unwrap Excel Data

 

Wrap/Unwrap Text in Excel Cells with C#, VB.NET

 

C# Code Wrap/Unwrap Text in Excel Cells
using Spire.Xls;

namespace wrap
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a new workbook;
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];


            //Wrap the excel text;
            sheet.Range["C1"].Text = "e-iceblue is in facebook and welcome to like us";
            sheet.Range["C1"].Style.WrapText = true;
            sheet.Range["D1"].Text = "e-iceblue is in twitter and welcome to follow us";
            sheet.Range["D1"].Style.WrapText=  true;


            //Unwrap the excel text;
            sheet.Range["C2"].Text = "http://www.facebook.com/pages/e-iceblue/139657096082266";
            sheet.Range["C2"].Style.WrapText= false;
            sheet.Range["D2"].Text = "https://twitter.com/eiceblue";
            sheet.Range["D2"].Style.WrapText = false;


            //set the text color of Range["C1:D1"]
            sheet.Range["C1:D1"].Style.Font.Size = 15;
            sheet.Range["C1:D1"].Style.Font.Color = Color.Blue;
            //set the text color of Range["C2:D2"]
            sheet.Range["C2:D2"].Style.Font.Size = 15;
            sheet.Range["C2:D2"].Style.Font.Color = Color.DeepSkyBlue;

            // Save the project;
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);

        }
    }
}

          
VB.NET Code Wrap/Unwrap Text in Excel Cells
Imports Spire.Xls

Namespace wrap
    
    Class Program
        
        Private Shared Sub Main(ByVal args() As String)
            'Create a new workbook;
            Dim workbook As Workbook = New Workbook
            Dim sheet As Worksheet = workbook.Worksheets(0)
            'Wrap the excel text;
            sheet.Range("C1").Text = "e-iceblue is in facebook and welcome to like us"
            sheet.Range("C1").Style.WrapText = true
            sheet.Range("D1").Text = "e-iceblue is in twitter and welcome to follow us"
            sheet.Range("D1").Style.WrapText = true
            'Unwrap the excel text;
            sheet.Range("C2").Text = "http://www.facebook.com/pages/e-iceblue/139657096082266"
            sheet.Range("C2").Style.WrapText = false
            sheet.Range("D2").Text = "https://twitter.com/eiceblue"
            sheet.Range("D2").Style.WrapText = false
            'set the text color of Range["C1:D1"]
            sheet.Range("C1:D1").Style.Font.Size = 15
            sheet.Range("C1:D1").Style.Font.Color = Color.Blue
            'set the text color of Range["C2:D2"]
            sheet.Range("C2:D2").Style.Font.Size = 15
            sheet.Range("C2:D2").Style.Font.Color = Color.DeepSkyBlue
            ' Save the project;
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
            System.Diagnostics.Process.Start(workbook.FileName)
        End Sub
    End Class
End Namespace
          

 

Spire.XLS is a professional Excel component which enables developers/programmers to fast generate, read, write and modify Excel document for .NET and Silverlight, WPF.

 

More about this .NET Excel component

Additional Info

  • tutorial_title: Wrap/Unwrap Text in Excel Cells
Last modified on Wednesday, 08 January 2014 02:51