Search found 3 matches

by drrself
Sun Mar 05, 2023 2:34 pm
Forum: Coding Questions
Topic: excel control
Replies: 4
Views: 763

Re: excel control

that did it - thanks
I have been looking at the Residents -
but.... it hasn't been all that obvious to me
by drrself
Sun Mar 05, 2023 12:59 pm
Forum: Coding Questions
Topic: excel control
Replies: 4
Views: 763

Re: excel control

This worked Great - thanks so much -

I have another snag -
I can "set" the width of a column but have not found the way to "read" the width of an column in the excel

This works to SET the width of a column

exl\SetProperty("Columns('B:B')\ColumnWidth = 20")


this does NOT work to READ the ...
by drrself
Sat Mar 04, 2023 1:01 pm
Forum: Coding Questions
Topic: excel control
Replies: 4
Views: 763

excel control

trying my first PureBasic program - struggling to transition from XoJo -
have added Comate Plus - opening an Excel file - it has a number of Blank or empty rows throughout
I want to scan thru the rows and delete the blank rows
is there a Purebasic (or Comate) way to translate the Xojo
Worksheet ...