Hi,

I am performing Export to Excel. Inside Excel i am adding Rectangular Shapes along with the Text.

For the text inside the shapes i am using Infragistics.Document.Excels.FormattedText

Code snippet for adding shape with text in excel:

RectangleShape shape = (RectangleShape)WorksheetShape.CreatePredefinedShape(PredefinedShapeType.Rectangle);

FormattedText fs = new FormattedText("Text1");

fs.GetFont(0, 5).Name = "Arial";

fs.GetFont(0, 5).Height = 140;

shape.Text = fs;

shape.SetBoundsInTwips(this.gridWorkSheet, new Rectangle(1185, 1800, 1935, 500));

this.gridWorkSheet.Shapes.Add(shape);

QUERIES:

1) How can i aligned the Text inside the shapes to be CENTER aligned ?

2) How can i reduce the Width(or line weight) of the Shapes in excel using code?

I have attached the screen shot for better understanding

Thanks,

Chitra