Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2445
  • Last Modified:

Vb.Net change Excel row height

How do I change the height of a row in excel using VB.net?
Thanks
0
noobe1
Asked:
noobe1
1 Solution
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now