Is there a style sheet command to Auto fit the excel cells for width and row height in EXL07 format?

This message has been edited. Last edited by: FP Mod Chuck,

None that I know of. I do it with the following commands in an excel macro. For example, if my data starts in row 5 col 1:

  ws_last_row = Cells.SpecialCells(xlLastCell).Row
  ws_last_col = Cells.SpecialCells(xlLastCell).Column
  Range(Cells(5, 1), Cells(ws_last_row, ws_last_col)).Select
  Selection.WrapText = False
  Selection.Columns.AutoFit

I do all kinds of formatting using Auto_Open macros that can't be done in WebFOCUS or at least not easily.

This message has been edited. Last edited by: jgelona,

To control the row height, this helps:

TYPE=REPORT, WRAP=OFF, $

Good info...