Jump to content
Sign in to follow this  
gcue

excel: autosize column width?

Recommended Posts

gcue

hello.

im using the excel udf that comes with the new version of autoit 3.3.0.0

is there a way to autoexpand or autosize the column width?

i remember seeing the development of this udf and noting a _excelsetcolumnwidth function along the lines...

Share this post


Link to post
Share on other sites
WideBoyDixon

In Excel, there's a method which can be applied to Range objects called AutoFit. I guess this is what you're after. In VBA:

ActiveSheet.Columns(1).AutoFit

Share this post


Link to post
Share on other sites
gcue

so how can i use that syntax in autoit?

Share this post


Link to post
Share on other sites
WideBoyDixon

#include <Excel.au3>
Local $oExcel = _ExcelBookNew(1)
_ExcelWriteCell($oExcel, "Something Long Here", 1, 1)
_ExcelWriteCell($oExcel, "And something even longer", 2, 1)
$oExcel.ActiveSheet.Columns(1).AutoFit

Share this post


Link to post
Share on other sites
gcue

hmm not working... do i have to specify the activesheet name?

_ExcelSheetActivate($oExcel, "PRINTERS")
                    _ExcelWriteCell($oExcel, $asset_label, $p + 1, 1)
                    _ExcelWriteCell($oExcel, $asset, $p + 1, 2)
                    _ExcelWriteCell($oExcel, $printers[$p][0], $p + 1, 3)
                    _ExcelWriteCell($oExcel, "YES", $p + 1, 4)
                    _ExcelWriteCell($oExcel, $printernote, $p + 1, 5)
                    $oExcel.ActiveSheet.Columns(1).AutoFit

thanks for your help btw!!!

Edited by gcue

Share this post


Link to post
Share on other sites
gcue

ahh nevermind!! i got it... columns(##)

hehe

thanks again!

Share this post


Link to post
Share on other sites
WideBoyDixon

You're using the first five columns. Try:

$oExcel.ActiveSheet.Columns("A:E").AutoFit
  • Thanks 1

Share this post


Link to post
Share on other sites
gcue

even better... many many thanks!

Share this post


Link to post
Share on other sites
AnonymousX
On 4/14/2009 at 7:48 AM, WideBoyDixon said:

You're using the first five columns. Try:

 

$oExcel.ActiveSheet.Columns("A:E").AutoFit

Got to love when posts from almost a decade ago are still useful =)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.