>>Hi,
>>
>>Anybody knows how to apply the method SetCellWordWrap() to set a column of the resulting Excel spreadsheet to Word Wrap?
>>
>>My code that converts an open cursor to the Excel is as follows:
>>
>>
>>*-- The cursor is which is converted to Excel is open at this point. Then simply calling the method
>>*-- SaveTabletoWorkbook() (as seen below) creates excel.
>>loExcel.SaveTabletoWorkbook(lcCursorName, cExcelFileName, .T., .T., tcWorkSheetName)
>>
>>
>>The documentation refers to method SetCellWordWrap() which is supposed to set a cell to word-wrap. But how do I apply it, I am not clear.
>
>It's been years since the last time I had excel on my machine, so off the top of my head... shouldn't all formatting methods accept ranges as parameters? Or, alternatively, wouldn't any range have this method?
>
>In the latter case
>
>loRange=oWorkbook.range("C")
>loRange.SetCellWordWrap()
>
>with perhaps .t. as parameter to set it on or .f. for off.
>
>>UPDATE: Is it against the etiquette of UT to address this message to Greg Green (since he may not be online on regular basis)?
>
>With the easily offended out of the picture, it's up to you. You may wait for him to see the message.
1. On your first suggestion. The method SetCellWordWrap accepts 5 parameters (LPARAMETERS tnWB, tnSheet, tnCellRow, tnCellCol, tlWordWrap). My code (above) creates the Excel file. But I have no idea how to get the Id to the work book and Id to the sheet in workbook (first 2 parameters). The last parameter is pretty obvious, .T.
2. I will wait a day or two before I address the message directly to Greg.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham