 |
| 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);
[id(10) ] HRESULT Move([in]int amountRows);
[id(11),propget] HRESULT Position([out, retval]int* positionInPixels);
[id(12),propget] HRESULT Range([out, retval]IXlsRange** range);
[id(13),propget] HRESULT Outline([out, retval]enumOutlineLevel* level);
}
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.
HRESULT Move([in]int amountRows);
moves the rows top or bottom by the amount passed in parameter.
HRESULT Position([out, retval]int* positionInPixels);
returns the position in pixels of the top of the row. The reference for pixels is the top left corner, A1. For instance, the first row is at 0 pixel.
HRESULT Range([out, retval]IXlsRange** range);
returns the range object for the rows.
HRESULT Outline([out, retval]enumOutlineLevel* level);
returns the outline level.