VB.NET and Excel table formatting

Question

I wrote a small program in VB.NET to export data from DataGrid to Excel and it works perfectly. My manager now wants me to display the data in a presentable format. How should I go about it. I recorded a macro but was unable to apply that in vb.net. Is there any good tutorial which covers this?

Siddharth Rout · Accepted Answer · 2012-09-12 15:13:50Z

1

Recording Macros was a good start :) You can either show what you recorded and then I can take you through it or if you want you can have a look at this link

Topic: VB.NET and Excel

Link: http://www.siddharthrout.com/vb-dot-net-and-excel/

See Point 8 "Creating/Formatting a Table"

BTW which Excel version are you using?

edited Sep 12, 2012 at 15:13

answered Feb 29, 2012 at 19:59

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

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

4 Comments

user1140588 Over a year ago

Thanks for the quick reply. I'm using Excel 2010 and VB.NET 2010. I'm going thru your link.

Siddharth Rout Over a year ago

@user1140588: Then that link will definitely help you :)

user1140588 Over a year ago

Simply Awesome!!!! It works. You made my day!!! BTW is that your blog? I found some other interesting stuff that I can do in Excel from vb.net like creating charts from the exported data. My Manager is definitely going to be very pleased with me. All thanks to you.

Siddharth Rout Over a year ago

@user1140588: Glad to be of help :) Yes that is my blog.

Collectives™ on Stack Overflow

VB.NET and Excel table formatting

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related