I don't know how I got any work done before the internet

[andrewducker]

I was writing something to automatically produce an Excel report on our DB2 usage, and I wanted to automatically resize the columns. A quick google for excel autosize columns c# and the second hit told me the answer was "Worksheet.UsedRange.Columns.AutoFit();"

I could go and try and find the answer via the help files, but I suspect I'd be looking for a while. Google really is my best friend when coding. Well, that and Resharper.

Comments

[crm.livejournal.com]

the excell OLE/API makes it a really powerful scripting / database tool... just... good luck finding any documentation on it.

[andrewducker]

Yeah, the documentation is awful - what I tended to do when I was first learning it was record a macro, and then go see what VBA was produced by it, and then translate that as best I could.

[crm.livejournal.com]

with microsoft though - i imigine thats similar to making a website in front page, then opening it in a text editor to learn html.

[broin.livejournal.com]

Goodness, yes.

I've pretended to have lots of skillsets thanks to pasting code from forums. ;)