Rotating Cell Text in VSTO and Aspose.Cells

To rotate text in a cell on a worksheet, take the following steps:

1. Create a workbook and get a worksheet.
2. Add sample text.
3. Format the text: rotate, add background color.
4. Save the file.

The code samples that follow show how to perform these steps first in VSTO, using C#, and then in Aspose.Cells, again using C#.

VSTO

 // Initiate Application object

Excel.Application ExcelApp = Application;

// Add a Workbook.

Excel.Workbook objBook = ExcelApp.Workbooks.Add(System.Reflection.Missing.Value);

// Get the first sheet.

Excel.Worksheet objSheet = (Excel.Worksheet)objBook.Sheets["Sheet1"];

// Put some text into cell B2.

objSheet.Cells[2, 2] = "Aspose Heading";

// Define a range object (B2).

Excel.Range _range;

_range = objSheet.get_Range("B2", "B2");

// Specify the angle of rotation of the text.

_range.Orientation = 45;

// Set the background color.

_range.Interior.Color = System.Drawing.ColorTranslator.ToWin32(Color.FromArgb(0, 51, 105));

// Set the font color of cell text.

_range.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);

// Save the Excel file.

objBook.SaveCopyAs("VSTO_RotateText_test.xlsx");

// Quit the Application.

ExcelApp.Quit();

Aspose.Cells

 // Instantiate a new Workbook.

Workbook objworkbook = new Workbook();

// Get the first sheet.

Worksheet objworksheet = objworkbook.Worksheets[0];

// Get Cells.

Cells objcells = objworksheet.Cells;

// Get a particular cell.

Cell objcell = objcells["B2"];

// Put a text value.

objcell.PutValue("Aspose Heading");

// Get associated style object of the cell.

Style objstyle = objcell.GetStyle();

// Specify the angle of rotation of the text.

objstyle.RotationAngle = 45;

// Set the custom fill color of the cells.

objstyle.ForegroundColor = Color.FromArgb(0, 51, 105);

// Set the background pattern for fill color.

objstyle.Pattern = BackgroundType.Solid;

// Set the font color of cell text.

objstyle.Font.Color = Color.White;

// Assign the updated style object back to the cell.

objcell.SetStyle(objstyle);

// Save the workbook.

objworkbook.Save("RotateText_test.xlsx");

Download Sample Code

• GitHub
• SourceForge
• Bitbucket