oSheet:Columns() range question

[Marc Vanzegbroeck]

Hi,

Now I'm using

Code: Select all

[code]oSheet:Columns( "A:ZZ" ):AutoFit()

[/code]
to set the autofit.

Is it possible to give instead of "A:ZZ" the range with numbers?
Now I have to calculate the range to convert it to characters.

[Jimmy]

Hi,

Now I'm using

Code: Select all

[code]oSheet:Columns( "A:ZZ" ):AutoFit()

[/code]
to set the autofit.

Is it possible to give instead of "A:ZZ" the range with numbers?
Now I have to calculate the range to convert it to characters.

you can calculate it this Way

Code: Select all

numRows := oWorkBook:workSheets( 1 ) :usedRange:Rows:Count
numColumns := oWorkBook:workSheets( 1 ) :usedRange:Columns:Count

but you don't need it when use this

Code: Select all

// Speed things up by creating an object containing the cells
oSheet := oExcel:Worksheets( 1 ) :cells

// fit all Column to optimal size
oSheet:EntireColumn:AutoFit()

[Marc Vanzegbroeck]

Jimmy,

Thank you for your answer.
Indeed, I can use oSheet:EntireColumn:AutoFit() for the complete excel, but what If I want to do it for column 1 to 30?

Another example is if I want to set the cell-format for only column 1 to 30

Code: Select all

oSheet:Columns(  "A:ZZ" ):Set( "NumberFormat",  '@'     )

[Marc Vanzegbroeck]

Ok, I found a solution for it with the range() object.

Thanks

Jimmy,

Thank you for your answer.
Indeed, I can use oSheet:EntireColumn:AutoFit() for the complete excel, but what If I want to do it for column 1 to 30?

Another example is if I want to set the cell-format for only column 1 to 30

Code: Select all

oSheet:Columns(  "A:ZZ" ):Set( "NumberFormat",  '@'     )