VB.Net - Excel Automation Set Column Width on Headings
Good Day Experts!
Making good progress on my little project and am working on the export to Excel from VB.net. There really isn't too much data that needs to get pushed across but a formatting issue is troubling me.
I put 8 known column headings in cells 3,1 to 3,8. Now I need to be able to do the equivalent in code of going to the worksheet and doublicking in between column A and B B and C and so on to get the columns to be as wide as the text that I am putting in 3,1 to 3,8.