Hi
Try using XLStyle object.
Define Three styles as:
Dim Style1 As XLStyle = New
XLStyle(book)
Dim Style2 As XLStyle = New
XLStyle(book)
Dim Style3 As XLStyle = New
XLStyle(book)
Style1.AlignHorz =
XLAlignHorzEnum.Left
Style2.AlignHorz =
XLAlignHorzEnum.Centre
Style3.AlignHorz =
XLAlignHorzEnum.Right
And then assign these styles to the respective
XLCell.Style property.
Regards
Dave
How to set indent for a XLS cell?
I want to show my cells with indents (say 3 blank spaces before the text).
I am showing cells as tree kind of view like as follows:
**************************
Section 1
Section 1.1
Section 1.2
Section 1.2.1
Section 1.2.2
Section 1.3
Section 1.4
Section 2
Section 2.1
............
*************************
Above example data should be shown in a single column...
Anybody let me know how to set indent for a cell.
Thanks in Advance.
Thiyagarajan.
http://helpcentral.componentone.com/cs/forums/p/75004/204023.aspx#204023