Reputation: 43
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?
Upvotes: 3
Views: 4263
Reputation: 149305
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?
Upvotes: 1