Sign in to follow this  
Followers 0
gcue

excel: autosize column width?

8 posts in this topic

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



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

so how can i use that syntax in autoit?

Share this post


Link to post
Share on other sites

#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

#5 ·  Posted (edited)

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

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

hehe

thanks again!

Share this post


Link to post
Share on other sites

You're using the first five columns. Try:

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

Share this post


Link to post
Share on other sites

even better... many many thanks!

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  
Followers 0