 |
| 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);
[id(10) ] HRESULT Move([in]int amountColumns);
[id(11),propget] HRESULT Position([out, retval]int* positionInPixels);
[id(12),propget] HRESULT Range([out, retval]IXlsRange** range);
[id(13),propget] HRESULT WidthInPixels([out, retval]int* width_pixels);
[id(13),propput] HRESULT WidthInPixels([in]int width_pixels);
[id(14),propget] HRESULT Outline([out, retval]enumOutlineLevel* level);
}
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.
HRESULT Move([in]int amountColumns);
moves the columns left or right by the amount passed in parameter.
HRESULT Position([out, retval]int* positionInPixels);
returns the position in pixels of the left of the column. The reference for pixels is the top left corner, A1. For instance, column A is at 0 pixel.
HRESULT Range([out, retval]IXlsRange** range);
returns the range object for the columns.
HRESULT WidthInPixels([out, retval]int* width_pixels);
returns the width of each individual column, expressed in pixels.
HRESULT WidthInPixels([in]int width_pixels);
sets the width of each individual column, expressed in pixels.
HRESULT Outline([out, retval]enumOutlineLevel* level);
returns the outline level.