Sign in to follow this  
Followers 0

excel: autosize column width?

8 posts in this topic

Posted

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



Posted

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

Posted

so how can i use that syntax in autoit?

Share this post


Link to post
Share on other sites

Posted

#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

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

Posted

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

hehe

thanks again!

Share this post


Link to post
Share on other sites

Posted

You're using the first five columns. Try:

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

Share this post


Link to post
Share on other sites

Posted

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