I need help formatting a cell in Excel from my VB.Net application
Posted on 2011-05-02
I have a VB.Net application and I need to put a string value in an Excel cell. The string has two words in it. I have to put the first word in Size 22 Arial font and the second half of the string in Size 10 Arial font. I cannot put each word in a separate cell. They have to be in the same cell. How can I do this? How can I apply this type of formatting?
Below is some sample code of how i put the string in Excel from my vb.net app:
objWkB.ActiveSheet.Cells(intRows, 1).Value = arrStorage(intCounter, 0)