//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\WebsiteFlowChart[Template].xlsx"); workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; foreach (IShape shape in worksheet.Shapes) { //Centers text vertically. shape.TextFrame.VerticalAnchor = VerticalAnchor.AnchorMiddle; //Centers text horizontally. shape.TextFrame.HorizontalAnchor = HorizontalAnchor.Center; } // Save to an excel file workbook.Save("SetShapeTextAlignment.xlsx");
' Create a new Workbook Dim workbook As New Workbook 'Open an excel file Dim fileStream = GetResourceStream("xlsx\\WebsiteFlowChart[Template].xlsx") workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) For Each item In worksheet.Shapes 'Centers text vertically. item.TextFrame.VerticalAnchor = VerticalAnchor.AnchorMiddle 'Centers text horizontally. item.TextFrame.HorizontalAnchor = HorizontalAnchor.Center Next ' save to an excel file workbook.Save("SetShapeTextAlignment.xlsx")