How to draw table in excel


  • Hi all. i can use to insert data into excel but i dont know how to insert table ?

    Ex:  id       name
           01      jack
           02      luchy

       i want to insert table with it.
       what should i do ?
    Friday, August 07, 2009 7:04 AM


  • Hi Sopheak,

        I think i got the effect that you want.
        Please add the following code in the method
        With oSheet
            .Range(.Cells(1, 1), _
                .Cells(3, 2)).Borders.LineStyle = Excel.XlBorderWeight.xlHairline
        End With

    Hope this helps.

    Jeff Shan
    • Marked as answer by Sopheak.KH Wednesday, August 12, 2009 1:26 PM
    Wednesday, August 12, 2009 7:20 AM

All replies