Page 1 of 1

How to align text in center using vb.net

PostPosted: Fri Nov 29, 2019 7:34 am
by npandit
Hello
I have merged the following cells using the code:
ocell98=oSheet.getCellrangeByname("A3:B6")
ocell98.merge(true)
However i want to align the text of ocell98 in center
Can anyone suggest how to set alignment of text ?

Re: How to align text in center using vb.net

PostPosted: Fri Nov 29, 2019 7:54 am
by Zizi64
Can anyone suggest how to set alignment of text ?


Just apply your own cell style (manually or by your code). The direct formatting method is not too efficient.