topic-38323

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

oSheet:Columns() range question
Posted: Tue Jan 07, 2020 08:40 AM

Hi,

Now I'm using

[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

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 01:07 PM

Marc Vanzegbroeck wrote:Hi,

Now I'm using
Code (fw): Select all Collapse
[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 (fw): Select all Collapse

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

but you don't need it when use this

Code (fw): Select all Collapse

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

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

greeting,

Jimmy

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 01:19 PM

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 (fw): Select all Collapse

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

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: oSheet:Columns() range question
Posted: Tue Jan 07, 2020 02:42 PM

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 (fw): Select all Collapse
oSheet:Columns(  "A:ZZ" ):Set( "NumberFormat",  '@'     )

FiveTech Support Forums

Continue the discussion