- Demo
- C# source
- VB.Net source
The sample demonstrates how to design text direction in excel spreadsheet.

using Spire.Xls;
namespace TextDirection
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\..\..\Data\Blank.xls",ExcelVersion.Version97to2003);
Worksheet worksheet = workbook.Worksheets[0];
//rotate 90 degrees of Range["A1"] text
worksheet.Range["A1"].Text = "Rotate 30 degrees";
worksheet.Range["A1"].Style.Rotation = 90;
//rotate 30 degrees of Range["A2"] text
worksheet.Range["A2"].Text = "Rotate 45 degrees";
worksheet.Range["A2"].Style.Rotation = 30;
//rotate 45 degrees of Range["B1"] text
worksheet.Range["B1"].Text = "Rotate 90 degrees";
worksheet.Range["B1"].Style.Rotation = 45;
//rotate 180 degrees of Range["B2"] text
worksheet.Range["B2"].Text = "Rotate 180 degrees";
worksheet.Range["B2"].Style.Rotation = 180;
worksheet.AutoFitColumn(1);
worksheet.AutoFitColumn(2);
workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
System.Diagnostics.Process.Start(workbook.FileName);
}
}
}
Imports Spire.Xls
Namespace TextDirection
Friend Class Program
Shared Sub Main(ByVal args() As String)
Dim workbook As New Workbook()
workbook.LoadFromFile("..\..\..\..\Data\Blank.xls",ExcelVersion.Version97to2003)
Dim worksheet As Worksheet = workbook.Worksheets(0)
'rotate 90 degrees of Range["A1"] text
worksheet.Range("A1").Text = "Rotate 30 degrees"
worksheet.Range("A1").Style.Rotation = 90
'rotate 30 degrees of Range["A2"] text
worksheet.Range("A2").Text = "Rotate 45 degrees"
worksheet.Range("A2").Style.Rotation = 30
'rotate 45 degrees of Range["B1"] text
worksheet.Range("B1").Text = "Rotate 90 degrees"
worksheet.Range("B1").Style.Rotation = 45
'rotate 180 degrees of Range["B2"] text
worksheet.Range("B2").Text = "Rotate 180 degrees"
worksheet.Range("B2").Style.Rotation = 180
worksheet.AutoFitColumn(1)
worksheet.AutoFitColumn(2)
workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
System.Diagnostics.Process.Start(workbook.FileName)
End Sub
End Class
End Namespace
