Page 1 of 1
oSheet:Columns() range question
Posted: Tue Jan 07, 2020 8:40 am
by 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.
Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 1:07 pm
by Jimmy
Marc Vanzegbroeck wrote: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()
Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 1:19 pm
by 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", '@' )
Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 2:42 pm
by Marc Vanzegbroeck
Ok, I found a solution for it with the range() object.
Thanks
Marc Vanzegbroeck wrote: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", '@' )