 |
| IXlsWorksheetColumns |
|
COM interface ( getting help with interfaces )
interface IXlsWorksheetColumns : IDispatch
{
[id(1), propget] HRESULT Width([out, retval]double* width);
[id(1), propput] HRESULT Width([in]double width);
[id(2), propget] HRESULT AutoFit([out, retval]BOOL* autofit);
[id(2), propput] HRESULT AutoFit([in]BOOL autofit);
[id(3), ] HRESULT Insert([in]int amountColumns);
[id(4), propget] HRESULT TopExtent([in]int row, [out, retval]int* toprow);
[id(5), propget] HRESULT BottomExtent([in]int row, [out, retval]int* bottomrow);
[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 Width([out, retval]double* width);
returns the width of each individualcolumn. The width is not expressed in pixels, but instead amounts the proportional size of a nominal character of size 8 pts.
HRESULT Width([in]double width);
sets the width of each column. The width is not expressed in pixels, but instead amounts the proportional size of a nominal character of size 8 pts.
HRESULT AutoFit([out, retval]BOOL* autofit);
returns whether the columns should be auto-fit, i.e. automatically adjust to the largest width of the values in each column. Default value is false.
HRESULT AutoFit([in]BOOL autofit);
sets whether the columns should be auto-fit, i.e. automatically adjust to the largest width of the values in each column.
HRESULT Insert([in]int amountColumns);
insert a number of columns, beginning at the left column range location.
HRESULT TopExtent([in]int row, [out, retval]int* toprow);
finds the top non-empty row, starting from the passed row.
HRESULT BottomExtent([in]int row, [out, retval]int* bottomrow);
finds the bottom non-empty row, starting from the passed row.
HRESULT Delete();
delete the columns.
HRESULT Hide([out, retval]BOOL* hide)
returns whether the columns should be hidden.
HRESULT Hide([in]BOOL hide);
sets whether the columns should be hidden.
HRESULT Style([out, retval]IXlsStyle** style);
returns the formatting style for the columns.
HRESULT Style([in]IXlsStyle* style);
defines the formatting style for the columns.
HRESULT IsEmpty([out, retval]BOOL* isempty);
returns whether the columns are empty.