在工作表中设置注释或形状的边距

可能的使用场景

Aspose.Cells 允许您使用形状.TextBody.TextAlignment财产。此属性返回的对象Aspose.Cells.Drawing.Texts.ShapeTextAlignment具有不同属性的类，例如顶边距点, 左边距点, 底边距点, 右边距点等，可用于设置上、左、下和右边距。

在工作表中设置注释或形状的边距

请参阅以下示例代码。它加载了示例 Excel 文件包含两个形状。代码一个一个地访问形状并设置它们的上、左、下和右边距。请参阅输出Excel文件由代码和屏幕截图生成，显示代码对输出 Excel 文件的影响。

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//Load the sample Excel file
Workbook wb = new Workbook("sampleSetMarginsOfCommentOrShapeInsideTheWorksheet.xlsx");

//Access first worksheet
Worksheet ws = wb.Worksheets[0];

foreach (Shape sh in ws.Shapes)
{
	//Access the text alignment
	Aspose.Cells.Drawing.Texts.ShapeTextAlignment txtAlign = sh.TextBody.TextAlignment;

	//Set auto margin false
	txtAlign.IsAutoMargin = false;

	//Set the top, left, bottom and right margins
	txtAlign.TopMarginPt = 10;
	txtAlign.LeftMarginPt = 10;
	txtAlign.BottomMarginPt = 10;
	txtAlign.RightMarginPt = 10;
}

//Save the output Excel file
wb.Save("outputSetMarginsOfCommentOrShapeInsideTheWorksheet.xlsx");