Vb.Net change Excel row height

How do I change the height of a row in excel using VB.net?
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


noobe1Author Commented:
Exactly what I'm looking for. Thanks
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.