在VSTO和Aspose.Cells中旋转单元格文字
Contents
[
Hide
]
要旋转工作表中单元格中的文本,请按以下步骤进行:
- 创建一个工作簿并获取一个工作表。
- 添加示例文本。
- 格式化文本:旋转,添加背景颜色。
- 保存文件。 随后的代码示例展示了如何先在VSTO中使用C#执行这些步骤,然后再在Aspose.Cells中使用C#执行这些步骤。
VSTO
//intiate 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 some 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 fillment 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 work book
objworkbook.Save("RotateText_test.xlsx");