VB.net Excel adding theme format as table

Question

I am trying to figure out how to add a theme to my excel worksheet before saving it. I have found this code to change the cell color but have yet to find anything to change to a pre-default excel table format (the Table style light 2 theme)

    With xlSheet.Range("A:D").Interior
        .Pattern = Excel.XlPattern.xlPatternLinearGradient
        .Gradient.Degree = 60
        .Gradient.ColorStops.Clear()

        With .Gradient.ColorStops.Add(0)
            .ThemeColor = Excel.XlThemeColor.xlThemeColorAccent1
            .TintAndShade = 0
        End With
    End With

How can i just select all the cells and place that Table style light 2 onto them all using VB.net?

Any help would be great! Thanks! :o)

David

chris neilsen · Accepted Answer · 2011-02-25 21:48:26Z

1

Try

Selection.Style = "Style name"

answered Feb 25, 2011 at 21:48

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

StealthRT · Accepted Answer · 2011-02-28 14:47:53Z

0

I got it by using the following:

xlSheet.Range("Table1[#All]").Select()
xlSheet.ListObjects("Table1").TableStyle = "TableStyleLight2"

David

answered Feb 28, 2011 at 14:47

StealthRT

10.6k41 gold badges195 silver badges371 bronze badges

Collectives™ on Stack Overflow

VB.net Excel adding theme format as table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related