How to apply/set text alignment to textbox
TextBoxes can improve the expressiveness of our documents and diagrams, and applying different alignments to different parts of a TextBox can help highlight points of interest to readers. But the default alignment of TextBox does not meet all our needs.For this, you may need to adjust each TextBox to meet your target requirements. If you don’t have a lot of TextBox objects to tweak, you’re in luck. If there are so many TextBoxes to adjust, I think you will be in trouble. Don’t worry now, Aspose.Cells provides such an API interface to help you do just that.
The following sample code applies text alignment to a TextBox.
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = ""; | |
if (!System.IO.Directory.Exists(dataDir)) | |
{ | |
System.IO.Directory.CreateDirectory(dataDir); | |
} | |
//Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
ShapeCollection shapes = workbook.Worksheets[0].Shapes; | |
//add a TextBox | |
Shape shape = shapes.AddTextBox(2, 0, 2, 0, 50, 120); | |
shape.Text = "This is a test."; | |
//set alignment | |
shape.TextHorizontalAlignment = TextAlignmentType.Center; | |
shape.TextVerticalAlignment = TextAlignmentType.Center; | |
//Save the excel file. | |
workbook.Save(dataDir + "result.xlsx"); |
You can also change the text alignment of some text inside a TextBox shape with the appropriate HTML text.The following sample code applies the text alignment to partial text inside the TextBox.
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// Intialize an object of the Workbook class to load template file | |
Workbook sourceWb = new Workbook("SampleTextboxExcel2016.xlsx"); | |
// Access the target textbox whose text is to be aligned | |
var sourceTextBox = sourceWb.Worksheets[0].Shapes[0]; | |
// Create and object of the target workbook | |
var destWb = new Workbook(); | |
// Access first worksheet from the collection | |
var _sheet = destWb.Worksheets[0]; | |
//Create new textbox | |
TextBox _textBox = (TextBox)_sheet.Shapes.AddShape( MsoDrawingType.TextBox,1, 0, 1, 0, 200, 200); | |
// Alternatively text box can be added using following line as well | |
// TextBox _textBox = _sheet.Shapes.AddTextBox(1, 0, 1, 0, 200, 200); | |
// Use Html string from a template file textbox | |
_textBox.HtmlText = sourceTextBox.HtmlText; | |
// Save the workbook on disc | |
destWb.Save("Output.xlsx"); |