Vb.Net change Excel row height

How do I change the height of a row in excel using VB.net?
Thanks
noobe1Asked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
Hi noobe1.

Could you give us more information?  Do you need to know how to manipulate Excel from VB.Net, or do you just need to know how to adjust the row height? If the latter, you can use something like this....

    Dim XL As New Excel.Application
    Dim XLwb As Excel.Workbook = XL.Workbooks.Open("C:\Path\Workbook.xls")
    Dim WLws As Excel.Worksheet = XLwb.Worksheets("Sheet1")

    XLws.Rows("8:8").RowHeight = 52
    '....etc

Regards,

Wayne
0
 
noobe1Author Commented:
Exactly what I'm looking for. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.