IXlsWorksheetRows
COM interface ( getting help with interfaces )

 

interface IXlsWorksheetRows : IDispatch
{

  [id(1), propget] HRESULT Height([out, retval]double* height);
  [id(1), propput] HRESULT Height([in]double height);
  [id(2), propget] HRESULT AutoFit([out, retval]BOOL* autofit);
  [id(2), propput] HRESULT AutoFit([in]BOOL autofit);
  [id(3),        ] HRESULT Insert([in]int amountRows);
  [id(4), propget] HRESULT LeftExtent([in]int col, [out, retval]int* leftcol);
  [id(5), propget] HRESULT RightExtent([in]int col, [out, retval]int* rightcol);
  [id(6),        ] HRESULT Delete();
  [id(7), propget] HRESULT Hide([out, retval]BOOL* hide);
  [id(7), propput] HRESULT Hide([in]BOOL hide);
  [id(8), propget] HRESULT Style([out, retval]IXlsStyle** style);
  [id(8), propput] HRESULT Style([in]IXlsStyle* style);
  [id(9), propget] HRESULT IsEmpty([out, retval]BOOL* isempty);

}

 

HRESULT Height([out, retval]int* height);
returns the height of each individual row. The height is expressed in pixels.

HRESULT Height([in]int height);
sets the height of each row. The height is expressed in pixels.

HRESULT AutoFit([out, retval]BOOL* autofit);
returns whether the rows should be auto-fit, i.e. automatically adjust to the largest height of the values in each row. Default value is false.

HRESULT AutoFit([in]BOOL autofit);
sets whether the rows should be auto-fit, i.e. automatically adjust to the largest height of the values in each row.

HRESULT Insert([in]int amountRows);
insert a number of rows, beginning at the top row range location.

HRESULT LeftExtent([in]int col, [out, retval]int* leftcol);
finds the most left non-empty column, starting from the passed column.

HRESULT RightExtent([in]int col, [out, retval]int* rightcol);
finds the most right non-empty column, starting from the passed column.

HRESULT Delete();
delete the rows.

HRESULT Hide([out, retval]BOOL* hide)
returns whether the rows should be hidden.

HRESULT Hide([in]BOOL hide);
sets whether the rows should be hidden.

HRESULT Style([out, retval]IXlsStyle** style);
returns the formatting style for the rows.

HRESULT Style([in]IXlsStyle* style);
defines the formatting style for the rows.

HRESULT IsEmpty([out, retval]BOOL* isempty);
returns whether the rows are empty.