none
programatically formatting a column to text wrap RRS feed

  • Question

  •  

    Hi everyone;

     

    I have a table being exported to Excel from Visual Foxpro.  One of the columns needs to have text wrapping set to on.  Is this possible to do from the application object?

     

    I have tried this..

     

     

    ** after copying change text wrap in column 7 to true

    loExcel = CREATEOBJECT("Excel.Application")

    loExcel.WorkBooks.Open(lcFile)

    loExcel.WorkBooks(1).Worksheets(1).Columns(7).Cells.WrapText = .T.

    loExcel.WorkBooks(1).SaveAs(lcFile)

    loExcel.Quit() && If you don't do this, it seems to leave a hidden copy of Excel open

    loExcel = NULL

     

    but it doesn't work.

     

     

    Wednesday, January 2, 2008 6:06 PM